Are the various tokens in SQLERRM and their sequence documented anywhere?

Binyamin Dissen

Are the various tokens in SQLERRM and their sequence documented anywhere?
Or must one via trial and error dump the contents and see what is there?

Are the tokens always in the sequence as DB2 V9.1 for z/OS Codes shows them,
i.e., -803 means token #1 is the index name?

--
Binyamin Dissen <[login to unmask email]>
http://www.dissensoftware.com

Director, Dissen Software, Bar & Grill - Israel


Should you use the mailblocks package and expect a response from me,
you should preauthorize the dissensoftware.com domain.

I very rarely bother responding to challenge/response systems,
especially those from irresponsible companies.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/solutions-journal.html - home of the IDUG Solutions Journal
Technical atricles from world famous authors in DB2's most prestigious, peer reviewed
magazine now on-line!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

David Seibert

Re: Are the various tokens in SQLERRM and their sequence documented anywhere?
(in response to Binyamin Dissen)
Hello Binyamin,

I have found that the Codes manual accurately documents the content
and sequence for SQLERRM. But I have not studied whether this can change
release to release. It certainly changes between SQLCodes. For instance
as you say, the -803 first token is indexspace and for -805 the first
token is package/dbrm name.
I would be surprised to see the order or contents change, but I wouldn't
bet much that it never would.

Am I misunderstanding your question?

Dave

The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it.

From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Binyamin
Dissen
Sent: Monday, December 28, 2009 11:03 AM
To: [login to unmask email]
Subject: [DB2-L] Are the various tokens in SQLERRM and their sequence
documented anywhere?

Or must one via trial and error dump the contents and see what is there?

Are the tokens always in the sequence as DB2 V9.1 for z/OS Codes shows
them,
i.e., -803 means token #1 is the index name?

--
Binyamin Dissen <[login to unmask email]>
http://www.dissensoftware.com

Director, Dissen Software, Bar & Grill - Israel


Should you use the mailblocks package and expect a response from me,
you should preauthorize the dissensoftware.com domain.

I very rarely bother responding to challenge/response systems,
especially those from irresponsible companies.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 *
http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/solutions-journal.html - home of the IDUG Solutions
Journal
Technical atricles from world famous authors in DB2's most prestigious,
peer reviewed
magazine now on-line!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L
is the home of IDUG's DB2-L

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/solutions-journal.html - home of the IDUG Solutions Journal
Technical atricles from world famous authors in DB2's most prestigious, peer reviewed
magazine now on-line!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Binyamin Dissen

Re: Are the various tokens in SQLERRM and their sequence documented anywhere?
(in response to David Seibert)
That is it. I just wanted confirmation on the sequence, that DSNTIAR did not
have logic to reorder the tokens.

On Mon, 28 Dec 2009 12:04:31 -0500 "Seibert, Dave"
<[login to unmask email]> wrote:

:>Hello Binyamin,
:>
:> I have found that the Codes manual accurately documents the content
:>and sequence for SQLERRM. But I have not studied whether this can change
:>release to release. It certainly changes between SQLCodes. For instance
:>as you say, the -803 first token is indexspace and for -805 the first
:>token is package/dbrm name.
:>I would be surprised to see the order or contents change, but I wouldn't
:>bet much that it never would.

:> Am I misunderstanding your question?

:>Dave

:>The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it.

:>From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Binyamin
:>Dissen
:>Sent: Monday, December 28, 2009 11:03 AM
:>To: [login to unmask email]
:>Subject: [DB2-L] Are the various tokens in SQLERRM and their sequence
:>documented anywhere?

:>Or must one via trial and error dump the contents and see what is there?

:>Are the tokens always in the sequence as DB2 V9.1 for z/OS Codes shows
:>them,
:>i.e., -803 means token #1 is the index name?

--
Binyamin Dissen <[login to unmask email]>
http://www.dissensoftware.com

Director, Dissen Software, Bar & Grill - Israel


Should you use the mailblocks package and expect a response from me,
you should preauthorize the dissensoftware.com domain.

I very rarely bother responding to challenge/response systems,
especially those from irresponsible companies.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups,
there is probably one near you!
Regional User Groups are your local connection to the Worldwide DB2 User Community
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L