Finding the SQLCA
The SQLCA is especially valuable for diagnosing abends with a completion code of X'04E' and an abend reason code that begins with X'00E7'.
About this task
subcodethat uniquely identifies the location within the CSECT where the error was detected. The SQLERRM field contains an optional error description.
Procedure
To find the SQLCA:
Results
The SQLCA is especially valuable for abends with a completion code of X'04E' and an abend reason code that begins with X'00E7' (for example, 00E70005).
Sample SQLCA control blocks
The following figure shows a portion of an SQLCA in the formatted section of an SVC dump.
SQLC (00675) ADDR=7F6446A0 ASID=0016 VVV=00 FROM: RDA (00673) OFFSET=0008
0000 E2D8D3C3 C1404040 00000088 00000000 00004040 40404040 40404040 40404040 *SQLCA ........ *
0020 40404040 40404040 40404040 40404040 40404040 40404040 40404040 40404040 * *
0040 TO 005F SAME AS ABOVE
0060 00000000 00000000 00000000 FFFFFFFF 00000000 00000000 40404040 40404040 *....................... *
0080 00000000 00000000 *....... *
SQLCA.7F6446A0 E2D8D3C3 C1404040 00000088 00000000 00004040 40404040 40404040 40404040
7F6446C0 40404040 40404040 40404040 40404040 40404040 40404040 40404040 40404040
******** LINES FROM 7F6446E0 TO 7F644700 ARE THE SAME AS THE ABOVE LINE
7F644700 00000000 00000000 00000000 FFFFFFFF 00000000 00000000 40404040 40404040
7F644720 00000000 00000000 00280400 001EC4E2 D5E3C5D7 F2F2137E A1681D9C 3E200001