Table and column names in static SQL

In static SQL statements, table and column names will be converted to lowercase by the fglcomp compiler. The SQL keywords are always converted to uppercase.

For example:

UPDATE CUSTOMER set CUST_name = 'undef' WHERE cust_name is null

Will be converted to:

UPDATE customer SET cust_name = 'undef' WHERE cust_name IS NULL

While SQL keywords are not case sensitive for database servers, table names and column names can be case-sensitive.

You can dump the static SQL statement texts with the -S option of fglcomp.