467,202 Members | 1,114 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,202 developers. It's quick & easy.

DB2 Load utility

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
  • viewed: 2018
Share:
2 Replies
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
"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.

Similar topics

2 posts views Thread by Rick | last post: by
1 post views Thread by Carmine | last post: by
3 posts views Thread by claus.hirth@abraxas.ch | last post: by
6 posts views Thread by jrthor2 | last post: by
1 post views Thread by huyuhui@gmail.com | last post: by
reply views Thread by Eric Davidson | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.