You can use CA Ideal built‑in functions in <<ERROR>> Procedures to identify error codes DB2 returns due to errors encountered handling dataviews or embedded SQL.
The $ERROR‑TYPE function with a value of D71‑D85 or DB2 indicates DB2 dataview errors. For a DB2 ERROR‑TYPE, the function $ERROR‑DVW‑STATUS returns the SQLCODE from the SQLCA. See the Programming Reference Guide for explanations.
A number of $SQL functions return the current values of fields in the SQLCA for the last SQL statement executed. One identifies the last SQL statement executed.
CA Ideal $ERROR error functions are available only in the logical scope of <<ERROR>> procedures. See the Programming Reference Guide for complete descriptions of CA Ideal built‑in functions.
The subprogram, @I$TIAR, is available to format DB2 error messages. For more information about using this utility program, see the Programming Reference Guide.
You can use CA Ideal error functions in <<ERROR>> Procedures to identify error codes VSAM returns.
A value beginning with V from the $ERROR‑TYPE function indicates a VSAM error. For a complete explanation of these functions, see the $ERROR‑DVW‑STATUS and $ERROR‑DVW‑INTERNAL‑STATUS functions in the Programming Reference Guide.
CA Ideal $ERROR error functions are available only in the logical scope of <<ERROR>> procedures.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|