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"
UPdate Query problem in oracle stage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
viewtopic.php?t=119962
is this the same post
is this the same post
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia