Re: UNLOAD and backslashes

Carlson@WHSmith wrote: > 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? What? You have Oracle and Informix on the same machine? Niether engine will get any work done because they are both too busy posting insults (unintelligible to the general public) at each others' data paths, especially at port 101. (For those who have no idea what I am referring to, both Informix & Big-O are along Highway 101 in Silicon valley. Some years ago Informix put up billboard ads just outside Oracle's headquarters. Big-O had to retaliate, of course.) Consider yourself lucky your machine didn't begin to burn itself up! -- -- Jake (Retrospectively realizes there is no future in hindsight) +------------------------------------------------------------+ | The expedient performance of a task with excessive concern | | regarding its duration-to-completion engenders a virtual | | certainty of diminished benefit therefrom. | | -- Benjamin Franklin (but he said it in 3 words) | +------------------------------------------------------------+