The following SQL reserved words require special treatment in EGL if they are used as SQL table names or column names:
call, from, group, having, insert, order, select, set, union, update, values, where
To use these SQL reserved words, do the following:
column = "\"reservedWord\""
For example:
column = "\"FROM\""
tableNames = "\"reservedWord2\""
For example:
tableNames = "\"ORDER\""
... #sql{ select "reservedWord" from "reservedWord2" .... } ...
For example:
... #sql{ select "FROM" from "ORDER" .... } ...
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.