Posted: Sun Sep 01, 2002 11:21 pm Post subject: BLOB to Searchable Characters
Newbie
Joined: 01 Sep 2002 Posts: 3
Hi MQSI Experts,
I'm brand new to MQSI. I want to save Root.MQMD.MsgId into database in searchable format.
First, I cast Root.MQMD.MsgId from blob to character and save it into database, but casted characters has abnormal character, DB2 refused to search .
Joined: 05 Sep 2001 Posts: 3779 Location: Torrance, CA, USA
MQMD.MsgId is a BLOB field. You should define this field as BLOB (4 into db. If you are not able to search on BLOB field then deine the field as CHAR(4 into db and use ESQL SUBSTRING(CAST(Root.MQMD.MsgId AS CHAR) FROM 3 FOR 4 to store value into db. _________________ Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
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