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.