Re: UNLOAD and backslashes

Jacob Salomon wrote: > > 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. > Not on the same box <G> . . . but I do like the joke. > (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.) > I pulled up the news flash off the Web . . . . just about forgotten about that. Life seems too quite now. John Carlson Informix DBA WH Smith, Inc. Last seen: Getting ready for the IWUC.