Storing of Serial Number
--0-1217039571-1109180759=:74190 Content-Type: text/plain; charset=us-ascii Dear Gurus, Where Informix stores the values of the data type serial of each column in the Database?. Thanks a lot.! --------------------------------- Do you Yahoo!? Yahoo! Sports - Sign up for Fantasy Baseball. --0-1217039571-1109180759=:74190 Content-Type: text/html; charset=us-ascii <DIV> </DIV> <DIV>Dear Gurus,</DIV> <DIV> </DIV> <DIV>Where Informix stores the values of the data type serial of each column in the Database?.</DIV> <DIV> </DIV> <DIV> </DIV> <DIV>Thanks a lot.!</DIV> <DIV> </DIV><p> <hr size=1>Do you Yahoo!?<br> Yahoo! Sports - <a href="http://pa.yahoo.com/*http://us.rd.yahoo.com/evt=31508/*http://baseball.fantasysports.yahoo.com">; Sign up<a href=""></a> for Fantasy Baseball. --0-1217039571-1109180759=:74190-- sending to informix-list
Guido Jim'nez M. wrote:
PLEASE DO NOT POST MIME! It wastes bandwidth.
>
> Dear Gurus,
>
> Where Informix stores the values of the data type serial of each column in the Database?.
The next serial value for the one permitted serial field in each table is
stored
in the table's partition header, also know as it tablespace tablespace page.
You
can view it through the SMI/sysmaster interface:
select serialv
from sysptnhdr
where partnum = <table's partnum>;
To search by tabname, join to systabnames:
select dbsname, tabname, serialv
from systabnames st, sysptnhdr sp
where st.partnum = sp.partnum
and st.tabname = <mytabname>;
Art S. Kagel
> Thanks a lot.!
>
>
>
> ---------------------------------