Vedr: IDS: How can I display the databases imported in an dbspace?
--0__=h6244vWGBwcHI8PXIveQpX2Gzr9dC5ii5ceUWK3dVPgALdCQJ8LKebaX
Content-type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-transfer-encoding: quoted-printable
Try this store procedure:
SQL ex: Shows all databases
execute procedure sp_databases ();database owner dpspace
ak_hurrican informix dx_hurrican_dbs
fw_fdb informix dx_fdb_dbs
sysmaster informix dx_root_dbs
syspgm4gl informix dx_syspgm4gl_dbs
tt_test abrbwj dx_root_dbs
sysutils informix dx_root_dbs
SQL ex: Shows databases in rootdbs not owned by informix
execute procedure sp_databases ('x');Output eksempel: Lister database, ejer, dbspace sortered p=E5 database.=
database owner dpspace
tt_test abrbwj dx_root_dbs
Script to create procedure:
DROP PROCEDURE informix.sp_databases;
-----------------------------------------------------------------------=
----
--
-- Creation Date : 1999-09-06 08:53:01.00000
--
-- Server : udv0_tn1
--
-- Created By : informix
--
-- Database : sysutils
--
-- Owner : informix
--
-- Object Name : sp_databases
--
-- Type : PROCEDURE
--
-----------------------------------------------------------------------=
----
--
CREATE PROCEDURE informix.sp_databases (db_check char(1) default NULL)=
RETURNING char(18), char(18), char(18);
DEFINE o_name char(18);
DEFINE o_ejer char(18);
DEFINE o_dbsname char(18);
IF db_check is NULL THEN
FOREACH
select a.name, a.owner, b.name
into o_name, o_ejer, o_dbsname
from sysmaster:sysdatabases a, sysmaster:sysdbspaces b
where trunc(a.partnum/1048576) =3D b.dbsnum
order by a.nameRETURN o_name, o_ejer, o_dbsname WITH RESUME;
END FOREACH;
ELSE
FOREACH
select a.name, a.owner, b.name
into o_name, o_ejer, o_dbsname
from sysmaster:sysdatabases a, sysmaster:sysdbspaces b
where trunc(a.partnum/1048576) =3D b.dbsnum and
b.name =3D 'dx_root_dbs' and
a.owner !=3D 'informix'
order by a.nameRETURN o_name, o_ejer, o_dbsname WITH RESUME;
END FOREACH;
END IF;
END PROCEDURE;
Bjarne
Alm. Brand
Denmark
"Huy Vu" <huyv@usa.net> - 02-09-99 00:33:51
Besvar venligst til "Huy Vu" <huyv@usa.net>
Til: informix-list@iiug.org
cc: (bcc: Bjarne Wilken Jensen/ABR/ALMBRAND)
Vedr=F8rende: IDS: How can I display the databases imported in an db=
space?
=
--0__=h6244vWGBwcHI8PXIveQpX2Gzr9dC5ii5ceUWK3dVPgALdCQJ8LKebaX
Content-type: text/plain; charset=us-ascii
Content-Disposition: inline
Hi all,
I would like to do a script to display a list of informix databases
imported
in a specific dbspace.... (for Online Informix server)
I hope I will receive some advises from you.
Thanks in advance for any help
H.V
--0__=h6244vWGBwcHI8PXIveQpX2Gzr9dC5ii5ceUWK3dVPgALdCQJ8LKebaX--