DBspace Question

Posted in 1993

Richard E. Bowman — Tue, 28 Sep 93 10:07:47 CDT — source: Informix-list mailing list archive (1991-1998)

I'm looking for a way in a sql statement to have on-line return me based on a given table name the dbspace name that the table is located in. The following sql statment returns the dbspace number the table is located in but what I need is the actual dbspace name. select hex(partnum) from systables where tabname = "table_name" returns "0x0300008B" ^ |--- This is the dbspace number. Any help here would be greatly appreciated. -- Please respond to: ******************** Richard E. Bowman Intergraph Corp rebowman@ingr.com (205)730-4175 ********************