Question about SERIAL8 data type

Posted in 2001

Jean-Philippe BATTU — Thu, 11 Jan 2001 15:22:23 +0100 — source: Informix-list mailing list archive (1991-1998)

Hello could you tell me what is a SERIAL8 data type ? and is it available in INFORMIX SE product ? Thanks in advance for yours answers and explanations ... Cheers ! Jean-Philippe BATTU Bull / Grenoble FRANCE

↪ replying to Jean-Philippe BATTU

Maria C. Lopez — Thu, 11 Jan 2001 15:40:53 GMT — source: Informix-list mailing list archive (1991-1998)

Hello, This is what I found about your first question! SERIAL8( n) The SERIAL8 data type stores a sequential integer assigned automatically by the database server when a row is inserted. (For more information on how to insert values into SERIAL8 columns, see Chapter 1 of the Informix Guide to SQL: Syntax.) A SERIAL8 data column is commonly used to store large, unique numeric codes (for example, order, invoice, or customer numbers). SERIAL8 data values require 8 bytes of storage. The following restrictions apply to SERIAL8 columns: - You can define only one SERIAL8 column in a table. However, a table can have one SERIAL8 and one SERIAL column. - The SERIAL8 data type is not automatically a unique column. You must apply a unique index to this column to prevent duplicate SERIAL8 numbers. - The SERIAL8 data type does not allow a null value. If you are using the interactive schema editor in DB-Access to define the table, a unique index is applied automatically to a SERIAL8 column. -Maria Jean-Philippe BATTU wrote: > Hello > > could you tell me what is a SERIAL8 data type ? > > and is it available in INFORMIX SE product ? > > Thanks in advance for yours answers and explanations ... > > Cheers ! > > Jean-Philippe BATTU > Bull / Grenoble > FRANCE

↪ replying to Jean-Philippe BATTU

Maria C. Lopez — Thu, 11 Jan 2001 15:49:37 GMT — source: Informix-list mailing list archive (1991-1998)

Hello, From the Informix Guide to SQL and regarding the information that I sent you before about your first question, since it was related to SQL, had this listed as part of the products to which it applied, INFORMIX-SE, Version 7.1 -Maria Jean-Philippe BATTU wrote: > Hello > > could you tell me what is a SERIAL8 data type ? > > and is it available in INFORMIX SE product ? > > Thanks in advance for yours answers and explanations ... > > Cheers ! > > Jean-Philippe BATTU > Bull / Grenoble > FRANCE

↪ replying to Jean-Philippe BATTU

cedarsiding@my-deja.com — Thu, 11 Jan 2001 16:05:20 GMT — source: Informix-list mailing list archive (1991-1998)

> could you tell me what is a SERIAL8 data type ? It is an 8-byte serial integer. Like 'serial' (which is 4-bytes), only longer. Useful for 64-bit systems. > and is it available in INFORMIX SE product ? I dunno. If SE specifically supports 64-bit platforms, it may have been introduced there... or not. -cs Sent via Deja.com http://www.deja.com/