MQSeries.net :: View topic

mustang · Posted: Tue May 08, 2007 9:07 am Post subject:

We warehouse messages to a text field in MS SQL Server. We need to read the message from the db and write it to a queue. We can get the message out of the db OK, but are having difficulty creating a message out of it. I assume this is a CHAR to BLOB conversion problem. Below is the code we are trying:

SET Environment.Variables.Messages VALUE = null;
Create Lastchild Of Environment.Variables.Messages Domain 'BLOB' Name 'BLOB';

SET OutputLocalEnvironment.Variables.MESSAGE[] =
( SELECT Top 1
T.PASS_THRU_TXT AS "ORIGMSG"
FROM Database.Request_Audit AS T
);

Set Environment.Variables.Messages.BLOB = Cast(ASBitstream(OutputLocalEnvironment.Variables.MESSAGE.ORIGMSG,
InputProperties.Encoding,
InputProperties.CodedCharSetId,'','','',FolderBitStream) As BLOB);

OutputLocalEnvironment.Variables.MESSAGE.ORIGMSG appears to store the message as a character type.
Environment.Variables.Messages.BLOB ends up storing ''.

We use MS SQL Server 2000 and WMB6.

Any help would be much appreciated.

Thanks!!!!!!!