DSXchange

Not able resolve the parameters defined in dsenv file even though we defined the same parameters in the DSadmin/user-defined-variables. Getting below error while running the job Missing Parameters $NOTIFY_EMAIL_SMTP_SERVER [$ENV], $NOTIFY_TO_EMAIL [$ENV], $NOTIFY_TO_EMAIL_FATAL [$ENV]. Appreciate an...

Thanks much

Can anyone tell me how to define/add multiple UNIQUE keys on a table which is being inserted with data.

The columns in the table are C1, C2, C3, C4 and C5

Unique Key1: C1, C2, C3 & C5
Unique Key2: C1, C2, C4 & C5

Can you please tell me how to define/add these in Datastage?

Thank you

Actually when I change the stage and link name in the routine activity the issue is resolved, though it looks strange.

Thanks all for your time and help

The Options checked are
1. Add checkpoints so sequence is restartable on failure
2. Log warning after activities that finish with status other than OK
3. Log report messages after each job run

But not "Automatically handle activities that fail"

Am calling the routine in a Routine Activity with in a sequnce

Hi Thanks for your time. But 1) The check box is unchecked 2) I have 3 activities/links from the routine activity with below condition return value > 0 -then - CALL Next Job return value >= 0 -link to a sequncer which collects the status of all "Finished Ok" return value < 0 - link to a se...

Hi Gurus, Am new to Datastage and trying a small case study. My requirement is like this: I have 1 job which inserts records in a table based on some condition. Then i have a routine to check if the earlier job inserted any rows in the table or not; if yes, then proceed with next job else exit from ...