SQL guide For IBM Informix database servers 5.x, 7.x, 8.x, 9.x, 10.x, 11.x / Unsupported IBM Informix SQL features |
CREATE TABLE tab ( v INTEGER ) INSERT INTO tab VALUES ( 123456::INTEGER ) SELECT 'abcdef'::CHAR(20)||'.' FROM tab SELECT CAST('abcdef' AS CHAR(20))||'.' FROM tab
Genero BDL does not support the :: cast operator in the static SQL grammar. However, the CAST() expressions are allowed. If you need to use the :: cast operator, you must use Dynamic SQL to perform such queries.
Enhancement reference: 19190