MQSeries.net :: View topic - BLOB to BLOB copy

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » BLOB to BLOB copy

BLOB to BLOB copy

« View previous topic :: View next topic »

Author

Message

smeunier

Posted: Wed Feb 07, 2007 8:17 am Post subject: BLOB to BLOB copy

Partisan

Joined: 19 Aug 2002
Posts: 305
Location: Green Mountains of Vermont

I'm looking to extract 8 bytes from a 500 byte BLOB message much like I would for issuing a substring function. Is there a similar function for operating on BLOB data without having to CAST? The reason is, is that I'mm issueing a:

Code:

RTRIM(LTRIM(SUBSTRING(CAST(InputRoot."BLOB"."BLOB" AS CHAR CCSID InputRoot.Properties.CodedCharSetId) FROM 97 FOR 4)));

and it trys to convert all the data in the InputRoot.BLOB.BLOB, of which a non convertable character exists. Sinve that data is EBCIDIC abd will be pass on "asis" I don't need to cast the entire BLOB. So I would like to extract the first 8 bytes(al of what I need converted) and then cast just that. Ideas?

jefflowrey

Posted: Wed Feb 07, 2007 8:31 am Post subject:

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

You can substring on BLOB.

I don't know about LTRIM or RTRIM.

So just reverse the nesting of SUBSTRING and CAST.
_________________
I am *not* the model of the modern major general.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » BLOB to BLOB copy

Jump to:

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

Protected by Anti-Spam ACP