Using variable subscripts in SQL

Use of subscript operations on host variables in static SQL statements is not supported by Genero BDL.

IBM® Informix® 4GL allows to use subscripts operators on host variables in static SQL statements. For example:

DEFINE name VARCHAR(40)
SELECT * FROM tab WHERE col = name[2,3] 

When doing this, I4GL will silently ignore the [2,3] operator, to use the full variable value!

Unlike I4GL, the Genero BDL compiler denies this syntax, and is considered as bad practice.