MQSeries.net :: View topic - ESQL - index error when index used in call procedure

EgilsJ.Rubenis · Posted: Thu Apr 05, 2007 3:11 am Post subject:

Hi,

my Problem is, when using an index for an output field in a call procedure in a while do, that the index seems to contain a character value.

Code that works fine if done in two steps (first convert, then set output):

while intIdx < intTotal
call convertDate (refIn.Table[intIdx].Date, chrConvDate);
Set refOut.Table[intIdx].Date = chrConvDate;
intIdx = intIdx +1
end while;

create procedure convertDate (IN InDate CHAR, OUT OutDate CHAR)
begin
SET OutDate = SUBSTRING(InDate From 7 FOR 2) || '.'
||SUBSTRING (InputDate From 5 FOR 2) || '.' || SUBSTRING(InputDate
From 1 FOR 4);
end;

Using the output field directly in the call

call convertDate (refIn.Table[intIdx].Date, refOut.Table[intIdx].Date)

it happens that the index in the output seems to be trash, what i don't understand because it works fine for the input field with the index in the same call.

Any Ideas? Thanks

Cheers, Egils