Problem:

CONVERT within  a SQL statement is causing a syntax error when defined at the 01

Resolution:

Release: 3.1   The latest ESQLv3.1 002 fixpack has SQL TYPE's that can be defined at 01 level

o  OpenESQL now supports new "SQL TYPE"s that can be used as host variables

       DATE, TIME, TIMESTAMP, DATE-RECORD, TIME-RECORD, TIMESTAMP-RECORD,

       CHAR-VARYING, BINARY, VARBINARY, LONG-VARBINARY, AND LONG-VARCHAR.