Hi, folks,

it sounds quite simple but produces many efforts to avoid bad impacts : how will a carriage return character be stored in a character field without loosing ability to unload and load the table ?

Does Informix come with any tools for it ?

At the moment I have to mask and unmask before unload or after load which has to be done for some reasons from time to time ! Will there be any convention which masking character has to be used ?

With regards,

Christof.

Hi,

If you use the function "delimiter", then I guess, you dont have to worry about carriage return character in the data:

eg

unload to xyz.dat delimiter "|"
select * from tab_nm

Bye

Nitin