| Author |
Message
|
| Coz |
 Posted: Mon Mar 04, 2002 5:30 am Post subject: |
 |
|
Apprentice
Joined: 20 Feb 2002
Posts: 44
Location: Basel CH
|
Anybody got any ideas why when i try to do this, in line with what was documented in the other thread about Concatenation...
SET OutputRoot."BLOB"."BLOB" = InputRoot."BLOB"."BLOB" || (SELECT ...
I get a BIP2420E which tells me || is not a supported action for these datatypes.
The input message is XML fed through a XMLtoBLOB RCD so I am somewhat confused.
Cheers
Coz |
|
| Back to top |
|
 |
| chanduy9 |
| Posted: Mon Mar 04, 2002 10:42 am Post subject: |
|
|
Disciple
Joined: 28 Nov 2001
Posts: 177
Location: USA
|
Hi,
you are trying to concatinate the char type to blob, conver the char type to blob then try.
Chandra. |
|
| Back to top |
|
|
| Coz |
| Posted: Mon Mar 04, 2002 10:48 am Post subject: |
|
|
Apprentice
Joined: 20 Feb 2002
Posts: 44
Location: Basel CH
|
Not unless WMQI automatically converts every SELECT to Char I'm not (as the field in the DB2 database is BLOB) and this is the same thing as the concatenation of two XML messages earlier in this forum history.
My difference is all I'm trying to concatenate is the message to a BLOB representation of a MQMD as we tend to same the messages without the MQMD.
Coz |
|
| Back to top |
|
|
| chanduy9 |
| Posted: Mon Mar 04, 2002 1:20 pm Post subject: |
|
|
Disciple
Joined: 28 Nov 2001
Posts: 177
Location: USA
|
Hi,
could you write your whole statement, and tell me what exactly you are trying to do.
Chandra. |
|
| Back to top |
|
|
| mq_developer |
| Posted: Mon Mar 04, 2002 2:37 pm Post subject: |
|
|
Voyager
Joined: 18 Feb 2002
Posts: 82
|
Hi,
From your ESQL it seems like you are trying to concatenate a list to the BLOB.
Try adding THE and ITEM clause before your SELECT statement , so that it fetches a Datatype of BLOB provided the column in DB2 is defined as BLOB.
Please post your full ESQL stmt.
cheers , Ram |
|
| Back to top |
|
|
|
|
