Re: SNDPGMMSG

On 18/12/2008, at 3:51 AM, DeLong, Eric wrote:

Don't you need to CONCAT your "SQL" and RIGHT(...) clauses? You want
MSGID to be SQLnnnn, right?

It is apparent from the output in the job log that concatenation must be occurring else the MSGID would not be displayed as SQL0206 but rather as something else.

The code to generate MSGID is performing concatenation.

MSGID = "SQL"RIGHT(STRIP(ABS(SQLCODE)),4,'0')

Abutted strings are automatically concatenated by Rexx. "SQL" is a string and the return value from RIGHT is also a string so by using the short-hand notation shown above MSGID will contain a concatenation of both strings.

From The Rexx Language:

Concatenation
The concatenation operators are used to combine two strings to form one string by appending the second string to the right-hand end of the first string. The concatenation may occur with of without an intervening blank:

(blank) Concatenate terms with one blank in between.
|| Concatenate without an intervening blank.
(abuttal) Concatenate without an intervening blank.

Concatenation without a blank may be forced by using the || operator, but it is useful to remember that when two terms are adjacent and are not separated by an operator, they will be concatenated in the same way. This is the abuttal operation. For example, if the variable TOTAL had the value '37.4', then Total'%' would evaluate to '37.4%'.


Regards,
Simon Coulter.
--------------------------------------------------------------------
FlyByNight Software OS/400, i5/OS Technical Specialists

http://www.flybynight.com.au/
Phone: +61 2 6657 8251 Mobile: +61 0411 091 400 /"\
Fax: +61 2 6657 8251 \ /
X
ASCII Ribbon campaign against HTML E-Mail / \
--------------------------------------------------------------------