MVSFORUMS.com

[sonaarjun]

Hi Folks!

In my coaching centre, they told me to do one project in m/f.
The project is migration project.

i.e: The financial concern have 30 branches. 12 of them store datas in VSAM and other store in DB2. my objective is to convert all the VSAM stored datas in to DB2 w/o any misleading and w/o any tools.
I have to do only thru coding.

My system criteria: os/390,cics,cobol(vs),jcl,vsam,db2,file-aid,expeditor etc

I humbly request u to give proper guidance and tips to finish my project.
-------------------------------------------------------------------------------------
WHO TOLD 'NOTHING' IS IMPOSSIBLE
I'VE DONE 'NOTHING' IN MY LIFE.
-------------------------------------------------------------------------------------

[Phantom]

sonaarjun,

Convert VSAM to DB2: The simplest thing to do is:
1. Create a DB2 table using COBOL.
2. Read the VSAM file in COBOL and write the contents to a DB2 table.

You have lot of other utilities like DSNTIAUL....to load or unload contents to/from a DB2 table, but I don't think you need to go this far. A simple COBOL program will do the job.

Please let us know if you need more information,

Thanks,
Phantom

[sonaarjun]

Hats off for you Phantom!
Thanks I've got it. I can do much better with this idea. If i've any problem in course of my execuetion of this project i'll definetly stay in touch with u.
-----------------------------------------------------------------------------------------------
SUCCESS CONSISTS OF DAILY LITTLE ACHIEVEMENTS
----------------------------------------------------------------------------------------------

[gharisankar]

Additionaly, If you are using your VSAM files in the COBOL program thats also needs to be changed.
1. FD section
DB2- Remove this for DB2 programs
2. Read the VSAM file by using Key
DB2 - Replaced by DB2 query with primary
3. If there is any Alternate Index in VSAM file
DB2 - the query should be modified with the DB2 Index.
....
..
.
_________________
Regards
Hari