DSXchange

Thanks a lot to Andy and Ray for the help.... :)

Hello, I have one list loop which calls one sequence. The sequence is called for each of the parameter which is getting passed from the loop. I need to implement the restartability here.ie If the sequence fails while processing the 5th parameter, when restarting the job,it should skip running the se...

This is one of the requirements that, we have to use routine to call the job. I have used dssetparam and configured the parameters.

Thanks for all your help..


Linda

It is a server routine...

Adding the stage variable and including the constraint resolved my issue.


Thanks a lot for all your help..

I need to load the tables daily. But before loading the data, I need to truncate the data, so that only one day's data will be present there. Also while inserting data I am getting value from one oracle source table and few parameters. So I need to refer the parameters also in the insert statement. ...

Hi,

I need to truncate and load the Oracle table in a parallel job using Oracle_Enterprise stage. While loading I need to pass customized SQL also.But I could not find any options for the same in Oracle enterprise stage.

Could you please help me on this.

Thanks in advance...

Linda

Thanks a lot for everyone's help.I tried using loop activity with list. I am able to pass one parameter each time.But I need to pass 4 parameters for the job activity and those 4 parameters should differ for each run.

Please let me know,how to handle this.

Linda

Hello,

I have a sequencer which in turn calls 2 sequences and a job activity. After the two sequences completed successfully, I want to run the job activity 4 times,each time passing different parameters.

I am relatively new to datstage.Could you please help me to implemet this.