Page 1 of 1

how dump vsam file data to db2 tables

PostPosted: Sun Mar 13, 2011 11:29 pm
by K.AnithaSwaraj
i want to move vsam file data to db2 tables, r they having any utility,plz help me :?:

Re: how dump vsam file data to db2 tables

PostPosted: Mon Mar 14, 2011 2:43 am
by dick scherrer
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.

Re: how dump vsam file data to db2 tables

PostPosted: Mon Mar 14, 2011 2:50 am
by dick scherrer
Hello,

Do not post the same question multiple times. . .

The other has been deleted.

d