Re: tables in dbspace (Online 5.x)
>
> Is there a simple way to find which tables are in a dbspace?
> (Or, what dbspace a table is in?)
>
> -Brian
> ------
> brena@hcia.com
>
Following is a mail posted sometimes back by Graeme Sargent which gives you
the dbspace name
+--------------------------+---------------------------+
| G.T.Madavan, | e-mail: gtmad@smi.mn.org |
| Systems Migration Inc., | Phone : (612) 890-0040 |
| Burnsville, MN, U.S.A | Fax : (612) 890-0966 |
+--------------------------+---------------------------+
############## OLD MAIL ################
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.