Hi,

How to load the data from a flat text file having delimiter ',' between columns ?
Please give a sample query.

Thanks,
Sam

modified by coldel;

See LOAD/IMPORT for dets.

Hi,

Thanks for your reply.

Can you give some examples for the same.

Sam.

There are some in the Command reference...

import from myfile.ixf of ixf messages msg.txt modified by coldel; insert into staff

";" is actually a little tricky since it's a special character to your shell most likely, so stick the command in a file like so:

import from myfile.ixf of ixf messages msg.txt modified by coldel; insert into staff
0

(That's a 0)

and run the command:
db2 -td0 -vf yourfile.sql

Hi,

import from myfile.ixf of ixf messages msg.txt modified by coldel; insert into staff

In the above query please explain the following denotes what ?

'of ixf'
'messages'
'modified by coldel'

Then why haven insert into staff ? -- > Is the above is a full single query ?

Thanks,
Sam

Please look at the IMPORT command in the Command Reference, it explains everything!

I messed up, it should have been:
import from myfile.del of del messages msg.txt modified by coldel; insert into staff

This takes everything from the flat file "myfile.del" which is "of del" (delimited ASCII), writes any messages to msg.txt file, assuming a column delimiter of ";".

Insert is the mode, not an SQL statement.
Staff is the target table.

Command Reference.

See:

http://www-306.ibm.com/cgi-bin/db2ww....htm#HDRIMPOVW

hi everyone!

try this sample-statement: instead of using coldel; try coldel0x3B.
by using the hex-code for ";" the problem with the ";" will disappear...

IMPORT FROM "O:\test.txt" OF DEL MODIFIED BY CHARDEL"" COLDEL0x3B DECPT, COMMITCOUNT 100 MESSAGES "O:\test.err" INSERT INTO DB2ADMIN.TEST1;

rgds, sleye.