skipping header and trailer while loading DB2 table

chandracdac · New User Joined: 15 Jun 2007 Posts: 92 Location: bangalore

Hi
I am loading my UDB DB2 table using below import command

Import from 'D:\data\tempdata.txt' OF DEL MODIFIED BY NOCHARDEL COLDEL0x09 replace into tablecreator.table_name

i know we can skip the header using skipcount or restart count. But Here i want to skip both header and trailer while importing data from the file.

My data file has millions of records and we don't want to open and the file and delete the header and trailer.

Any idea how we can do this in IMPORT command..

Thanks,
Chandra

chandracdac · New User Joined: 15 Jun 2007 Posts: 92 Location: bangalore

Forgot to mention i am using DB2 command prompt to load my table ..

GuyC · Posted: Mon Jul 16, 2012 12:04 pm

you might try a DB2 LUW forum.

chandracdac · New User Joined: 15 Jun 2007 Posts: 92 Location: bangalore

Link pls

Anuj Dhawan · Posted: Mon Jul 16, 2012 3:35 pm

Google, please?

dick scherrer · Posted: Mon Jul 16, 2012 7:28 pm

Hello,

Create the load file without the header and trailer. . .?

chandracdac · New User Joined: 15 Jun 2007 Posts: 92 Location: bangalore

I have already mentioned i can't open my file and delete header and trailer or i can't do some other process to remove header and trailer.I want to use the same file and skip header and trailer while loading. this is what i am looking for

Thanks,
Chandra.

Akatsukami · Posted: Tue Jul 24, 2012 7:12 pm

sushanth bobby · Posted: Wed Jul 25, 2012 10:10 am

Chandracdac,

Better to get this done outside of DB2, since you are windows you can write a small program in C, C++, VB Script, C# console program or POWERSHELL to strip the header & trailer. Here's a start in VBscript

If the input file is coming from mainframe, here is the dfsort technique and this one also uses DFSORT

Also you should definately read this article1, article2 and article3.

Thanks,
Sushanth