Migrating from IBM Informix 4gl to Genero BDL / 4GL programming topics |
PREPARE st1 FROM "SELECT * FROM tab WHERE col>?" DECLARE cu1 CURSOR FOR st1 OPEN cu1 USING var FOREACH cu1 INTO rec.* DISPLAY rec.* END FOREACH
This feature is supported by Genero Business Development Language, but can lead to defects with some versions of the Informix database client. Review your code to avoid the OPEN statement by moving the USING clause to the FOREACH instruction.