Ispirer Website Ispirer Capabilities - Informix Migration Free Trial

Informix Dynamic Server (IDS) Data Types - BIGSERIAL, SERIAL8

Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x

Informix - BIGSERIAL
Syntax BIGSERIAL[(n)]
Data 64-bit auto-increment integer data, UNIQUE and PRIMARY KEY constraints are not automatically assigned

UPDATE statement cannot be used to change an existing serial value
To insert an explicit value, specify any integer greater than zero in INSERT statement.
If you specify 0 then the next serial value will be assigned
Parameters n is the starting number
Default n is 1
Range 1 to 263-1, negative values are not allowed
Storage Size 8 bytes
Synonyms SERIAL8
Internals BIGSERIAL is implemented as BIGINT, SERIAL8 is implemented as INT8 (BIGINT has storage and processing advantages over INT8)
Standards Informix SQL Extension

Example:

CREATE TABLE t_serial (c1 BIGSERIAL);

Informix BIGSERIAL - Equivalents in Other Databases

Database Data Type and Conversion
Oracle NUMBER(19,0) with SEQUENCE object
SQL Server BIGINT with IDENTITY property
MySQL BIGINT with AUTO_INCREMENT property
PostgreSQL BIGSERIAL
Sybase ASE NUMERIC(10,0) with IDENTITY property

Related Data Types in Informix

Data Types
Integers BIGINT INT SMALLINT
Auto-increment integers SERIAL

All Data Types


© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.