DSXchange

Don't know for certain, but I don't think it will support that. From what I recall, what the Stored Procedure stage does support is listing in the pdf documentation for it, have you checked that?

The old way is to bump the date to the first day of the next month and then subtract one day from the date, something you could build a routine to do. If you wanted to use what is built into the Server product, investigate the MONTH.LAST transform under the Built-In\Dates category.

Sounds like you'll need to add conditional branching into your Sequence job. You can use the Nested Condition stage or simple triggers to 'branch' streams around jobs if you need to, and Sequencer stages set to 'Any' to join the streams back together again.

I haven't had any issues with the SP stage and Oracle. We use it for a small number of user-written procs and also to call system procs. You should have it in an anonymous block, see if this syntax works better: BEGIN #DSSchema#.PHR_UPD_URSULA_MASTER(:1); END; Mark your single column as a Ke...

It's stored in the registry. If you uninstall the Client and then (via regedit) remove any last vestige of 'Ascential' registry entries, it should come back fine when you then reinstall. I also seem to recall someone posting the actual registry keys. If you know those, you can simply delete them usi...

rleishman wrote:The functionality of the Surrogate Key Stage is duplicated in a new "Surrogate Key" tab in the Parallel Transformer. It does nothing extra or special, it just permits you to have one less Stage on the design pane.

Interesting, thanks for clarifying that.

I've seen it before.

http://www.dsxchange.com/viewtopic.php?t=113576

Have you tried using the ODBC stage?

That behaviour must be new with the 8.x release, at least for the Surrogate Key stage. I don't see how you can claim the same behaviour with the Transformer, but whatever. Why not answer the question yourself? Arrange a test job with the appropriate stage to abort part way through and observe the be...

Search is your friend - here's what turned it up for me:

http://www.dsxchange.com/viewtopic.php?t=109896

You asked "does DataStage stores last value generated from the current abort" and the short answer is "no". Meaning nothing about your surrogate keys are stored by DataStage. Every time the job runs, you need to tell it where to start numbering regardless of the outcome of the previous run.

1) Nothing is stored automatically. 2) The surrogates will start with whatever value you tell it to, the default starting key value is zero. Pass it in as a job parameter. what would be the right approach to pass max vlue from warehouse table other than reading value in the file from sequncer job an...

Good Lord, people. Which part of "you'll be in breach of your contract if you email out the files" or "your licensing agreement with IBM expressly forbids what you are proposing to do" is so hard to understand? Stop. Never mind the fact that the person allegedly willing to bring down the wrath of IB...

Sorry, was being a smarty-pants so you would post the correct entry.

Can't really help but found this parameter amusing:

Lie = false

?

Interesting... didn't realize you could use Oracle wire drivers with Netezza.