How a DB2 table can be loaded from .csv file

sandra · New User Joined: 06 Apr 2005 Posts: 27

I need to load a DB2 table from a .csv file. Could someone help me on this.

dbzTHEdinosauer · Posted: Wed Jul 02, 2008 2:15 pm Post subject:

generate a template (syspunch) file - you can use a dummy unload to generate a starting point. then edit the syspunch and modify the positions, lengths, types to match your csv file. then run the load.

dsnugh11 is the db2 vs7 utility guide. you can download the pdf from IBM

this is a link to the IBM document center http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/FINDBOOK?filter=DB2&SUBMIT=Find&Collection=0

the above link will select all DB2 books.

when you have questions, ask. This type of question has several threads on this website.

stodolas · Posted: Thu Jul 03, 2008 7:37 am Post subject:

Can you write a SYSPUNCH to handle variable length data like the following?

Bob,Smith,42 Wallaby Way,Melbourne,Australia
Dick,Brenholtz,10042 N Germany St,Varel,Germany