RE: Using DBINFO

Posted in 2005

Dirk Moolman — Tue, 12 Jul 2005 13:38:09 +0200 — source: Usenet: comp.databases.informix

Add the following to your query: And partnum != 0 Ie: select tabid, tabname, hex(partnum) from systables where tabtype = 'T' and partnum != 0 order by 1 -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Colin Dawson Sent: 11 July 2005 02:50 PM To: informix-list@iiug.org Subject: Using DBINFO If I run the following select tabid, tabname, hex(partnum) from systables where tabtype = 'T' order by 1 I get a nice list of all tables and their respective partnum ordered by tabid If I run the same query with , DBINFO('DBSPACE',partnum) added to the list of columns, I get 727: Invalid or NULL TBLspace number given to dbinfo(dbspace). If I do the same on a different DB on the same server it works perfectly Anybody got any clues? Regards Colin Dawson sending to informix-list sending to informix-list