LOAD and UNLOAD instrutions

This topic describes differences between I4GL and FGL with the LOAD and UNLOAD instructions.

LOAD requires to escape newline characters for TEXT

With IBM® Informix® 4GL, when using the LOAD instruction, if a file contains TEXT data, newline characters do not need to be preceeded by a backslash (to escape the newline), while CHAR and VARCHAR data requires a backslash to escape newline.

With Genero BDL, if a newline character is not preceded by a backslash, you get an error during the LOAD instruction. This behavior is more consistent than I4GL.

Instead of using I4GL to export data from your Informix database with UNLOAD, use Genero BDL to procude a correct data in the file.