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

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


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"

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

----------- --------------------

Nov 12 '05 #2

P: n/a

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.


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.