DSXchange

Ray, I have been to the courses for EE. They have an essential and advanced. They are working on the EE administration course. The problem with these courses is, if the instructor is good, you benefit otherwise it's an expensive venture. My colleagues took the advanced course in Toronto, Canada and ...

Ray,

I have tried many thing and the exception handler doesn't fire. I tried setting the trigger and still it didn't work. I put Terminate stages to handle the Abort and it works. I still thing the second job causes confusion in the sequence. If I run one job it works.

The exception handler is not getting initiated and my colleagues and I figure that the the subsequent job is getting fired off before the exception handler is hit. The subsequent job finished normally and takes over the initial exception. One solution is to put a Terminator stage on all jobs. This e...

First, the trigger in Job 1 is unconditional. Second, normally when an abort occurs in any job, the exception handling module get initiated which in turn initiates the termination module. We didn't want to attach error handling in all Jobs of a sequence. From the documentation, we were able to make ...

There is no trigger in Job 2. Last Job in the sequence.

Not sure what you mean about the Exception Handler parallel, Could you please clarify

Check out the IBM Courses. Search for Datastage. I have been on the DS EE Essentials and Advanced. Their ok. The Essential will help if your new to the product, but experience and trial and error out way the courses. As for installation, ask IBM to assist. You will gain most of your experience from ...

I have a sequence job with two jobs, ie. Job1 ====> Job2 Exception =====> Termination (Stop Sequence) I wanted to test the exception abort routine and entered an incorrect File name in Job 1 so that it would abort. It did. The problem I face is, Job2 started and finished and the sequence ended norma...

You should first search the forum as there has been many discussion on this subject.

As for you question, no functionality loss. The compiler works well.

I am using the following command to export Job Executables. For some reason, the job design is exported. Could someone please tell me why the following syntax doesn't work. I added the /EXEC and it is not recognized. The manual doesn't cover the parameters very well. Thanks C:\IBM\InformationServer\...

I tried to use the DSSetUserStatus routine that is published on some posts but I keep getting this error when I test the routine. Routine: Call DSSetUserStatus(Arg1) Ans = Arg1 RETURN(Ans) TEST #1 ******* Arg1 = 'Jim' Test completed. DSLogWarn called from : DSRGetJob Message to be logged is... > Can...

I tried to use the DSSetUserStatus routine that is published on some posts but I keep getting this error when I test the routine. Routine: Call DSSetUserStatus(Arg1) Ans = Arg1 RETURN(Ans) TEST #1 ******* Arg1 = 'Jim' Test completed. DSLogWarn called from : DSRGetJob Message to be logged is... > Can...

Dam, I should of ask this question sooner. I ran into this problem months ago and the IBM engineer specifically told me that I need to run in multiple instances but he forgot to tell me that there was a check box. I assumed different datastage instances.

Thanks

I would like to create a common module that would be used multiple times to populate our Operation Data Mart. The Operational Data Mart contains start and end times, failure or successes, counts etc. This common module would be a unique DS program that would accept parameters and write records to th...

We have a requirement to extract and load the Operational Metadata into a Operational Data Mart. We are using Oracle 10g to store the Xmeta schema. I have looked through the tables trying to make sense on where the job information resides. Still haven't found it. I turned on the "Generate Opera...

Hi Ray,

I tested the space and the job would not compile. The solution as simple as it was, enter start in command prompt. It solved the problem.

Thanks for all responses.