Previous Topic: CA Datacom ToolsNext Topic: Statistics and Diagnostics Area (PXX) Report


CA Datacom/DB Return Codes

You can use CA Ideal built‑in functions in <<ERROR>> Procedures to identify errors. These include several codes CA Datacom/DB returns due to errors encountered handling dataviews.

The $ERROR‑TYPE function with a value of DVW indicates such errors. You can find additional information about such errors using the functions $ERROR‑DVW‑STATUS and $ERROR‑DVW‑INTERNAL‑STATUS. A value returned by $ERROR‑DVW‑STATUS that starts with I (for example, I9) indicates a CA Ideal error. For explanations, see the Programming Reference Guide.

A two‑digit dataview status (for example, 05) indicates a DB return code (for an 05, URT could not be opened). In this case, the value returned by $ERROR‑DVW‑INTERNAL‑STATUS can be the DB subcode, where applicable. If the DB return code received does not have any subcodes (as documented in the CA Datacom/DB Summary of Messages), ignore this value. For explanations, see the CA Datacom/DB Summary of Messages.

For an SQL dataview, $ERROR‑DVW‑STATUS returns the SQLCODE from the SQLCA. This is a character string with a value in the range ‑999 to +999. A negative value indicates an error. If a value of ‑117 or ‑118 is detected, CA Ideal replaces this value with the CA Datacom return code. See the $ERROR‑DVW‑STATUS and $ERROR‑DVW‑INTERNAL‑STATUS functions in the Programming Reference Guide and the CA Datacom/DB Summary of Messages for explanations.

CA Ideal $ERROR error functions are available only in the logical scope of <<ERROR>> procedures. For complete descriptions of CA Ideal built‑in functions, see the Programming Reference Guide.