Hi all,
I have a requirement that I need to update the database once I get the feed, but the key fields will be inserted by another job. Based on the key fields i need to update other few column detail since those values are available in the file only.
Is there any utility which will update the values in the table. Also please suggest me how this can be done through re-org the database and then load the database.
I can do COBOL change for this - But This involves lot of changes, so dropped this suggestion.
Any help would be great.
Best Regards,
Harikrishnan
Update DB2 table using any utility
Moderators: Kalicharan, Moderator Group
Until you post the actual requirement(s) there is no good reason people should waste time making suggestions
Lots of "things" can update values in tables. Which to use depends on specifics.
While you don't really want to do any work, COBOL may be the better alternative. COBOL is possibly the more generic way to do what you want and once working for one update could be easily cloned for the others.
Why might you believe what you wan could be accomplished by a re-org
If you provide some useful information, someone may have a better reply.
Lots of "things" can update values in tables. Which to use depends on specifics.
While you don't really want to do any work, COBOL may be the better alternative. COBOL is possibly the more generic way to do what you want and once working for one update could be easily cloned for the others.
Why might you believe what you wan could be accomplished by a re-org
If you provide some useful information, someone may have a better reply.
Have a good one
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