DB2 Load utility

Steve Rainbird

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

Jul 23 '07 #1

Mike Gemmell

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?

Jul 23 '07 #2

Steve Rainbird

"Mike Gemmell" <gr*************@hotmail.comwrote in message
news:11**********************@z24g2000prh.googlegr oups.com...

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?

Thanks Mike I will look at that option.

--
Steve

Jul 23 '07 #3