| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Problem with low values in middle of Blob casting to Char |
« View previous topic :: View next topic » |
| Author |
Message
|
| MarkAT |
 Posted: Thu Feb 02, 2006 2:08 am Post subject: Problem with low values in middle of Blob casting to Char |
 |
|
Newbie
Joined: 01 Feb 2006
Posts: 3
Location: Edinburgh
|
Hi, we're having trouble casting a BLOB containing asbitstream(InputBody) into a CHAR when there are low values in the middle of it. The CAST truncates the output string at the first low values. See the trace fragment below.
Does anyone know how to get the whole body into a character string.
(We're trying to store the whole body in an Oracle CLOB for audit purposes)
Thanks
BIP2538I: Node 'SLI_AUDIT_INSERT_5.InsertToILAuditMsg': Evaluating expression 'CAST(PayloadBlob AS CHARACTER CCSID Input
Root.Properties.CodedCharSetId)' at (80, 20).
----------[2006-02-02 09:45:38.201049 2828 UserTrace ]----------------------------------------------------------
BIP2538I: Node 'SLI_AUDIT_INSERT_5.InsertToILAuditMsg': Evaluating expression 'PayloadBlob' at (80, 26).
----------[2006-02-02 09:45:38.201095 2828 UserTrace ]----------------------------------------------------------
BIP2538I: Node 'SLI_AUDIT_INSERT_5.InsertToILAuditMsg': Evaluating expression 'InputRoot.Properties.CodedCharSetId' at (
80, 52).
----------[2006-02-02 09:45:38.201908 2828 UserTrace ]----------------------------------------------------------
BIP2539I: Node '
:60F:C050607GBP1425110,31
:61:0506070607CP200NCLRNONREF//9990704.00000000000000000000000000000000000000000000000000000000000000000000000
00000.': Finished evaluating expression '/1.0000000000000000.' at (80, 20). This resolved to 'CAST(X'7b313a463
03153544e444742325341585858313932353435393535347d7b323a4f3935303037313930323132313148534243484b484941585858363
23238333531363936303231323131303030384e7d7b333a7b3130383a3334353033363139347d7d7b343a0d0a3a32303a3935303031303
53135393033323732340d0a3a32353a31303830393731330d0a3a3238433a31313200002f31000000000d0a3a3630463a4330353036303
7474250313432353131302c33310d0a3a36313a3035303630373036303743503230304e434c524e4f4e5245462f2f39393930373034000
000000000000000000000000000000000000d0a2f50542f44452f45492f31303830393731330d0a3a3632463a433035303630364742503
13432353331302c33310d0a3a36343a43303530363036474250313432353131302c33310d0a2d7d7b0d0a426c6f636b20353a0d0a7b434
84b3a3633393842423645343745387d' AS CHARACTER CCSID 923 )'. The result was ''{1:F01STNDGB2SAXXX1925459554}{2:O
9500719021211HSBCHKHIAXXX62283516960212110008N}{3:{108:345036194}}{4:
:20:9500105159032724
:25:10809713
:28C:112.00000000.'.
----------[2006-02-02 09:45:38.201999 2828 UserTrace ]---------------------------------------------------------- |
|
| Back to top |
|
 |
| elvis_gn |
| Posted: Thu Feb 02, 2006 3:22 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi MarkAT,
What are "low values" ? Could you please give us a sample of what u r trying ?
Regards. |
|
| Back to top |
|
|
| mgk |
| Posted: Thu Feb 02, 2006 4:33 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
Are you sure it is not just the display in the usertrace that is truncating when it sees the null? Try CAST from BLOB to CHAR, then back again from the resulting CHAR to another result BLOB. Then compare the original blob with the result blob and see if they are the equal (as they should be).
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
