View previous topic :: View next topic
|
Author |
Message |
jayaprakashr Currently Banned New User
Joined: 23 Jul 2005 Posts: 6 Location: bangalore
|
|
|
|
Hi,
how to convert VSAM file record into DB2.plz let me know [/b] |
|
Back to top |
|
|
rick
New User
Joined: 18 Jun 2004 Posts: 59 Location: Chennai
|
|
|
|
If u use tools to convert VASM file to DB2 |
|
Back to top |
|
|
surya
New User
Joined: 19 Feb 2005 Posts: 13
|
|
|
|
hi
how to convert VSAM file record into DB2.plz let me know?
what type of tool? |
|
Back to top |
|
|
manjithota
New User
Joined: 09 Jun 2005 Posts: 10
|
|
|
|
hi,
load all your vsam records into a sequential dataset in the first step. then use LOAD utility to load all the data to ur db2 table.
while using LOAD don't forget to mention the ENFORCE CONSTRAINT option.plz consult somebody about the use of it.it would be very huge a document to post it.
otherwise read one record at a time in a program and put inserts into the table , but it won;t be that efficient a technique.follow the first one for clarity n code opti. |
|
Back to top |
|
|
harish_mf
New User
Joined: 31 Jul 2005 Posts: 18 Location: bangalore
|
|
|
|
hi all,
iam a mainframe user and i have some doubts.
how to convert vsam record into db2 , is there any presteps to be follwed for indexex and AIX.
if any one knows the answer plz send it to my personnel mail id,
***EMail ID REMOVED... Read Forum Rules*** |
|
Back to top |
|
|
kanak
Moderator
Joined: 12 Mar 2005 Posts: 252 Location: India
|
|
|
|
hi, you can check the attached file. Hope you will find some helpfull material in it. |
|
Back to top |
|
|
Karthikt
New User
Joined: 15 Aug 2005 Posts: 51
|
|
|
|
jayaprakashr wrote: |
Hi,
how to convert VSAM file record into DB2.plz let me know [/b] |
Hi,
I can find 2 methods for this problem.
1. Manual solution.
VSAM file can be considered as Indexed file. First find out whether the primary key of DB2 table and your VSAM file is same or not. If it is not same, then you copy the VSAM file into a FLAT FILE. Then define a VSAM file with record format such as like DB2 table and also keys as same as primary keys. Then load this new VSAM file from the flat file. You can read your VSAM file record by record and insert into the DB2 table. I am already having a utility program for this. If you want I will send you.
2. Automated solution.
Unload the data from the VSAM file in the record format as as same as the DB2 table. Write a control card for the DB2 table to load from the flat file into DB2. Then using the options DB2 table / 3.7/load from file option in mainframes, load the data into DB2 table using the flat file and control card.
Contact for information on this to ***EMail ID REMOVED... Read Forum Rules*** |
|
Back to top |
|
|
dneufarth
Active User
Joined: 27 Apr 2005 Posts: 419 Location: Inside the SPEW (Southwest Ohio, USA)
|
|
|
|
Contents of VSAM file may not be ideal for DB2.
It seems to me that dump and load without the VSAM record fields being clearly defined and reviewed by a DBA for proper database design, integrity, validity and normalization, is simplistic and shortsighted.
Get proper documentation and a DBA involved.
Dave |
|
Back to top |
|
|
|