DSXchange

There is an Enhancements forum right here. Dennis and the team forward them to Ascential.

These are actually in 7.1r1.

3.0 came out prior to 2.5.

After all, they're only for uniqueness, aren't they?

Perhaps ".sss" rather than ":sss"?

Perhaps without milliseconds at all?

Or do they expect microseconds (".ssssss")?

A job is executed by a BASIC routine called DSD.RUN. Source code for this is not available. A Transformer stage is executed by a BASIC routine called DSD.StageRun. Source code for this is not available. The code generated for a Transfomer stage by compiling a job can still be viewed in RT_BPnnn, whe...

You could always use executed through ExecDOS or DSExecute.

So Ogmios, does that mean its possible on windows. If so how? The mechanism is the GCI (General Calling Interface). You need to set up a function definition (so that, when the function is called, data types can be converted from/to DataStage's "typeless" environment. This GCI definition must exist ...

If you're still having a problem, post the output of clicking More on this forum.

So Irrespective of wat parameters we gave in sub jobs, It will over write from Job Sequencer Parameters list...rt..?
Not necessarily. One choice in the Job Activity is the "Set to Default" button. This causes the controlled job's own default value to be used.

This error can also mean that all of the Oracle listeners that the DBA has set up are already in use, so no more listeners can be allocated. Check with your DBA, who should be monitoring such things.

there is a Java "pack" available. I don't know beans about it

It should be exactly the same, except that: command line arguments are accessed as %1, %2 and so on variables, including environment variables, are accessed as %varname% there is no such thing as a "here script" The last of these ought not to be a problem for a dsjob BAT file. Take a look at the BAT...

Your design as sketched is OK, but we can't see the stage and link properties. Populate your hashed file with the four key columns. Make sure that they are all marked as key columns. In your Transformer stage you will be required to enter four reference key expressions - presumably one from each rel...

There is only one sensible way to go about this task. 1. Analyse what the shell script does. Under all circumstances. 2. Write this out as an set of target from source mappings. 3. Implement the same as one or more DataStage jobs. Look for opportunities to optimize at each step in the above. Since y...

Check also why your lookups fail most of the time (all of the time for the Person lookup). Failed lookups actually take a little longer than successful ones. Is it possible to use one link rather than two to get the information from the Oracle database? The SQL would then need to join the two tables...