UPdate Query problem in oracle stage

[samad40]

hi,

i have a reuirement,

seqfile---copy--- oracle ---trandormer--- seqfile

the process is like this
This job updates the PROCESS_STAT_CODE, SUBMT_OPTN_ON_OPTN_RQST_DTS and SUBMIT_OPTN_OPTN_JOB_RUN SAKEY
in GMCMV24_OPTN_ON_OPTN_RQST table for the records which are processed.

the query is like

UPDATE
GMCMV24_PT_OPT_OPT_RQST
SET
PROCESS_STAT_CODE= 'S',
RQST_JOB_RUN_SAKEY = #JobRunID#,
UDATE DTS = GTSU_DATETIME_UTILITIES_PA.gfstu_to_gmt_fn,
UPADTE_USERID=USER,
SUBMIT_OPTN_ON_RQST_DTS= GTSU_DATETIME_UTILITIES_PA.gfstu_fn
WHERE
OPT_OPTN_RQST_ID = ORCHSTARTE REQUEST_ID;

fatal error is comming like this

main_program: Could not check all operators because of previous error(s)
TRNS_CHK_RJT_RECS: Error when checking operator: Could not find input field "OPTN_OPTN_RQST_ID".
Error when checking operator: Could not find input field "REQUEST_ID".
Error when checking operator: Could not find input field "sqlcode"

[keshav0307]

viewtopic.php?t=119962
is this the same post

[keshav0307]

the query should be

UPDATE
GMCMV24_PT_OPT_OPT_RQST
SET
PROCESS_STAT_CODE= 'S',
RQST_JOB_RUN_SAKEY = #JobRunID#,
UDATE DTS = ORCHSTARTE.gfstu_to_gmt_fn,
UPADTE_USERID=ORCHSTARTE.USER,
SUBMIT_OPTN_ON_RQST_DTS= ORCHSTARTE.gfstu_fn
WHERE
OPT_OPTN_RQST_ID = ORCHSTARTE.REQUEST_ID;