Testing a field in db2.

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

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

Testing a field in db2.

Post by arrbee » Sun Jun 11, 2006 11:31 am

Hi,

A field is modified from Decimal(9,2) to Decimal(11,2). After successful compilation, ran the JCL successfully with zero return code. How to find whether the particular field is (9,2) or (11,2).

TIA.
Arr Bee
-------------
?My joy in learning is partly that it enables me to teach? - Seneca(Roman philosopher, mid-1st century AD)
Top
User avatar
Krishna
Site Admin
Posts: 1052
Joined: Fri Jan 27, 2006 7:50 am

Post by Krishna » Wed Jun 28, 2006 4:40 pm

Hi Arrbee,

If I am understand your question correctly. You want to know whether your program is using old DCL variable or NEW DCL variable.

If so, You can know this by comparing DCL copy book change date
and compile jcl change date.

If not, Please allobrate the question.


Thanks,
Krishna
Top
Post Reply

Return to “DB2 SQL - DB2 PROGRAMMING”

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