Reserved words

Informix®

With Informix, it is possible to create database objects with reserved words.

CREATE TABLE table ( char CHAR(10) );

Indeed this is not good practice, but Informix SQL allows this to be backward compatible when introducing a new keyword in the SQL syntax.

Most other database systems do not allow reserved words as database identifiers. If your legacy code is using SQL reserved words of the target database SQL syntax, an error will be thrown at CREATE TABLE execution.

IBM® DB2®

Even if IBM DB2 allows SQL reserved keywords as SQL object names, verify this with your existing database schema and make sure that you do not use DB2 SQL words. An example of a common word which is part of DB2 SQL grammar is 'alias'.

Solution

See IBM DB2 documentation for reserved keywords.