DSXchange

What wnogalski is suggesting is you take your job control code and put it into a custom routine. Pass the value of the parameter that it looks up back out as the 'Ans'wer. Then, you can use it in the Sequencer job just before the Job Activity stage that needs it. Use a Routine Activity stage to run ...

I would agree. DataStage tends to screw with your quotes when you are trying to do something like you are doing. Best solution is what Ken posted, build a shell script to do all of the dirty work and then use DSExecute to call the script, passing in parameters. The other thing to realize is that you...

This is hacked from a longish post over in the Server forum:

Mike wrote:The easiest way to have a child job inherent the same invocation id as the parent sequence job is to us the macro DSJobInvocationID in the expression for the child job's invocation id.

Edit: (waves at Vincent)

I agree... you are defeating the whole purpose of using an ETL tool if you push the processing off to stored procedures. Now, I've seen times when that was the only option, like two-phased commits or other situations that DataStage doesn't handle. Other than that, I personally see no reason to have ...

Sounds like you are using the new feature to 'automatically handle jobs that fail'. Routines that return a non-zero value are considered to have failed when that option is turned on. Two things to try: 1) turn off the option 2) Add an 'otherwise' trigger so that it thinks you are handling the error ...

I don't have access to a 7.5 server right now, so can't check the DRS stage right now. Be careful of the Transaction Size on the General tab, it is mostly there for backwards compatibility with older releases - at least that's the case with the OCI stages. If there is a specific Transaction Handling...

What stage are you using? Typically, you should be able to find a Transaction Size tab, this is used to set your commit level. Zero equals only commit at the end, any other number means after that number of rows.

The 'GUI' solution is to write a routine that uses DSExecute to launch the script. You can then use the Routine Activity stage rather than the Execute Command stage, which will take parameters. I think this may be fixed in 7.5 but would have to check the readme. Sorry, just noticed that this is basi...

However, if you look at the original post you'll see they are (hopefully) on a Windows server. So, a Windows solution would be something similar with 'dir': dir /b /od This gets you a 'bare' listing (just filenames) sort in date order ascending. I'm not aware of any way to reverse the listing, so yo...

Exactly! Set the data type to Date or Timestamp and the Oracle stages will automatically use the appropriate TO_DATE function. That's why it's important to make sure the fields are properly formatted before they hit the output stages. BTW, as noted, only two digits for the seconds are allowed in an ...

Biggest thing to realise is that when you do this to a log file - the CLEAR.FILE clears everything from the log. Not just the log entries but the control records as well, so you'd lose any Auto-Purge settings you may have had and would need to reestablish those after doing so.

Hard to say without knowing what error message(s) you are getting, what your shell script looks like and how exactly you are executing it.

About all we could tell from what was posted is it looks like you are running on HP/UX.

Well, not knowing the gory details of the substructure, or what you consider to be 'the obvious', this will be the Reader's Digest Condensed version. The Status 'file' basically holds exactly that - the current status information for the job. Running, Aborted, Ran Ok... possibly even if the job is o...

If it was really set to 'No Limit', it wouldn't abort after 50 warnings. The question is - How are you running the job? By hand from Director, you get a chance to set the warning threshold. If you are running it from job control or a Sequencer job, then it will inherit the setting from the controlli...

Or use the "Truncate table then insert rows" Update Action directly in your job.