updating in wuery in Orcae 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"

[Minhajuddin]

samad, DSXchange is a site run by volunteers for free. And people here make sure that they do *not* answer urgent questions. I see that this is your first post, Welcome to DSXchange :D But don't put any "urgent" requests in the future.

Have you pasted the exact query used in the job? 'cause if you have there are lots of problems with the query:

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;

all the columns from input should be preceded with an "ORCHESTRATE." (note the spelling) So the highlighted part of your query should be replaced with:

UDATE DTS = ORCHESTRATE.GFSTU_TO_GMT_FN,
UPADTE_USERID=ORCHESTRATE.USER,
SUBMIT_OPTN_ON_RQST_DTS= ORCHESTRATE.GFSTU_FN
WHERE
OPT_OPTN_RQST_ID = ORCHESTRATE.REQUEST_ID

[ray.wurlod]

Please also endeavour to choose meaningful subject lines, to assist future searchers.