View previous topic :: View next topic
|
Author |
Message |
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. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
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 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. |
|
Back to top |
|
|
stodolas
Active Member
Joined: 13 Jun 2007 Posts: 632 Location: Wisconsin
|
|
|
|
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 |
|
Back to top |
|
|
|