how to load data from vsam to db2 table
Moderators: Kalicharan, Moderator Group
how to load data from vsam to db2 table
hi there,
how to load data from vsam file to db2 table using load utilty.
plz give me example
how to load data from vsam file to db2 table using load utilty.
plz give me example
- dbzTHEdinosauer
- Moderator
- Posts: 981
- Joined: Mon Oct 02, 2006 8:31 pm
first check with your site support group.
they will beable to tell you what utilities are available,
and which you can use.
after you know what utility you are going to use,
then read the manual.
if you have questions at that point,
the tell us what you have done, what does not work, and what you do not understand.
mainframe world is much different than pc world.
each site is different.
they will beable to tell you what utilities are available,
and which you can use.
after you know what utility you are going to use,
then read the manual.
if you have questions at that point,
the tell us what you have done, what does not work, and what you do not understand.
mainframe world is much different than pc world.
each site is different.
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.
-
- Moderator
- Posts: 1625
- Joined: Sat Aug 09, 2008 9:02 am
- Location: Mumbai, India
cobol program
Declare a variable in your cobol program like that
01 ws-x-amount pic 9(7)v99 comp-3.
and
move your vsam file field data to the above field
and then set the above mention field into the db2 table. It will be
work.
01 ws-x-amount pic 9(7)v99 comp-3.
and
move your vsam file field data to the above field
and then set the above mention field into the db2 table. It will be
work.
Last edited by hash33 on Sun Jul 22, 2012 12:40 pm, edited 2 times in total.
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