Multiple choice technology mainframe

Which assembler routine used to obtain a formatted form of the SQLCA and a text message based on the SQLCODE field of SQLCA

  1. SQLCA

  2. DCLGEN

  3. DSNTIAR

  4. SQLSTATE

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

DSNTIAR is an assembler routine provided by DB2 to obtain a formatted text message describing the error code contained in the SQLCA structure.