DSXchange

Investigate DSGetStageInfo() and DSGetLinkInfo() functions; each can report row counts. You can embed these in a routine that you can invoke via a Routine activity.

The Join stage allows you to perform a standard join - it has one output only - the results depend on how you specify the join. There is no capacity for rejected rows. The Merge stage allows you to perform pairwise lookups, with separate reject links for each reference input. A row appears on the ou...

And how do you want to convert that octal? Into decimal numbers as ASCII strings, or into ASCII characters that correspond to the code points represented by the decimal equivalents of those octal numbers?

The major number reflects the version of DataStage. The minor number is the number of times the component has been released/promoted. The point number is yours to do with as you wish. If the point number has been incremented, Version Control does not automatically increment the minor number.

Use Cleanup Resources in Director to identify processes and locks held by those processes. Release these locks then you will be able to recompile. If you can not see all the locks, then you may have locks held by defunct processes. You could try using dsdlockd on the server to check whether any of t...

This is precisely the task that QualityStage performs, almost out of the box. You can invoke a QualityStage standardization task through a QualityStage stage in a DataStage job.

This technique is called a vertical pivot - a search will reveal a few approaches that people have taken to it. It's tricky to do in parallel jobs and retain parallelism.

How are you invoking the script? If it's via ExecSH you can simply make the file name a job parameter and use the parameter reference in both locations. If through DSExecute in one of your own routines, you can simply build the command into a variable, having passed the file name as a routine argume...

The column name is JOBNO, not JOBID.

Is "clear table" implemented with a DELETE statement (which would have to be logged in case of a rollback)?

There's nothing in the DataStage error message that talks about DB2 logs; why do you assert that this is happening?

Rats! I thought this old dog could learn a new trick...

Hadi wrote:When do we use Scheduling tool in DataStage Director then? What is it used for?

Schedule view in Director is nothing more than a GUI front end to the operating system scheduling service; cron or at command.

Don't rely on UniVerse unless you have a UniVerse licence. The next release of DataStage does not use a UniVerse-like repository. ... then, what would be used to replace Universe as DataStage repository ? thanks, xli The next ("Hawk") release has an "open" repository that is shared by all the Ascen...

Can you please explain how that logic excludes the final row?

UtilityWarningToLog is not cataloged with a DSU prefix. None of the SDK routines is. You need to look at its VOC entry (I don't have DataStage available at the moment, otherwise I would have done) to determine the actual catalog name. SELECT @ID FMT '32L',F1,F2 FMT '32L' FROM VOC WHERE @ID LIKE '%Ut...