× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



On 13-May-2014 18:19 -0500, Sarah Kemp wrote:
I will keep my question here brief and link to a more detailed
version so the code is readable.

I am implementing SQL error handling based on this page:
<https://www.ibm.com/developerworks/community/forums/html/topic?id=d2c49b79-5a01-46f7-9a11-b9de0f2b0e02#3b47a829-e864-44db-99c4-653a7547add2>

GET DIAGNOSTICS is incorrectly returning an SQLSTATE of 00000 when
it is first called in a newly activated service program. All
subsequent calls return correctly. Executing an otherwise unnecessary
SQL statement beforehand eliminates the issue. The service program
containing the GET DIAGNOSTICS statement is bound-by-reference to the
service program containing the erroring SQL statement and activates
*IMMED in group *CALLER.

Please see my full question here:
<http://stackoverflow.com/questions/23643045/initialize-activate-sql-prior-to-get-diagnostics>

I will be happy to answer my own question on that site with any
information sent to this list.


The described effect seems suspect, so very possibly is indicative of a defect. As such, quite probably the best path would be to pursue the issue with your service provider. The most recent conspicuous fix activity involving the output from a GET DIAGNOSTICS statement is available in v7r1 PTF SI51967. Note: nowhere did I see any mention of the version, release, mod, tech refresh, or cumulative level; thus a recommendation of a IBM i 7.1 fix may not be germane.


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.