multiple update statements in oracle enterprise stages?

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
srinivas.nettalam
Participant
Posts: 134
Joined: Tue Jun 15, 2010 2:10 am
Location: Bangalore

multiple update statements in oracle enterprise stages?

Post by srinivas.nettalam »

I am writing mulitple update statements in oracle enterprise stage(target).But i am getting an error
" main_program: (aptoci.C:456). Message: ORA-00911: invalid character" and the job is aborting.The similar query worked to load SQL Server tables but for oracle it is not working.Would someone help on this??
statements used:
UPDATE sor.cl_xref SET SRC_CL_SCM_NM = '#SRC_CL_SCM_NM#'
WHERE (SRC_CL_SCM_NM = 'IP_TP' AND SRC_STM_CODE = ORCHESTRATE.SRC_STM_CODE)

UPDATE sor.cl_xref SET SRC_CL_SCM_NM = '#SRC_CL_SCM_NM1#'
WHERE (SRC_CL_SCM_NM = 'CSTMR_LCS_TYPE' AND SRC_STM_CODE = ORCHESTRATE.SRC_STM_CODE)
UPDATE sor.cl_xref SET SRC_CL_SCM_NM = '#SRC_CL_SCM_NM2#'
WHERE (SRC_CL_SCM_NM = 'INDIVIDUAL OCCUPATION TYPE' AND SRC_STM_CODE = ORCHESTRATE.SRC_STM_CODE)
UPDATE sor.cl_xref SET SRC_CL_SCM_NM = '#SRC_CL_SCM_NM3#'
WHERE (LCL_CL_SCM_NM = 'LANGUAGE' AND SRC_STM_CODE = ORCHESTRATE.SRC_STM_CODE)

UPDATE sor.cl_xref SET SRC_CL_SCM_NM = '#SRC_CL_SCM_NM4#',
LCL_CL_SCM_NM = '#LCL_CL_SCM_NM#'
WHERE (LCL_CL_SCM_ID = ORCHESTRATE.CL_SCM_ID AND SRC_STM_CODE = ORCHESTRATE.SRC_STM_CODE)
N.Srinivas
India.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Try using a semi-colon at the end of each statement.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply