select system table to tell all the raw tables!!
Dear All...
I've IDS 11.50.UC4 in RedHat Enterprise Linux 5.2 , so glad that
raw table can have index in it in this IDS version, that really help a lot ,
I like to know how many tables I already modify to raw table already ,
dbschema -d db1 db1.sql -ss would satisfy my needs ,but , if I can select from system table like :
select * from systables
where tabid > 99
and get all the raw tables' name would be better ,
can anyone give me a hint which system table have the information ?!
Thanks and forgive me for my english ~
SELECT tabname
FROM systables
WHERE MOD( (flags / 16), 2) = 1;
Art
Art S. Kagel
AdvanceDataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.org)
See you at the 2010 IIUG Informix Conference
April 25-28, 2010
Overland Park (Kansas City), KS
www.iiug.org/conf
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.
On Wed, Jan 6, 2010 at 10:21 PM, MARS CHEN <mars@jsun.com> wrote:
> Dear All...
>
> I've IDS 11.50.UC4 in RedHat Enterprise Linux 5.2 , so glad that
> raw table can have index in it in this IDS version, that really help a lot
> ,
> I like to know how many tables I already modify to raw table already ,
> dbschema -d db1 db1.sql -ss would satisfy my needs ,> but , if I can select from system table like :
>
> select * from systables
> where tabid > 99>
> and get all the raw tables' name would be better ,
> can anyone give me a hint which system table have the information ?!
> Thanks and forgive me for my english ~
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--000e0ce03d0eecf288047c8b22e7
select *
from systables
where tabid > 99
and flag = 16;
--- Refer to: Guide to SQL: Reference
flags SMALLINT Codes for classifying permanent tables:
ST_RAW ( = 0x00000010 )（IDS）
RAW ( = 0x00000002 )（XPS）
STATIC ( = 0x00000004 )（XPS）
OPERATIONAL ( = 0x00000008 )（XPS）
STANDARD ( = 0x00000010 )（XPS）
EXTERNAL ( = 0x00000020 )（XPS）
NETSKY LIAO
2010-01-07
----------------------------------------------------
>Dear All...
>
>I've IDS 11.50.UC4 in RedHat Enterprise Linux 5.2 , so glad that
>raw table can have index in it in this IDS version, that really help a lot ,
>I like to know how many tables I already modify to raw table already ,
>dbschema -d db1 db1.sql -ss would satisfy my needs ,>but , if I can select from system table like :
>
>select * from systables
>where tabid > 99>
>and get all the raw tables' name would be better ,
>can anyone give me a hint which system table have the information ?!
>Thanks and forgive me for my english ~