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.........
how to insert new column in already existing vsam file
Moderator: Moderator Group
- dbzTHEdinosauer
- Moderator
- Posts: 981
- Joined: Mon Oct 02, 2006 8:31 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.
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.
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.
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
- Cobol Interview Questions
50+ Interview Questions - JCL Interview Questions
50+ Interview Questions - DB2 Interview Questions
100+ Interview Questions - CICS Interview Questions
70+ Interview Questions - VSAM Interview Questions
27 Interview Questions
Other References
Mainframe Tools and others
- XPEDITER Reference
Explains how we can debug a program - FILEAID Reference
Explains how to browse , edit and delete datasets - Change Man Reference
Quick Start tutorial on Changeman - Abend Reference
Important Abend codes explained - FaceBook Page
MainframeGurukul FaceBook Page - LinkedIn Page
MainframeGurkul Linkedin Page