rts wrote:
Thanks oscar. Any information would be helpful. I have a channel setup and working that is using JDBC-ODBC. I am somewhat confused regarding the SQL panel in the DB Reader setup. When I perform a dbselect in that window can the result set be processed by the transformer ? Or would I be better off performing my selects in the transformer ?
I am basically looking to do the following:
DBSELECT x,x,x,x,x from OutPut where status = 0
For each row in resulset
{
Do conditional HL7 formatting (Ie ADT, SIU etc)
UPDATE Output set status = 1
Where x = ${x}
}
I am basically looking to do the following:
DBSELECT x,x,x,x,x from OutPut where status = 0
For each row in resulset
{
Do conditional HL7 formatting (Ie ADT, SIU etc)
UPDATE Output set status = 1
Where x = ${x}
}
Leave a comment: