Re: UNLOAD and backslashes

Carlson@WHSmith wrote: > Informix 7.23.UC4 > HPUX 10.01 > > I've looked through the manual, I've perused the archives, but I have > yet to find an answer to a problem. > > I'm using SQL to gather information into a temp table, then unload the > data from the temp table to an ASCII file, to be loaded into an Oracle > table. We have various pieces of char information that contains > backslashes. It appears that Informix will escape any backslashes in an > unload file. The Oracle load errors out due to this situation. Is > there any way around this short of updating the information within the > table? How does Orifice handle backslashes in it's own loaf/unload files? Once that is sorted I'd sed the files and swap the Informix 'ignore backslash' to the Orifice 'ignore backslash' -- Paul Watson # WF Software Ltd # If it ain't broke, Tel: +44 1436 674729 # fix it till it is. Fax: +44 1436 678693 # www.wfsoftware.co.uk #