I am trying to load a file into a db2 database using the following command:

import from ${InputFile} of del
modified by coldel|
commitcount 100
insert into ${WORK_SCHEMA}.${CSI_LOAD_TBL};

There is a header row that I want to skip. Does DB2 have commands that can be used to skip the 1st record in the file?

thanks,

Joe

What DB2 version and OS?

Andy

I am using AIX and Command Line Processor for DB2 SDK 8.2.5

That would be the RESTARTCOUNT option. It's amazing what you can find in the manual, isn't it?

There is also the SKIPCOUNT option which is equivalent to RESTARTCOUNT.

Andy

I used the skipcount - thanks for the info.

Alternatively, it would be possible to load from a pipe. Then you could send the file into the pipe, dropping the first line in the process. Lot's of solutions...

i m having files already with header info and i want to use Load not import. Can't find equivalent modifier for SKIPCOUNT for LOAD. Any Hints?
following link says i have to edit the file and proceed..
http://publib.boulder.ibm.com/infoce...g/amarcsv0.htm

You mean any solutions other than the ones we posted already?

In this case you have 2 options -
1. Open the file in a text editor and delete the column names ( I presume your file is in CSV format) and then run LOAD command
2. Or else run the load command and hope that the first row gets caught in your exception table which you define.


Moreover I believe you can go ahead with IMPORT command as only your loading times will be slower... but then it again depends upon the amount of data you are about to INSERT into the new table. WHat is the rowcount that you are looking to insert?