DSXchange

Hello, I have a job which is used to concat several Datasets into one to be loaded into an Oracle table. So, its design is Oracle Dataset_1 | .. --> Funnel --> Lookup --> Dataset Dataset_n Each input Dataset have the structure: Col1 Col2 (used for the lookup reference) Col3 Col4 And my Output Datase...

Hello,

I need to do exactly the same, and I get exactly the same error. Did anyone find the answer to this?

Thanks,

mjgmc

Thanks :) I've finally got what I needed. It's really bad documented this part of Datastage, right? This is my new code and it works fine. A bit slow, but it's ok, it's not part of the regular process: Ans = @FALSE RoutineName = "RtrGetSeqStages" Usage = RoutineName:'(JobName)' * ---------...

ArndW, As I'm not a Charter Member I don't have access to whole of your message. :( But I suppose you suggest me to run a quey with DSExecute, right? I've already tried it and whenever I run my routine (to test it), it never ends. Is it a normal behaviour? This is the code of my routine: Ans = @FALS...

I need another information: Each Activity and Link and its type from a Job Sequence. I know that information is in the table DS_JOBOBJECTS, and I can get it from the command line as: select DS_JOBOBJECTS.NAME, max(DS_JOBOBJECTS.OLETYPE) from DS_JOBS, DS_JOBOBJECTS where DS_JOBS.NAME='JsJob' and DS_J...

Thanks for the answer. In a matter of fact I realized that the field JOBTYPE from DS_JOBS has the following values: 0 for Job Server 2 for Job Sequence 3 for Job PX I think this can help. Even if I'm not abble distinguish a common Job Server from a Job Control. I'll keep looking inside these two tab...

Hello, I hope I'm posting in the right place. If not, please tell me. I'm developping a Job Control which will verify some information about a Job which name will be passed as a parameter. I've found almost all the info I need, but I'd like to know if there's a way to find which type of job I'm look...