DSXchange

search

You sure you were answering the right question here, Ray?

My wildcard? No, I simply use it to remove a single hashed file directory and the associated dictionary file at once, not do anything en masse. Just trying to turn two steps into one, still inside the loop.

Or they had changed it in the old installation but failed to make the same changes in the new installation. Hmmm...

Well, there you go... much smarter solution.

Time to mark your post as Resolved.

As to the 'gets stuck' part, have you had your DBA check to see what was going on when that happens? Some other process locking this one out, perhaps?

No, it won't actually launch the job - would I lead you astray? It will just query the job and dump all relevant 'info' about it to standard out.

So... you 'resolved your issue', meaning you actually wrote a routine to connect to Oracle? Or did something else?

I would do something like this in a simple little Server job, if you felt it really needed to come from Oracle.

To answer the last question, script a call to dsjob with the -jobinfo option then grep out the Job Status and check for RUNNING.

StartLoopStageName.$Counter

Now, as to whether you can reset it or not inside the loop? [shrug] Never tried but go ahead and give it a shot.

No, not the wrong stage per se, it's just that it was built with a fixed end in mind. What you'd really want to build is an RTI job, but (I assume) with that not being a possibility... What you could do is hand code something similar to the Loop stages in a batch job but without the hard end point. ...

We'd never let that happen, now would we?

I typically stick a splat in front of the hashed file name and get both in one swell foop: Command = "rm -rf *" : HashFileName Call DSExecute("UNIX", Command, Output, ExitStatus) Now, I suppose there is a danger there of deleting more than expected, depending on your nami...

No, there isn't. Assuming you have the grants to do this, you would need to script/code in their removal before the load and then reinstate them after the load.

Welcome. :D Define 'continuous' and 'infinite' in your case. The loop counter can be a rather large number (9 9s from what I recall) - are you saying that you would need to loop more than that number of times in a continous run? Perhaps an idea of what kind of problem you are trying to solve is in o...