Hi,
I am using MySQL to store the transformed HL7 XML message. Since the messages we plan to capture are production data, we need to encrypt them. Thus, I need to use AES_DECRYPT function to decode the encrypted messages.
The problem is the SQL statement in the DB reader of the channel.
Only msgid show up as variable; not HL7XML. Please advise the possible solution for this.
SELECT msgid,AES_DECRYPT(HL7XML,'123'
FROM inbound where sendstatus = 'N' and interface = 'Affinity' and buildnum = '111' order by msgid limit 1;
Thank you very much,
Charles
I am using MySQL to store the transformed HL7 XML message. Since the messages we plan to capture are production data, we need to encrypt them. Thus, I need to use AES_DECRYPT function to decode the encrypted messages.
The problem is the SQL statement in the DB reader of the channel.
Only msgid show up as variable; not HL7XML. Please advise the possible solution for this.
SELECT msgid,AES_DECRYPT(HL7XML,'123'

Thank you very much,
Charles
Comment