Load Utility

[Suresh]

Hi All

I am new to DB2. So i dont have knowledge of DB2 API. I dont have
knowledge of how to use API ...

I have requirement of loading data from tab delimited text file in to
Db2. For this I came across LOAD utility in DB2. But now my problem is
that I am loading data periodically without any user intervation....So
I want to call this load utility by using java program or by using some
routine such as Stored procedure or user defined function is it
possible? If so please provide me detail and if possible then code
also....

Thanks
Suresh

[Kiran Nair]

There is a db2 load API in C ...which you can use for the same ..
Sample :
http://publib.boulder.ibm.com/infoce...tbload-sqc.htm

Knuth Stoze had given a wonderful explanation for the same

http://www-128.ibm.com/developerwork...ndex.html#load

for tab delimited text you
may need to add FILETYPE modifier ..the ascii code of tabcharacther ie
0x09..something like below

DB2CLI::sqlchar* pModType;
String modString("COLDEL0x09");
ModType = static_cast<DB2CLI::sqlchar*>(malloc(sizeof(short) +
modString.Size() + 1));
pModType->length = modString.Size();
strcpy(pModType->data, modString);

You can try using sysproc.db2load stored procedure with filetype
modfier COLDEL0x09

Regards,
Kiran Nair

[Suresh]

Hi Kiran

By using second link i got much more idea...
But This is load data by using default format...

Where should I change in .c file or script file so that i can load tab
delimited text file...

Because I need to load tab delimited text file...

Thanks and regards
Suresh