Re: SERIAL seed value

I'd always assumed that INFORMIX added 1 to the MAX value of an index and pre-set this value when the table was generated. Reading the manuals does not give any help on this. Perhaps somebody from INFORMIX should tell us how it's done. > > > > At 09:51 PM 5/19/96 GMT, Stuart Browning wrote: > > >How can I find out the seed value of a column that is a SERIAL > > >datatype from within a C or 4GL program? > > > > Seed value? I assume you want the value of the last inserted serial > > value > > which is in SQLCA.SQLERRD[2] in 4GL (and SQLCA.SQLERRD[1] in ESQL/C, > > I think) > > > > I believe he is asking for what the starting value is based on. You can > specify, when you create the table, what the starting serial value is. > I > take this to be the 'seed' value of which Stuart speaks. When I wrote > dbdiff2 > I looked for this creature and could not find it. My G2 indicated that > it > was not accessible. If you find it (Stuart) holler, I could stand to > know > too. > > cheers > j. > ________________________________________________________________________ > _____ > Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA > jparker@hpbs3645.boi.hp.com Back in Boise > ________________________________________________________________________ > _____ > > If anything can go wrong, fix it. To hell with Murphy. > ________________________________________________________________________ > _____ > Any opinions expressed herein are my own and not those of my > employers. > ________________________________________________________________________ > _____ Malcolm Weallans Online Database Consultancy Phone 01628-72154 Fax 01628-37463 CIX - onlinedbc