SQL keyword changes by version

Each version of Informix® supports new SQL keywords that might affect the migration of your applications, if an application declares the same string as the identifier of a database object.

Although you can use almost any word as an SQL identifier, syntax ambiguities might produce errors or unexpected results in some contexts if you declare an SQL keyword as an identifier. If your applications use keywords as identifiers, you might consider renaming those identifier. Alternatively, you can enable the DELIMIDENT environment variable, enclose string literal values between single ( ' ) quotation marks, and enclose SQL identifiers values between double ( " ) quotation marks.

The following table shows a list of new keywords of SQL in Informix. For a list of all keywords, see Keywords of SQL for HCL Informix in the IBM® Informix Guide to SQL: Syntax. For details about a keyword, search for the keyword in the IBM Informix Guide to SQL: Syntax.

Table 1. New keywords of SQL
Informix Version	Keywords
Version 12.10.xC6	IFX_SOC_KEEPALIVE
Version 12.10.xC5	BSON_GET BSON_SIZE BSON_UPDATE BSON_VALUE_BIGINT BSON_VALUE_BOOLEAN BSON_VALUE_DATE BSON_VALUE_DOUBLE BSON_VALUE_INT BSON_VALUE_LVARCHAR BSON_VALUE_OBJECTID BSON_VALUE_TIMESTAMP BSON_VALUE_VARCHAR
Version 12.10.xC4	IFX_SESSION_LIMIT_LOCKS IFX_PUA_DISPLAY_MAPPING
Version 12.10.xC2	BSON JSON LATERAL
Version 12.10.xC1	ACOSH ASINH ATANH CHR CLUSTER_TXN_SCOPE COMPRESSED CUME_DIST DEFAULTESCCHAR DENSERANK DENSE_RANK DISCARD FIRST_VALUE FOLLOWING EXCEPT G GB GIB GRID GRID_NODE_SKIP INTERSECT K KB KIB LAG LAST_VALUE LEAD M MB MIB MINUS NTILE NULLS PERCENT_RANK PRECEDING RANK RATIOTOREPORT RATIO_TO_REPORT ROLLING ROWNUMBER ROW_NUMBER SELECT_GRID SELECT_GRID_ALL SYS T TB TIB UNBOUNDED
Version 11.70.xC6	CLUSTER_TXN_SCOPE
Version 11.70.xC5	IFX_BATCHEDREAD_INDEX
Version 11.70.xC4	USTLOW_SAMPLE
Version 11.70.xC3	AUTO_READAHEAD
Version 11.70.xC2	AAO ACCOUNT BARGROUP DBSA DBSSO INSENSITIVE NLSCASE SENSITIVE
Version 11.70.xC1	ADDRESS ATTRIBUTES AUTHENTICATION AUTHID AUTO_STAT_MODE AVOID_FACT AVOID_MULTI_INDEX AVOID_STAR_JOIN BASED BOUND_IMPL_PDQ BUCKETS CONTEXT DEBUG_ENV ENABLE ERKEY FACT FORCED HASH HOME IMPLICIT_PDQ INDEX_ALL MULTI_INDEX NON_DIM NUMTODSINTERVAL NUMTOYMINTERVAL PROPERTIES STAR_JOIN STATCHANGE STATLEVEL STORE TO_DSINTERVAL TO_YMINTERVAL TRANSITION TRUSTED UID UPON USE
Version 11.50.xC6	BLOBDIR CLOBDIR DATAFILES DELIMITED DELUXE DISK EXPRESS FIXED FORMAT FORCE_DDL_EXEC IFX_BATCHEDREAD_TABLE INFORMIX MAXERRORS NUMROWS RECORDEND REJECTFILE RETAINUPDATELOCKS SAMEAS
Version 11.50.xC5	CONNECT_BY_ISCYCLE CONNECT_BY_ISLEAF CONNECT_BY_ROOT MERGE MATCHED SIBLINGS SYS_CONNECT_BY_PATH
Version 11.50.xC2	HDR
Version 11.50	BIGINT BIGSERIAL EXTDIRECTIVES PREPARE VERCOLS
Version 11.10	ADMIN AVOID_INDEX_SJ FINAL IDSSECURITYLABEL INDEX_SJ INSERTING REFERENCES SAMPLING SELECTING STATEMENT SYSDBCLOSE SYSDBOPEN TASK UPDATING USELASTCOMMITTED WITH In addition, the DBSECADM role is reserved for LBAC administrative work. Version 11.10 contains a new database, the sysadmin database. If your source database server contains a database named sysadmin, you must rename it.
Version 10.0	ACTIVE CURRENT_ROLE DEFAULT_ROLE DIRECTIVES ENCRYPTION HINT IGNORE INACTIVE INITCAP INLINE INOUT LIMIT LOAD ONLINE OPTCOMPIND PARTITION PASSWORD REUSE SAVE SKIP STORAGE TEMPLATE TEST TRUNCATE TYPEID TYPENAME TYPEOF UNLOAD XADATASOURCE XID