DSXchange

can you give me more explanation about your answer or show me an example of code you use in your job control... Don't really have an example handy, but perhaps a quick overview would help. One thing I'd suggest is for you to build an example Sequencer job and have it run several jobs at the same ti...

Hmm... not really using this feature of Sequence jobs, so not sure about some of the subtleties. Question - what other triggers do you have off the routine? Do you have an 'Otherwise' trigger or something else that handles what it would consider 'failures'? From what I recall from reading the releas...

Mat01 wrote:The generated job control code for the sequencer checks the return code of the routine. If the return code is not 0, it fails!!!

Which is exactly what the post I sent you to explains, including Ray's advice.

That's just... odd. As I've said, I've had zero problems with Column Generated, but then I haven't moved on to 7.5 yet. Perhaps there's an issue with the OCI stage, or something in the upgrading of the job.

Before you changed it to User Defined - what was it? Full or Column?

Haven't tried as I haven't been exposed to 10G yet. I can tell you, however, that official 10G support comes in the 7.5 release.

Check this post and see if it helps.

The answer is... depends. On many things, like the setup and speed of your database and database server versus your DataStage server. Only way to really know is to do it both ways and see. At the very least, order your output rows to support the aggregation you are doing and mark the 'Sort' columns ...

Sure, that's what I thought you meant but wanted to be sure. We do this very thing via Job Control wrappers, the utilities that execute each job. One of the 'parameters' associated with each job is a threshold much like you mention. The job control code constantly monitors the execution time versus ...

One thing to keep in mind - if the utility is available from the command line, i.e. is in the engine's 'bin' directory, I believe it can take an optional pathname and not need a VOC record.

Xanadu wrote:Yeah, I run Windows XP with SP2 on my laptop.

Several posts here and on DSN about SP2. Ascential has even posted something there to the effect that they encourage people to not install SP2 on a machine running their software at this time...

p.thier1 wrote:Is is possible to define a timeout for a job ?

Depends on what you mean by that. Expand on it a little for us...

In general, upgrades are extremely painless affairs. Unfortunately, from what I recall, the times I've seen people reporting issues here seem to have been when people running on Solaris.

Hopefully, someone on your same O/S who's done a recent upgrade will chime in.

Any chance you are running XP and installed Service Pack 2?

Yerk. Can't help with the DB2 problem, but can with the Oracle one. You really need to read the pdf docs for the OCI plugin, it explains what format each datatype is expecting in the stage. Dates are expected to be handled as a Timestamp data type and should be in the following format: YYYY-MM-DD HH...