Save 
Join IIUG
 for   
 

Informix reserved words from 7.30 to 11.10

Dynamic Server 11.10, 10.0, 9.40, 9.30, 9.21, and 9.20 support new SQL keywords that are reserved words and might affect migration of your applications. Although you can use almost any word as an SQL identifier, syntactic ambiguities might occur if you use an SQL reserved word. An ambiguous statement might not produce the results you want.

The list below shows new SQL reserved words. For a complete list of current SQL reserved words, see the IBM Informix Guide to SQL: Syntax.

Version 11.10

  • ADMIN
  • AVOID_INDEX_SJ
  • INSERTING
  • IDSSECURITYLABEL
  • INDEX_SJ
  • REFERENCES
  • SAMPLING
  • SELECTING
  • 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
  • DIRECTIVES
  • DEFAULT_ROLE
  • 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

Version 9.40

  • COLLATION
  • CROSS
  • FULL
  • INSTEAD
  • RESTART
  • RIGHT

Version 9.30

  • AVOID_EXECUTE
  • AVOID_SUBQF
  • USE_SUBQF

Version 9.21

  • AVOID_HASH
  • AVOID_INDEX
  • AVOID_NL
  • RAW
  • STANDARD
  • USE_HASH
  • USE_NL

Version 9.20

  • AGGREGATE
  • CACHE
  • COSTFUNC
  • ITEM
  • NAME
  • REF
  • SELCONST

Version 9.20 and 7.31

  • INNER
  • JOIN
  • LEFT
  • LOCKS
  • RETAIN

Version 9.20 and 7.30

  • ALL_ROWS
  • CASE
  • CRCOLS
  • DECODE
  • FIRST_ROWS
  • MEMORY_RESIDENT
  • NON_RESIDENT
  • NVL
  • REPLICATION
  • SUBSTR
  • SUBSTRING