Loading DEL files

Karl Bauer

Loading DEL files
I want to migrate data from the now-defunct Solid database to DB2 V.7.1
but I'm facing the following problem:
The exported Solid data files are column-delimited with a comma, however
ALL field data (both character and integer) is enclosed in single-quotes
('...'). The DB2 Load utility appears to accept data where only
character strings are delimited. It does not recognise integer data
which is enclosed in single-quotes and ignores it. Is there any way to
coerce the Load utility into accepting delimited integer data as a valid
integer?
Thanks for your help,
Karl


________________________________________________

karl bauer
business analyst
viator inc.| www.viator.com
london | san francisco | sydney
________________________________________________