Skip to Content
Former Member
Feb 13, 2012 at 09:18 AM

How to run update query statement to update a table cell


I have a job within that has dataflow which loads data to target after teh dataflow is done loading, i would like to call to run the following: in the workflow context do i need to add a script object , plus also the below query is it the proper way to run an update statement.

sql('Target_DS','update tbl_job_status set endtime=sysdate() where endtime is null');

Thank you very much for the helpful info

kind regards.