This content has been marked as final. Show 3 replies
You can just select from Your queue table the user_data column and parse it using some function.1 person found this helpful
this field is queue type datatype
Or you can use the TREATE function, for example
select user_data from queue_table qt where TREAT( user_data AS myPayloadType).myPayloadField='123';
thank you, aychin!
It's working for me now.
I've also found another way:
FROM (SELECT (SELECT str_value
FROM TABLE (qt.user_data.HEADER.properties)
WHERE NAME = 'DKT_ID') dkt_id
FROM my_queue_table qt)
WHERE dkt_id = '123'
Edited by: fschulze on Apr 20, 2010 4:02 PM