DSXchange

Thanks Kenneth, Your suggestion worked a treat and that job is now history.

Hi I have a corrputed RT_CONFIG file which I am unable to get rid of. Somehow the job got corrupted (only this job) and I want to simply remove the job from the repository but am unable to delete it. I get the error message Cannot open executable job file RT_CONFIG454 . I have tried the CLEAR.FILE c...

Hi srinagesh,

Thanks for your suggestion. Does the NLS_LANG environment variable setting for the job simply override the default value as read from the DSENV file?

katz

I am getting the following error during the last stage of my job (which happens to be an OCI) and my job aborts. DSD.StageStatus: Wave sequence error, resource "testMEtemplate.Transform_and_Validate.OverWrite_RS_HF.SI_Pass_Thru_read" has CUR.WAVE.NUM=2, was looking for wave 1 Although thou...

Hi narasimha, I am referring to the screen input item of the Oracle OCI Stage which is performing the insert operation. Look for an input box labelled "Rows per transaction" on the Transaction Handling tab, of the Input tab. This value determines the number of rows inserted before committi...

I agree with the previous suggestions to use the Bulk Loader in your scenario, and have only the following observation regarding the "ORA-01555: snapshot too old" error. It sounds like you are experiencing what is known as "Fetch across commits within an open cursor " and in this...

Thanks for your responses. My working hypothesis is that the "unable to unlink" msg is related to the concurrency/timing of the executions of the job. The after routine collects information about the job just run (status, timing, parameters, link row counts, etc..) writes these to a sequen...

While running a job from an After Job Subroutine I occasionally get a message in the Job's log like: From previous run DataStage Job 65 Phantom 3064 Program "DSD.RUN": Line 490, Unable to unlink the operating system file "DSD.RUN_64235_13598". It appears that I get this msg when ...