Handling SQL error codes after the SQL statements.
If I compile the program without bind, the error message looks like this:
ERROR AT OPEN CUR1
DSNT408I SQLCODE = -805, ERROR: PACKAGE NAME DALLASC..CBLDB21.1B89E5800200F25A NOT FOUND IN PLAN Z91361. REASON 03
DSNT418I SQLSTATE = 51002 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXEPM SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -251 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFF05' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION
If this modification is appropriate, I will also include SQL error handling in the other programs (CBLDB22.cbl and CBLDB23.cbl).
Fixes # (issue)
Type of change
What type of changes does your PR introduce to the COBOL Programming Course? Put an x in the boxes that apply.
[x] Bug fix (change which fixes one or more issues)
[x] New feature (change which adds functionality or features to the course)
[ ] Translations (change which adds or modifies translations of the course)
[ ] Documentation (change which modifies documentation related to the course)
[x] This change requires an update to the course's z/OS environment
Checklist:
Put an x in the boxes that apply. You can also fill these out after creating the PR. If you're unsure about any of them, don't hesitate to ask. We're here to help! This checklist will be used as reference for both the contributor and the reviewer
I added the SQL error handling to the COBOL sources CBLDB22 and CBLDB23.
I inserted the missing DD REPORT in CBLDB22R.jcl. In the documentation, I did not find that this file definition was intentionally missing from the job.
Signed-off-by: Janos Varga 113785741+vargajb@users.noreply.github.com
Proposed changes
Handling SQL error codes after the SQL statements. If I compile the program without bind, the error message looks like this:
If this modification is appropriate, I will also include SQL error handling in the other programs (CBLDB22.cbl and CBLDB23.cbl).
Fixes # (issue)
Type of change
What type of changes does your PR introduce to the COBOL Programming Course? Put an
x
in the boxes that apply.Checklist:
Put an
x
in the boxes that apply. You can also fill these out after creating the PR. If you're unsure about any of them, don't hesitate to ask. We're here to help! This checklist will be used as reference for both the contributor and the reviewer