Re: SQLCODEs and message descriptions

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

A correction in the second line - the first "latter" should be "former". 
Positive SQLCODEs are typically warnings or information.

On 2/6/2016 9:09 AM, Vernon Hamberg wrote:
> Y'all
>
> A recent thread spoke of warning messages in the context of adding 
> columns to a file. So I thought I'd post something about the 
> relationship between SQLCODEs and message descriptions.
>
> There are both positive and negative SQLCODEs, the latter are 
> typically warnings or information, while the latter are errors.
>
> The general connection between SQLCODEs and message descriptions is 
> that the SQLCODE digits are the final digits in a message ID that 
> generally starts with SQL.
>
> So an SQLCODE of 100 (row not found) has a message description in 
> QSQLMSG of SQL0100 of severity 0.
>
> And SQLCODE of -206 (column not in table) has a message description in 
> QSQLMSG of SQL0206 of severity 30.
>
> There are some 5-digit negative SQLCODEs, and all 5 digits are at the 
> end of the message ID. So SQLCODE of -30000 (DRDA protocol error) has 
> message ID SQ30000, severity 30.
>
> So with all that, one should STILL check SQLCODE in programs - AND one 
> can easily see a more expansive explanation of the meaning by looking 
> in the joblog.
>
> I hope this is useful - Buck, maybe this can go in the WIKI.
>
> Cheers
> Vern