DSXchange

First check I'd make is to ensure you haven't run out of space wherever you have DataStage installed.

This is pretty straight-forward to solve. Use a pair of Stage Variables to do a check for repeating groups: First one is your counter, start it at 1. Second one is your 'old' value of col1, start it at a value that doesn't exist in your source. A question mark, perhaps. When a row comes in and the c...

Use the SEEK command. There's an example in this post that should help.

Without going into tons of detail right now - DataStage Server Edition 'uses' BASIC, DataStage Enterprise Edition (EE/PX) 'uses' C++ as its foundational language. Are they all the same thing? Yes, in the sense that they are all programming languages. What is the difference? They are different progra...

There's nothing different about the way a constraint is defined for character versus numeric data. You code an expression that evaluates to True or False and the row either is passed out through the constrained link or not, respectively. You may be having an issue with the nature of the data you are...

No worries. I know how that happens, especially with these multi-page wonders where you miss something from an earlier page. :D

kcbland wrote:There's also no warp-drive engine, time travel machine, or cure for the common cold.

Patience, Buckaroo. As noted, it's not all that far off.

Windows server, Ray, otherwise I would have gone through some of that earlier.

Agreed. You really shouldn't have any jobs so large that they require multiple developers to work on different parts of them. We manage many projects as well, it's currently around 15, primarily divided by subject area. We also have common jobs and routines, but there are rules in place for where th...

Wrong thread, Vince.

We will need the ability to merge changes made by different developers to the same datastage job. Curious how you are managing this. Version Control doesn't support this functionality because DataStage doesn't either. Only one developer can have a job open at any given time, so unless you are going...

Welcome! :D Which version of 7.x do you have? From (I believe) 7.1 forward, there is an option on the Job Properties tab of Sequencers to add restart checkpoints. It will give you the ability to do what you want 'automagically' without all the goofy coding needed in earlier versions. Make sure you r...

Excellent!

Try changing your definition to Decimal(40). Works for Server, not sure about PX.

Ok, silly question time... why can't the Sequencer simply run Job2? What functionality does Job1 provide other than running Job2? Depending on how Job1 is designed, it may be able to check on the status of Job2 itself and, if there is a problem, drop a warning of some kind in its own log. The Sequen...