Specify field names

Informix® ESQL/C is not case sensitive regarding the field names of a row variable. In a SELECT or UPDATE statement, Informix ESQL/C always interprets field names of a row variable as lowercase. For example, in the following SELECT statement, Informix ESQL/C interprets the fields to select as x and y, even though the SELECT statement specifies them in uppercase:

EXEC SQL select X, Y from table(:myrect);

This behavior is consistent with how the database server handles identifier names in SQL statements. To maintain the case of a field name, specify the field name as a delimited identifier. That is, surround the field name in double quotation marks and enable the DELIMIDENT environment variable before you compile the program.

Informix ESQL/C interprets the fields to select as X and Y (uppercase) in the following SELECT statement (assuming the DELIMIDENT environment variable is enabled):

EXEC SQL select "X", "Y" from table(:myrect);

For more information about delimited identifiers and the DELIMIDENT environment variable, see SQL identifiers.