MQSeries.net :: View topic - processing Low values in Middle of Payload

MarkAT · Posted: Thu Feb 02, 2006 2:10 am Post subject:

Hi, We've got a problem with low values in the body of MQSI messages. (As sent by Swift)

Weâ€™re running in the BLOB message domain under WMQI 2.1 CSD3.

Weâ€™re trying to capture the message payload (in order to insert it into a CLOB field on an Oracle database) using the following command:

set PayloadBlob = asbitstream(InputBody);

The asbitstream command stops at the first of these low values and we lose the second half of the payload.

I've tried to get round this by using the payload directly via

CAST(InputBody AS CHAR CCSID InputRoot.Properties.CodedCharSetId)

but get an Invalid Wire Format Identifier error with this approach.

Anyone know how to capture the whole payload including the low values ?

An example of the payload data is given below

InputBody------------------- Hex equivalent

{1:F01ST NDGB2SAX 7B313A46 30315354 4E444742 32534158

XX192545 9554}{2: 58583139 32353435 39353534 7D7B323A

O9500719 021211HS 4F393530 30373139 30323132 31314853

BCHKHIAX XX 622835 4243484B 48494158 58583632 32383335

16960212 110008N} 31363936 30323132 31313030 30384E7D

{3:{108: 34503619 7B333A7B 3130383A 33343530 33363139

4}}{4:.. :20:9500 47D7D7B 343A0D0A 3A32303A 39353030

10515903 2724..:2 31303531 35393033 32373234 0D0A3A32

5:108097 13..:28C 353A3130 38303937 31330D0A 3A323843

:112../1 ......:6 3A313132 00002F31 00000000 0D0A3A36

0F:C0506 07GBP142 30463A43 30353036 30374742 50313432

5110,31. .:61:050 35313130 2C33310D 0A3A3631 3A303530

6070607C P200NCLR 36303730 36303743 50323030 4E434C52

NONREF// 9990704. 4E4F4E52 45462F2F 39393930 37303400

........ ........ 00000000 00000000 00000000 00000000

..../PT/ DE/EI/10 00000D0A 2F50542F 44452F45 492F3130

809713.. :62F:C05 38303937 31330D0A 3A363246 3A433035

0606GBP1 425310,3 30363036 47425031 34323533 31302C33

1..:64:C 050606GB 310D0A3A 36343A43 30353036 30364742

P1425110 ,31..-}{ 50313432 35313130 2C33310D 0A2D7D7B

..Block 5:..{CHK 0D0A426C 6F636B20 353A0D0A 7B43484B

:6398BB6 E47E8} 3A363339 38424236 45343745 387D

The content of PayloadBlob stops after 28C:112