I am trying to load some data into a DB2 database using the LOAD command.

In some of my string data there are real double quotes ".

How can I tell the load that these are "Real" quotes and not delimiters?

TIA

--
Steve

On Jul 23, 12:32 pm, "Steve Rainbird"
<news.nos...@rainbird.me.nospam.ukwrote:

I am trying to load some data into a DB2 database using the LOAD command.
>
In some of my string data there are real double quotes ".
>
How can I tell the load that these are "Real" quotes and not delimiters?
>
TIA
>
--
Steve

Have you tried the nochardel option of load?

"Mike Gemmell" <greyeggsandspam@hotmail.comwrote in message
news:1185219019.862032.231930@z24g2000prh.googlegr oups.com...

On Jul 23, 12:32 pm, "Steve Rainbird"
<news.nos...@rainbird.me.nospam.ukwrote:

>
Have you tried the nochardel option of load?
>

Thanks Mike I will look at that option.

--
Steve