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

Escaping in db2 load

P: n/a
Hello

I am trying to use db2 load to load into a table that has a column
named URL. My command lists the column names.

I get an error 'An unexpected token "URL" was found'.

If I delimit URL with double quotes I get the same message. If I drop
the column, it loads just find except the column url of course.

Does anyone know how to delimit reserved words using the db2 load
utility?

Thanks
Bob

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Bob, check the syntax once again. I don't think "url" is a reserved
word. Are you loading into character column (or datalink)?

I did a simple successfull test (windows, db2 v8.1.10):

file "data"
1,"http://groups.google.pl/group"
2,"http://www.onet.pl"

db2 create table url(id int, url char(30))
db2 load from data of del method p (1, 2) replace into url(ID, URL)
db2 select * from url

ID URL
----------- --------------------
1 http://groups.google.pl/group
2 http://www.onet.pl

Nov 12 '05 #2

P: n/a
Artur

I have since found out that this was fixed in 8.1.4a. I am trying to
support 8.1.3 customers.

I would love to know what the distrubtion of the users to fixpack
levels are. If I knew no one used it I could drop it.

Bob

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.