MQSeries.net :: View topic

Patman28981 · Posted: Thu Sep 01, 2011 5:08 am Post subject:

Hi everybody,

I try to copy in ESQL on one node all fields to another set of fields, like this:

(SELECT berechtigt.KKDVOLL AS type:v
FROM msg.KKDVOLLMX[] AS berechtigt
WHERE berechtigt.KKDVOLL <> '' AND berechtigt.KKDVOLL <> '0000000') AS data:Verfuegungsberechtigter.data:Kundennummer[]

Please note that data:Verfuegungsberechtigter.data:Kundennummer[]
is an array and msg.KKDVOLLMX[] is an array too. Nevertheless the systm only copies one item (the first one of berechtigt.KKDVOLL ) I do not understand this because berechtigt looks like this:

berechtigt
KKDVOLL 12345
KKDVOLL 78901
KKDVOLL 1234
and so on.

On the WSDL file the Kundennummer is an array with maximum of -1 (infinite) the code is a subselect and part of a bigger select like this:

SET oM.service:GetKontoByKontonummerResult[] = SELECT
(SELECT msg.KAZEKDN AS type:v FROM msg) AS data:AbweichenderKontoauszugempfaenger.data:Kundennummer,
msg.* please do not use * AS data:Betreff,
(SELECT convert_toDec(msg.KSDSALDO) AS type:Betrag,
CAST(msg.KPZWAESL AS CHARACTER FORMAT '0000000') AS type:Waehrung.type:Key
FROM msg
WHERE msg.KSDSALDO <> '0' AND msg.KSDSALDO <> '') AS data:Hoehe,
--msg.KEVKUNDE AS data:Kontoinhaber.type:v,
TRIM(LEADING '0' FROM msg.KEVKUNDE) AS data:Kontoinhaber.type:v,
msg.KIDKTOID.KIDKTONR AS data:Kontonummer.type:v,
(SELECT berechtigt.KKDVOLL AS type:v
FROM msg.KKDVOLLMX[] AS berechtigt
WHERE berechtigt.KKDVOLL <> '' AND berechtigt.KKDVOLL <> '0000000') AS data:Verfuegungsberechtigter.data:Kundennummer[],
...
FROM iM.KAUS[] AS msg;

The result gives always the first item of berechtigt.KKDVOLL.

Can you please help?

Cheers,

Patrick