DSXchange

Thanks,
I somehow achieved to never run a job from a routine before. You're right, the whole thing is in removing DSWaitForJob.
Thanks again,
Pierre.

Hello all, Here is my problem : I have a table in my database which contains two columns. Let's call them C1 (String) and C2 (Booelan). I created a sequence job in DS. This job is a multiple instance job. For each C1 having C2 set at True, I want this job to be launched with the instance set at C1, ...

Here is how I would do : - create a job database->transformer->hashedfile - use the user-defined SQL query in the database stage - write the query SELECT DECODE(COUNT(*), 0, 'EQUAL', 'DIFFERENT') FROM TABLE_NAME WHERE COLUMN1 <> COLUMN2 - create one column in the database stage and one column in the...

Thank you for your reply, Kenneth. My job enventually ended, but it took about 12 hours ! You're right, the problem is probalby not with the command stage. There isn't any other stage within this job, but the last line in the log was : <JOB_NAME>..<TRANSFORMER_NAME>: DSD.StageRun Active stage finish...

Hello all, I have a problem with the command stage. I have a job that creates a directory. In this job, there is a Transformer and a link to the command stage. Only one row goes from the transformer to the command stage (dummy row so that the command is executed). The command stage executes an MS-Do...