MQSeries.net :: View topic - Getting the message size

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 » Getting the message size

Getting the message size

« View previous topic :: View next topic »

Author

Message

Glass

Posted: Fri Nov 21, 2008 12:27 pm Post subject: Getting the message size

Acolyte

Joined: 02 Mar 2006
Posts: 56

Hi,

I am using Broker 6.02 and I would like to store the message size (in bytes/KB does not matter) in the database. Is there a way to get the message size/length and store it as an integer in esql? The message is in XML format.

Cheers!

wraymore

Posted: Fri Nov 21, 2008 1:17 pm Post subject:

Centurion

Joined: 16 Aug 2005
Posts: 114
Location: Burlington, NC USA

DECLARE MsgLngth INTEGER;
SET MsgLngth = LENGTH(InputBody);

Glass

Posted: Fri Nov 21, 2008 1:33 pm Post subject:

Acolyte

Joined: 02 Mar 2006
Posts: 56

I have tried that and it does not work. It gives me a value of 3 for a 12 KB and also for a 4KB xml message.

fjb_saper

Posted: Fri Nov 21, 2008 3:33 pm Post subject:

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY

Don't parse your XML message. Keep it as a BLOB and capture the size of that BLOB.

_________________
MQ & Broker admin

Glass

Posted: Mon Nov 24, 2008 6:37 am Post subject:

Acolyte

Joined: 02 Mar 2006
Posts: 56

fjb_saper,

Using the BLOB worked. Thanks!

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Getting the message size

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