Escaping in db2 load

[Bobsparks@excite.com]

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

[Artur]

Re: Escaping in db2 load

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.p l/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

[Bobsparks@excite.com]

Re: Escaping in db2 load

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