Using get diagnostics

The get diagnostics statement retrieves error, warning, and informational messages from Client-Library. It is similar to, but more powerful than, the whenever statement, because you can expand it to retrieve more details of the detected errors.

If, within a whenever statement, you specify the application to go to or call another routine, specify get diagnostics in the function code, as follows:

void

 error_handler()

 {  

     exec sql begin declare section;

         int num_msgs;

         int condcnt;

     exec sql include sqlca;

     exec sql end declare section;

     exec sql get diagnostics :num_msgs = number;

     for (condcnt=1; condcnt <= num_msgs; condcnt++)

     {

         exec sql get diagnostics exception :condcnt

             :sqlca = sqlca_info;

         printf(“sqlcode is :%d\n\ message text:

             %s\n”, sqlca.sqlcode,

             sqlca.sqlerrm.sqlerrmc);

     }

 }