Reserved words

Informix®

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

For example:

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.

SAP ASE

Even if SAP® ASE allows SQL reserved keywords as SQL object names even if enclosed in square brakets (create table [table] ( col1 int )), verify this with your existing database schema and make sure that you do not use SAP ASE SQL words.

Solution

Database objects having names which are SAP ASE SQL reserved words must be renamed.

All BDL application sources must be verified. To check if a given keyword is used in a source, you can use UNIX™ grep or awk tools. Most modifications can be automatically done with UNIX tools like sed or awk.