DSNT570I    WARNING: THIS APPLICATION HAS SELECTED DSNTIAR TO PERFORM SQL MESSAGE FORMATTING BECAUSE THE GET DIAGNOSTICS SERVICE RETURNED AN UNEXPECTED SQLCODE WHILE FORMATTING MESSAGES FOR ONE OR MORE SQL WARNING OR ERROR CONDITIONS. A DUMP OF THE SQLCA FOR THE GET DIAGNOSTICS REQUEST FOLLOWS:

SQLCODE:  sqlcode SQLSTATE: sqlstate SQLERRP:  sqlerrp
SQLERRMC: sqlerrmc
SQLERRD1: sqlerrd1 SQLERRD2: sqlerrd2 SQLERRD3: sqlerrd3 
SQLERRD4: sqlerrd4 SQLERRD5: sqlerrd5 SQLERRD6: sqlerrd6 
SQLWARN0: w0 1: w1 2: w2 3: w3 4: w4 5: w5 6: w6 7: w7 8: w8 9: w9 A:wA 

Explanation

The application program called the GET DIAGNOSTICS service to format one or more of the warning or error conditions that occurred during the processing of the current SQL statement that was input into the system. However, the GET DIAGNOSTICS service also returned warnings or errors, as indicated by the SQLCA dump. The application therefore will use the DSNTIAR message formatting service instead of GET DIAGNOSTICS. Attention: Messages formatted by DSNTIAR might contain truncated tokens. Also, when multiple unexpected SQLCODEs were returned for the current inputted SQL statement, DSNTIAR reports on the first one.

System action

The application program continues.

System programmer response

See the problem determination section of this message.

User response

Notify the system programmer.

Problem determination

Use the SQLCA dump provided by DSNT570I to determine the cause of the problem. After the problem is resolved, run the application again.