vsam

Post your questions related to VSAM

Moderator: Moderator Group

Post Reply
phani

vsam

Post by phani » Sat Apr 22, 2006 1:32 am

Iam having 100 records in vsam and 300 records in db2.I want to migrate 100 records of vsam to db2.Explain me the procedure to migrate records from vsam to db2?

User avatar
arrbee
Active Member
Posts: 144
Joined: Fri Feb 24, 2006 11:33 am

Post by arrbee » Mon Apr 24, 2006 10:45 am

Do you have a KSDS file? You will have to insert the values into appropriate fields probably by using the SQL in batch for bulk insertion. Before that you need to know the corresponding copybook to know what value of a filed in file belongs to which field. And, what are the corresponding DB2 table fields.

Let me know if I am wrong.

HTH.
Arr Bee
-------------
?My joy in learning is partly that it enables me to teach? - Seneca(Roman philosopher, mid-1st century AD)

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others