MVSFORUMS.com

arv · Beginner Joined: 30 Mar 2003 Posts: 13 Topics: 11

hi all,

I would like to have the coding for moving data from vsam to db2 table.If there are any utilities or tools kindly explain in detail.

thanking you,

with regards,

arv.

kolusu · Posted: Tue Apr 01, 2003 1:00 pm Post subject:

Arv,

First you need to REPRO the vsam file to a flat file and then load the flat file into the table provided that the table is created based on the vsam file layout.

Check this link for a detailed explanation and examples of REPRO

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DGT1V402/3.25?DT=19951025222737

Check this link for a detailed explanation and examples of DB2 utility LOAD

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNUGH11/2.12?DT=20010719144747

In the other scenario where you want to move the data from db2 table to a vsam cluster then you need to UNLOAD the db2 table and then REPRO it back to the vsam file.

Check this link for detailed explanation and examples of DB2 utility UNLOAD

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAPH11/APPENDIX1.3.1?DT=20010710165542

Hope this helps...

cheers

kolusu