MQSeries.net :: View topic - ESQL Help please

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 » ESQL Help please

ESQL Help please

« View previous topic :: View next topic »

Author

Message

pfaulkner

Posted: Thu Oct 31, 2002 1:49 pm Post subject: ESQL Help please

Master

Joined: 18 Mar 2002
Posts: 241
Location: Colorado, USA

How can edit a BLOB field?

I have a BLOB (256 bytes long) field that I need to change bytes 20-26.

I tried substring and then put it back together but that didn't work.

lung

Posted: Thu Oct 31, 2002 5:20 pm Post subject:

Master

Joined: 27 Aug 2002
Posts: 291
Location: Malaysia

Look up on the OVERLAY syntax.

_________________
lung

pfaulkner

Posted: Mon Nov 04, 2002 9:34 am Post subject:

Master

Joined: 18 Mar 2002
Posts: 241
Location: Colorado, USA

DECLARE newDataLength INTEGER;
DECLARE tempString BLOB;
SET newDataLength = length(BITSTREAM(InputBody));

IF newDataLength < 10 then
SET tempString = CAST(('000000' || newDataLength) AS BLOB);
OVERLAY (Environment.MRM PLACING tempString FROM 20 FOR 7);
end if;

Get this error:
Nov 4 11:02:03 cose2e1 WMQIv210[65176]: (BROKER1.SOAPExecutionGroup)[3856]BIP2912E: (16, 2) : Type mismatch on RETURN : BROKER1.006f73fb
-f000-0000-0080-ef8ed9a98840: : 0: : :

Can anyone assist with this please?

thanks

lung

Posted: Mon Nov 04, 2002 4:59 pm Post subject:

Master

Joined: 27 Aug 2002
Posts: 291
Location: Malaysia

Your overlay syntax is wrong. You're not returning the results of the OVERLAY command to anything.

Here's a sample...

Code:

SET abc = OVERLAY ('ABCDEFGHIJ' PLACING '1234' FROM 4 FOR 3);
-- abc will become 'ABC1234GHIJ'

[/code]
_________________
lung

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » ESQL Help please

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