I think we can get this to work without making any changes to data file. Use the
delimiter as single "*". So two consecutive ** represents a null data. This means
number of columns in the data file
gets doubled, with alternate DATA and NULL columns. Having said this, use the
modified by p() option of the load to load the appropriate column with the non null
data.
Ex. P(1,3,5,7,9...) should do the job. Hope I got this right ;-)
Regards,
Ajith
-----Original Message-----
From: udb question [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 17, 2001 9:44 AM
To: [EMAIL PROTECTED]
Subject: DB2EUG: Load question
Hi I would like to load a table in UDB, Solaris from a
flat file
and the delimiters I have is {**}.. I am unable to do
this as coldel takes only one character
The file contains data like.
1204{**}54{**)24{**) etc...
Any help would be great!!
Thanks
__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
