CONSTRUCT and Informix ANSI database
I4GL CONSTRUCT generates the ANSI-mode SQL table owner in the
WHERE clause, while Genero BDL does not.
With IBM® Informix® 4GL, when connected to an Informix database create with ANSI mode, the WHERE clause
produced by
CONSTRUCT will contain table owners in the
form:"owner-name".table-name.column-nameGenero BDL will not produce the table owner
prefix:
table-name.column-nameAs result, the current Informix user must be the owner of the SQL table used by a
SELECT statement and WHERE clause, since it does not specify the
table owner.