Re: DBspace Question
In <289m2sINNq8c@emory.mathcs.emory.edu> rebowman@catsii.b8.ingr.com (Richard E. Bowman) writes:
> 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.
Run "dbaccess - $INFORMIXDIR/etc/makeps.sql" then execute the query:
SELECT name FROM systables, master:sysdbstab -- Needs OnLine >= 5.00
WHERE dbsnum = TRUNC(partnum/16777216, 0)
AND tabname = "table_name";
graeme
--
Disclaimer: The author's opinions are his own, and not necessarily
those of Pyramid Technology Ltd. or Pyramid Technology Inc.
---------------------------------------------------------------------------
-m------- Graeme Sargent Voice: +44 (0)252 373035
---mmm----- Senior Database Consultant Fax : +44 (0)252 373135
-----mmmmm--- Pyramid Technology Ltd. Telex: Tell who???
-------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@pyra.co.uk
---------------------------------------------------------------------------
We have the technology. The tricky bit is learning how to use it.