Re: unload inserts unwanted backslashes

mike_jay@my-deja.com wrote: > > The SQL*Loader for the Oracle 8.0.6 DBMS on the HP-UX B.10.20 does not > require the additional backslashes inserted by the Informix unload > command. When I use the Informix unload command the extra backslashes > between the pipe delimiter in the ASCII host file become part of the > data when inserted into the Oracle DMBS copy of the Informix DBMS. I wonder why not. It's more a requirement of UNIX. > The unload is adding information within the columns of my row data > instead of just exporting the data "as is" between the pipe delimiter > as I am trying to specify. The extra info as you call it is require in order to re-load the data. > Can I stop this with an environment variable or some other means of > declaration, yes/no? What I am looking for is the "don't do that" > environment variable. I have no idea what character I could use as a > reserved only for me special case escape character with thousands and > in some cases millions of records to consider. No. I guess in your case another escape char is not appropriate, no. > If no, I will use the recommendation provided first to apply the sed > UNIX command to extract the extra backslash from my data. If you can echo each line before it gets to Orable, then that will sort the backslash. Otherwise you will have to use the recommendation of sed. Just be careful you don't lose the backslash altogether, because as I said, it's the UNIX escape char. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |What year 2000 bug? year 2000 bug? |/// / ////| | |year 2000 bug? year 2000 bug? year |// / /////| | |2000 bug? year 2000 bug? year 1900 |/ ////////| +----------------------+-----------------------------------+-----------+