Serial, serial8 initialization values

Hi, Does somebody help me with next problem on IDS 9.30 ? Where in the database are written intialization values of serial or serial8 data types? With regards Jozef

Jozef Horyl wrote: >Hi, >Does somebody help me with next problem on IDS 9.30 ? > >Where in the database are written intialization values of serial or >serial8 data types? > >With regards > >Jozef > If I understand your question correctly, you will want to look at the IBM Informix Guide to SQL: Syntax for information on the 'DBINFO' function. You can use DBINFO to find out what values were assigned to the SERIAL ('sqlca.sqlerrd1') and SERIAL8 ('serial8') fields after an INSERT to your table. The IBM Informix Guide to SQL: Reference has a brief discussion on the data types, how they are stored, the default starting value, and the maximum values. You can find the SQL manuals at: http://www-306.ibm.com/software/data/informix/pubs/library/list2.html I hope this helps. -- June Hunt _________________________________________________________________ There are now three new levels of MSN Hotmail Extra Storage! Learn more. http://join.msn.com/?pgmarket=en-us&page=hotmail/es2&ST=1

--0__=08BBE4B2DFF8D32C8f9e8a93df938690918c08BBE4B2DFF8D32C Content-type: multipart/alternative; Boundary="1__=08BBE4B2DFF8D32C8f9e8a93df938690918c08BBE4B2DFF8D32C" --1__=08BBE4B2DFF8D32C8f9e8a93df938690918c08BBE4B2DFF8D32C Content-type: text/plain; charset=US-ASCII The information about the current values of the serial or serial8 types are stashed away in a partition header or something along those lines. The original values are not stored anywhere at all. -- Jonathan Leffler (jleffler@us.ibm.com) STSM, Informix Database Engineering, IBM Data Management 4100 Bohannon Drive, Menlo Park, CA 94025 Tel: +1 650-926-6921 Tie-Line: 630-6921 "I don't suffer from insanity; I enjoy every minute of it!" |---------+----------------------------> | | "Jozef Horyl" | | | <jho@nr.dflex.sk>| | | Sent by: | | | forum.subscriber@| | | iiug.org | | | | | | | | | 01/20/2004 07:56 | | | AM | |---------+----------------------------> >------------------------------------------------------------------------------- ----------------------------------------------------------------| | | | To: ids@iiug.org | | cc: | | Subject: Serial, serial8 initialization values [2455] | >------------------------------------------------------------------------------- ----------------------------------------------------------------| Hi, Does somebody help me with next problem on IDS 9.30 ? Where in the database are written intialization values of serial or serial8 data types? With regards Jozef --1__=08BBE4B2DFF8D32C8f9e8a93df938690918c08BBE4B2DFF8D32C Content-type: text/html; charset=US-ASCII Content-Disposition: inline <html><body> <p>The information about the current values of the serial or serial8 types are stashed away in a partition header or something along those lines.<br> The original values are not stored anywhere at all.<br> <br> --<br> Jonathan Leffler (jleffler@us.ibm.com)<br> STSM, Informix Database Engineering, IBM Data Management<br> 4100 Bohannon Drive, Menlo Park, CA 94025<br> Tel: +1 650-926-6921 Tie-Line: 630-6921<br> &quot;I don't suffer from insanity; I enjoy every minute of it!&quot;<br> <br> <br> <img src="cid:10__=08BBE4B2DFF8D32C8f9e8a93df938@us.ibm.com" width="16" height="16" alt="Inactive hide details for &quot;Jozef Horyl&quot; &lt;jho@nr.dflex.sk&gt;">&quot;Jozef Horyl&quot; &lt;jho@nr.dflex.sk&gt;<br> <br> <br> <table V5DOTBL=true width="100%" border="0" cellspacing="0" cellpadding="0"> <tr valign="top"><td width="1%"><img src="cid:20__=08BBE4B2DFF8D32C8f9e8a93df938@us.ibm.com" border="0" height="1" width="72" alt=""><br> </td><td style="background-image:url(cid:30__=08BBE4B2DFF8D32C8f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " width="1%"><img src="cid:20__=08BBE4B2DFF8D32C8f9e8a93df938@us.ibm.com" border="0" height="1" width="225" alt=""><br> <ul> <ul> <ul> <ul><b><font size="2">&quot;Jozef Horyl&quot; &lt;jho@nr.dflex.sk&gt;</font></b><br> <font size="2">Sent by: forum.subscriber@iiug.org</font> <p><font size="2">01/20/2004 07:56 AM</font></ul> </ul> </ul> </ul> </td><td width="100%"><img src="cid:20__=08BBE4B2DFF8D32C8f9e8a93df938@us.ibm.com" border="0" height="1" width="1" alt=""><br> <font size="1" face="Arial"> </font><br> <font size="2"> To: </font><font size="2">ids@iiug.org</font><br> <font size="2"> cc: </font><br> <font size="2"> Subject: </font><font size="2">Serial, serial8 initialization values [2455]</font></td></tr> </table> <br> <br> <tt>Hi,<br> Does somebody help me with next problem on IDS 9.30 ?<br> <br> Where in the database are written intialization values of serial or<br> serial8 data types?<br> <br> With regards<br> <br> Jozef<br> <br> <br> <br> </tt> </body></html> --1__=08BBE4B2DFF8D32C8f9e8a93df938690918c08BBE4B2DFF8D32C-- --0__=08BBE4B2DFF8D32C8f9e8a93df938690918c08BBE4B2DFF8D32C Content-type: image/gif; name="graycol.gif" Content-Disposition: inline; filename="graycol.gif" Content-ID: <10__=08BBE4B2DFF8D32C8f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhEAAQAKECAMzMzAAAAP///wAAACH5BAEAAAIALAAAAAAQABAAAAIXlI+py+0PopwxUbpu ZRfKZ2zgSJbmSRYAIf4fT3B0aW1pemVkIGJ5IFVsZWFkIFNtYXJ0U2F2ZXIhAAA7 --0__=08BBE4B2DFF8D32C8f9e8a93df938690918c08BBE4B2DFF8D32C Content-type: image/gif; name="ecblank.gif" Content-Disposition: inline; filename="ecblank.gif" Content-ID: <20__=08BBE4B2DFF8D32C8f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhEAABAIAAAAAAAP///yH5BAEAAAEALAAAAAAQAAEAAAIEjI8ZBQA7 --0__=08BBE4B2DFF8D32C8f9e8a93df938690918c08BBE4B2DFF8D32C Content-type: image/gif; name="pic29364.gif" Content-Disposition: inline; filename="pic29364.gif" Content-ID: <30__=08BBE4B2DFF8D32C8f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhWABDALP/AAAAAK04Qf79/o+Gm7WuwlNObwoJFCsoSMDAwGFsmIuezf///wAAAAAAAAAA AAAAACH5BAEAAAgALAAAAABYAEMAQAT/EMlJq704682770RiFMRinqggEUNSHIchG0BCfHhOjAuh EDeUqTASLCbBhQrhG7xis2j0lssNDopE4jfIJhDaggI8YB1sZeZgLVA9YVCpnGagVjV171aRVrYR RghXcAGFhoUETwYxcXNyADJ3GlcSKGAwLwllVC1vjIUHBWsFilKQdI8GA5IcpApeJQt8L09lmgkH LZikoU5wjqcyAMMFrJIDPAKvCFletKSev1HBw8KrxtjZ2tvc3d5VyKtCKW3jfz4uMKmq3xu4N0nK BVoJQmx2LGVOmrqNjjJf2hHAQo/eDwJGTKhQMcgQEEAnEjFS98+RnW3smGkZU6ncCWav/4wYOnAI TihRL/4FEwbp28BXMMcoscQCVxlepL4IGDSCyJyVQOu0o7CjmLN50OZlqWmyFy5/6yBBuji0AxFR M00oQAqNIstqI6qKHUsWRAEAvagsmfUEAImyxgbmUpJk3IklNUtJOUAVLoUr1+wqDGTE4zk+T6FG uQb3SizBCwatiiUgCBN8vrz+zFjVyQ8FWkOlg4NQiZMB5QS8QO3mpOaKnL0Z2EKvNMSILEThKhCg zMKPVxYJh23qm9KNW7pArPynMqZDiErsTMqI+LRi3QAgkFUbXpuFKhSYZALd0O5RKa2z9EYKBbpb qxIKsjUPRgD7I2XYV6wyrOw92ykExP8NW4URhknC5dKGE4v4NENQj2jXjmfNgOZDaXb5glRmXQ33 YEWQYNcZFnrYcIQLNzyTFDQNkXIff0ExVlY4srziQk43inZgL4rwxxINMvpFFAz1KOODHiu+4aEw NEjFl5B3JIKWKF3k6I9bfUGp5ZZcdunll5IA4cuHvQQJ5gcsoCWOOUwgltIwAKRxJgbIkJAQZEq0 2YliZnpZZ4BH3CnYOXldOUOfQoYDqF1LFHbXCrO8xmRsfoXDXJ6ChjCAH3QlhJcT6VWE6FCkfCco CgrMFsROrIEX3o2whVjWDjoJccN3LdggSGXLCdLEgHr1lyU3O3QxhgohNKXJCWv8JQr/PDdaqd6w 2rj1inLiGeiCJoDspAoQlYE6QWLSECehcWIYxIQES6zhbn1iImTHEQyqJ4eIxJJoUBc+3CbBuwZE V5cJPPkIjFDdeEabQbd6WgICTxiiz0f5dBKquXF6k4senwEhYGnKEFJeGrxUZy8dB8gmAXI/sPvH ESfCwVt5hTgYiqQqtdRNHQIU1PJ33ZqmzgE90OwLaoJcnMop1WiMmgkPHQRIrwgFuNV90A3doNKT mrKIN07AnGcI9BQjhCBN4RfA1qIZnMqorJCogKfGQnxSCDilTVIA0yl5ciTovgLuBDKFUDE9aQcw 9SA+rjSNf9/M1gxrj6VwDTS0IUSElMzBfsj0NFXR2kwsV1A5IF1grLgLL/r1R40BZEnuBWgmQEyb jqRwSAt6bqMCOFkvKFN2GPPkUzIm/SCF8z8pVzpbjVnMsy0vOr1hw3SaSRUhpY09v0z0J1FnwzPl fmh+xl4WtR0zGu24I4KbMQm3lnVu2oNWxI9W/lcyzA+mCKF4DBikxb/+UWtOGRiFP8qEwAayIgIA Ow== --0__=08BBE4B2DFF8D32C8f9e8a93df938690918c08BBE4B2DFF8D32C--