DSXchange

Sorry, bad day. I do think most issues with Universe are self inflicted.

Explain to us why Universe is getting horked? You turning the machine off, rebooting for no reason, killing processes. I have used Universe for years and never have these problems. I work with unprofessionals who kill any process they want or shutdown DataStage during the day when developers are usi...

Tell them Ray man, Informatica sucks. Craig did that last month.

Ray has probably used it for years. Knows the creator personally. Dated his cousin.

How about it. Ray? Have we ever stumped Ray?

I think it still warns you but how else can you take advantage of this. The return values of a routine cause the sequence to fail. This is very powerful if used correctly. Ignore the warnings. This is cool. Surely others are using this functionality.

Then you have the ability to use any argument on any routine call. Say you call MyRtn(Arg1,Arg2,Arg3) you can change the value of Arg3 and pass it back to the sequence. The sequence can use this in a parameter value for the next job. You used to get a warning if you changed the value of an argument....

I think you could do this in one routine without a recursive call. That was my point. Build you a list of dependent jobs. Check the list before adding a job to make sure it is not already in the list.

You have one row per link. A job can have multiple links.

What version of DataStage are you on?

Recursive calls do work but I think this is a very poor idea. You are doing a SQL select without a ; at the end. Maybe that is the problem. What is the point of this? Do you just want to test recursive calls?

Edit your post and put code tags around your routine.

It is red but it should compile and run.

You maybe looping back on yourself. So you are in an infinite loop.

Took forever to get the last few but thanks.

DataStage Server Routines are stored in DS_ROUTINES. I posted a job called KgdGenHtmlRoutineDocs which will print a routine out as html. Field 7 is the argument count.

Forget it. The only way to learn this stuff is to download the Universe manuals. Ray has posted the links many times. You can even download a free copy of Universe for home use.