Problem:
Currently Mainframe Express (MFE) does not contain documentation about the negative SQLCA code.
For example XDB error -2088 or cannot access Mainframe DB2 table via COBOL.
Resolution:
Refer to Appendix D from XDB COBOL Precompiler Manual (See Attachment).
Table D-1 Translating SQLCODE and SQLERRD into XDB Error
For example XBD error code -2088:
SQL DB2 Mode:
Range -1651 to -3000
How to Terminate to XDB Error:
Take absolute value, subtract 1650, prefix with "N"
-2088 minus 1650 give N438
MFE > Help > SQL for DB2 > Error Messages > Network Errors:
N438 shows Security not valid.
The partner LU rejected the UserID or password used in the allocate call.
Turn on security at the client using the Configuration utility.
Make sure the UserID and password are valid for the host environment.
Attachments:
#EnterpriseDeveloper
#MFDS
