problem in Oracle stage

[samad40]

hi all

my requirment is like this


seqfile ----copy--- oracle stage-- transformer---seqfile_ERR_code

in seqfile - OPTN_OPTN_RQST_ID and REQUEST_ID
this seqfile i called the dataset by using jobrunid ok

and copying in the copy stage

in oralce i am writing a query like this
UPDATE
GMCMV24_PT_OPT_ON_OPT_RQST
SET
PROCESS_STAT_CODE = 'S',
RQST_JOB_RUN_SAKEY = #JobRunID#,
UPDATE_DTS = ORCHESTRATE.GFSTU_DATETIME_UTILITIES_PA.gfstu_to_gmt_fn,
UPDATE_USERID = USER,
SUBMT_OPTN_OPTN_RQST_DTS = ORCHESTRATE.GFSTU_DATETIME_UTILITIES_PA.gfstu_to_gmt_fn
WHERE
OPTN_OPTN_RQST_ID = ORCHESTRATE.REQUEST_ID

and transformer -- asusual liking

OPTN_OPTN_RQST_ID,REQUEST_ID and sqlcode columns


in seqfile_ERR_code - JobRunID#_Errlog.txt


i am loading the v24 table but
we also have to update the status in V25 table. So i have to make this modification in the update job.


is that query rihgt and is that the flow is right

[rajngt]

Can you tell me what is your requirement and what you are trying to do?

[keshav0307]

did you tried this approach.
are you having any difficulty running this job?