DSXchange

Yikes, we just set the Wayback Machine to 2003 it seems. Those 'Version 7 job templates' never materialized for Server jobs. They made a brief appearance and then were yanked from what I recall. Something similar branded as 'Wizards' is in the product, I do believe, but only for PX jobs. I'll look a...

Umm... it's the Terminator that's new; the Exception Handler has been there since job sequences were introduced. Umm... yes, but with the introduction of the Terminator the behaviour of the Exception Handler changed. For the better. Prevously it would only detect and handle problems in the Sequence...

chucksmith wrote:We have had issues with Designer 7.5.1.A deciding to crash usually when working with sequences.

There's a patch for that!

Factor in the 'overhead' of calling out for the system date/time on every record through the transformer. I'm not really sure how much it adds, but it must be something. Balance that against doing it in Oracle, where the overhead is negligable as far as I know. The downside would be it would only wo...

DSguru2B wrote:In sql server you do it by the function getdate(). Dont know its equivalent function in oracle.

sysdate

Cool. :D

As noted - one field with a single forward slash as the XPath expression.

Or better yet. Define a link coming out of all the 5 job activities going into the sequencer stage with mode set to "Any". Have a link coming out of the sequencer stage going into the terminator activity. That will get your work done. Overkill. And so Old School. If you've got the Terminator stage,...

I would disagree that "it doesn't work"... more correct to say you haven't gotten it working. Yet.

I suggest setting up your sequential file with one large varchar field to hold the entire record, then just use a forward slash "/" as the XPath expression. That should get you much closer.

'conformed'. And he said 'in star schema terminology'.

You would need to 'SOA Enable' the job to accomplish what it seems you are asking for... and that would require the purchase of that component. There's nothing 'real time' about DataStage otherwise.

You've completely lost me.

If you are saying the current output is correct but it all needs to be in one sequential (non XML) file - have you tried an Output link from the XML Output stage to a Sequential File stage?

Anything can be hacked, for goodness sake. They biggest question here is - why bother when the tool provides a simple mechanism to do it? Why take the chance of horking it up like we saw recently with one of our members...

Where exactly was this error generated? By the SP or when you 'select few columns from tables A and B' after that? Are you using User-defined sql? If so, post it and your datatypes.

Sorry, if you say you've tried it then you must be in the position that Arnd notes where all paths on the new machine are identical. I'd still be leery of doing a 'disk copy' of internal structures for pretty much *any* software I knew used interlinked repositories and other complex internal structu...