Ravi,

The Load command does not have a SKIPCOUNT that the Import command has. Since you're loading from a CSV file, you can use the Import command to get pretty good performance. If you can tune your memory usage to support the import, you should see performance of at least 1,000,000 rows per minute on the import. Drop your indexes first, import your data, then rebuild your indexes.

Nick

-------------- Original message --------------
From: "Ravi Tellakula " <db2udbdba-ezmlmshield-x94216689.[Email address protected]

> DB2 Experts,
>
> I am trying to load a CSV file into DB2 table by using the load
> function. Is it possible for me to ignore the Header / say first 2 lines
> in the csv file and upload the remaining data into the table?
>
> Any suggestions would be appreciated.
>
>
> Ravi
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>

DB2 & UDB email list listserv db2-l LazyDBA home page