Re: When is SqlState reset?

Hi Daniel

The term "return code" is used in the SQL reference to describe what SQLSTATE and SQLCODE are -for example, from the manual at https://www.ibm.com/docs/en/ssw_ibm_i_75/pdf/rzalapdf.pdf

An SQLCODE is a return code. The return code is sent by the database manager after completion of each SQL statement.

An SQLSTATE value is a return code that indicates the outcome of the most recently executed SQL statement.

And in the SQL Reference is this interesting sentence -

    When an SQL statement other than GET DIAGNOSTICS or compound-statement is processed, the current diagnostics area is cleared, before processing the SQL statement.

Is a 2nd execution of GET DIAGNOSTICS going to give the same reported values? It doesn't clear the diagnostics area, so I expect it should still give the same information.

We might be saying the same thing in different ways, as someone says, agreeing violently!