BuiltIn Functions › $ERRORDB2PLAN (DB2 Only)

$ERRORDB2PLAN (DB2 Only)

This alphanumeric function returns the seven‑character DB2 application plan in effect for the dataview in error. If the dataview is not in error or if the dataview was a CA Datacom/DB or sequential dataview, the function returns N/A.

Note: $ERROR functions return meaningful data only in the error procedure or in a procedure or subprogram invoked by the error procedure. In the case of a database error, $ERROR functions can also return meaningful data in the scope of a WHEN ERROR clause. You do not have to pass the $ERROR functions as parameters.