how to insert new column in already existing vsam file

Post your questions related to VSAM

Moderator: Moderator Group

Post Reply
puja_main
Member
Posts: 8
Joined: Fri Mar 30, 2012 3:29 pm

how to insert new column in already existing vsam file

Post by puja_main » Wed May 16, 2012 12:04 pm

hello friends,

I'm using vsam file containg data. now i want to insert new column in it i.e
cc-id at the first position of the records.

so that i can load this data to db2


how to do this.........

User avatar
dbzTHEdinosauer
Moderator
Posts: 981
Joined: Mon Oct 02, 2006 8:31 pm

Post by dbzTHEdinosauer » Wed May 16, 2012 1:03 pm

atually,

you would be adding a field,
which would then become a db2 table column in a row
inserted by the db2 load utility that is available at your site.
(see your other post about this subject).

since you want to add an additional field,
you first have to determine what file format will be accepted by the db2 load utilitiy.
after that, you have to determine how to generate the file,
then concatenate the new field and the original record generating a new record,

if you are lucky, you can use a sort product to
read the vsam
add the new field,
generate an output record aceptable to the db2 load utility.
Dick Brenholtz
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.

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