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
problem in Oracle stage
Moderators: chulett, rschirm, roy
problem in Oracle stage
samad
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia