MQSeries.net :: View topic - Having trouble Adding Bytes to Output Msg BLOB...

saini · Posted: Thu Jul 22, 2004 8:25 am Post subject:

Hello EveryOne:

I am getting stumped on the following ESQL:

Set OutputRoot."BLOB"."BLOB" = CAST('APPLICAT' as BLOB) || InputRoot."BLOB"."BLOB";

Using the above in a compute node I get the following ExceptionList:
(
(0x01000000):RecoverableException = (
(0x03000000):File = '/build/S500_P/src/DataFlowEngine/ImbCom
puteNode.cpp'
(0x03000000):Line = 471
(0x03000000):Function = 'ImbComputeNode::evaluate'
(0x03000000):Type = 'ComIbmComputeNode'
(0x03000000):Name = 'Claim_Summary_Request#FCMComposite_1_3'
(0x03000000):Label = 'Claim_Summary_Request.Set CICS APPL Nam
e'
(0x03000000):Text = 'Caught exception and rethrowing'
(0x03000000):Catalog = 'BIPv500'
(0x03000000):Severity = 3
(0x03000000):Number = 2230
(0x01000000):RecoverableException = (
(0x03000000):File = '/build/S500_P/src/DataFlowEngine/ImbR
dl/ImbRdlStatementGroup.cpp'
(0x03000000):Line = 158
(0x03000000):Function = 'SqlStatementGroup::execute'
(0x03000000):Type = 'ComIbmComputeNode'
(0x03000000):Name = 'Claim_Summary_Request#FCMComposite_1_
3'
(0x03000000):Label = 'Claim_Summary_Request.Set CICS APPL N
ame'
(0x03000000):Text = 'Error detected, rethrowing'
(0x03000000):Catalog = 'BIPv500'
(0x03000000):Severity = 3
(0x03000000):Number = 2488
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '.Set CICS APPL Name.Main'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '6.3'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = 'SET OutputRoot.BLOB.BLOB = CAST('APPLICAT' AS BLOB)
|| InputRoot.BLOB.BLOB;'
)
(0x01000000):RecoverableException = (
(0x03000000):File = '/build/S500_P/src/DataFlowEngine/Im
bRdl/ImbRdlTypeCast.cpp'
(0x03000000):Line = 204
(0x03000000):Function = 'SqlTypeCast::evaluate'
(0x03000000):Type = ''
(0x03000000):Name = ''
(0x03000000):Label = ''
(0x03000000):Text = 'Error casting from %3 to %4'
(0x03000000):Catalog = 'BIPv500'
(0x03000000):Severity = 3
(0x03000000):Number = 2521
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '.Set CICS APPL Name.Main'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '6.34'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = 'CHARACTER'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = 'BLOB'
)
(0x01000000):RecoverableException = (
(0x03000000):File = '/build/S500_P/src/CommonServices/ImbValue.cpp
'
(0x03000000):Line = 677
(0x03000000):Function = 'ImbValue::fromCharacter'
(0x03000000):Type = ''
(0x03000000):Name = ''
(0x03000000):Label = ''
(0x03000000):Text = 'String is not of correct form for byte array.
Must consist of only 0..9,a..f,A..Z'
(0x03000000):Catalog = 'BIPv500'
(0x03000000):Severity = 3
(0x03000000):Number = 2590
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = 'APPLICAT'
)
)
)
)
)
)
)

Any clues to what I am doing wrong? I basically need to pre-pend a constant string to the BLOB that I writing out. Any help is appreciated.

Thx.
N