By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,586 Members | 2,418 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,586 IT Pros & Developers. It's quick & easy.

DB2 Load utility

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
"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

This discussion thread is closed

Replies have been disabled for this discussion.