× 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.



I missed that repeat ability Chuck - thanks.


On 2013-11-12, at 10:44 AM, CRPence <CRPbottle@xxxxxxxxx> wrote:

On 11-Nov-2013 16:54 -0800, Jon Paris wrote:
<<SNIP>>

For the archive the required syntax is:

Exec SQL
GET DIAGNOSTICS EXCEPTION 1
:errorText = DB2_ORDINAL_TOKEN_1;

Exec SQL
GET DIAGNOSTICS EXCEPTION 1
:errorText = DB2_ORDINAL_TOKEN_2;

This can be continued for as many tokens as are present/required. As
Chuck pointed out earlier you can determine how many there are to
retrieve by looking at the message details for the SQL message that
appears in the log for a specific error condition. In the case of
SQL validation there are only 2.

i.e. error message SQ20399

_1 is the error position in the XML text and _2 is the detailed
message describing the specific validation error.

That was all a lot harder than it should have been!


The following example is somewhat redundant for including the
/string/ of tokens, in addition to each of the seven tokens it requires
[for -407 exception condition], but the point is to show that the syntax
allows for multiple comma-separated variables set from the
condition-information-item. Having to invoke the SQL only once, at
least makes it nicer:

Exec SQL
get diagnostics condition 1
:tkn_str = db2_token_string
, :tkn1 = db2_ordinal_token_1
, :tkn2 = db2_ordinal_token_2
, :tkn3 = db2_ordinal_token_3
, :tkn4 = db2_ordinal_token_4
, :tkn5 = db2_ordinal_token_5
, :tkn6 = db2_ordinal_token_6
, :tkn7 = db2_ordinal_token_7
;

--
Regards, Chuck
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com





As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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.