updating 3rd parties db table using JDBC adapter at sender side

33 Views

hi all.

i just want to know how i can updated the 3rd party db table field.

my scenario is just to retrieve data from 3rd party DB table where the condition is like " to select records where processed (field name ) = " ".

but i just need to update this field to x immediately after retrieving data from it.

so i simply wote the sql statement select REC_NO, ACTN_DAT, METRNO, MET-READ from PHAKAMA_CONN where processed = " ". under jdbc CC query sql stmt at sender side .

but i want to know how we can updated the processed (field ) from " " to "x"immeidtely after retrieving.

so could any body advice me how we can achiev this through UPDATE SQL STMT under sender jdbc cc.i just want to know wat stmt do we need to srite under this.

waiting for u r response.

cheers.

seeta ram.