how dump vsam file data to db2 tables



IBM's flagship relational database management system

how dump vsam file data to db2 tables

Postby K.AnithaSwaraj » Sun Mar 13, 2011 11:29 pm

i want to move vsam file data to db2 tables, r they having any utility,plz help me :?:
K.AnithaSwaraj
 
Posts: 4
Joined: Thu Sep 02, 2010 6:18 pm
Has thanked: 0 time
Been thanked: 0 time

Re: how dump vsam file data to db2 tables

 

Re: how dump vsam file data to db2 tables

Postby dick scherrer » Mon Mar 14, 2011 2:43 am

Hello,

If all of the fields in the vsam file match directly/correctly to the db2 columns in the same table, you should be able to run a LOAD with the proper control statements. If the vsam data is not already in db2 acceptable formats, the data will need to be converted prior to loading/inserting into the table.

Suggest you talk with your dba about which tools might be available on your system.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: how dump vsam file data to db2 tables

Postby dick scherrer » Mon Mar 14, 2011 2:50 am

Hello,

Do not post the same question multiple times. . .

The other has been deleted.

d
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post