String delimiters and object names

The ANSI string delimiter character is the single quote ('string'). Double quotes are used to delimit database object names ("object-name").

Example: WHERE "tabname"."colname" = 'string'

Informix^® allows double quotes as string delimiters, but Genero db doesn't. This is an important distinction, as many BDL programs use double quotes to delimit the strings in SQL commands.

Note: This problem concerns only double quotes within dynamic SQL statements. Double quotes used in pure BDL string expressions are not subject to SQL compatibility problems. Double-quoted string literals in static SQL statements are converted to single-quoted strings by compilers.

Genero db implements ANSI-compliant SQL syntax and therefore does not support double-quoted string literals; only database object names can be double-quoted.

Solution

With Genero db 3.61 and 3.80, double quoted strings are converted by the Genero db database driver (dbmads3x or dbmads380).
Starting with Genero db 3.81, double quoted string literals are supported by the server.