DSXchange

Sort by Type then in descending order by Value. Use stage variables to detect a change in Type and set the flag to 'Y' where this occurs and to 'N' otherwise. svIsChanged @INROWNUM = 1 Or InLink.Type <> svPrevType svPrevType InLink.Type svFlag If svIsChanged Then "Y" Else "N" Not...

On what basis are you trying to look up file count and reject file count? If the source file is empty, then no rows will be processed and no lookups will be performed. Create a filter command on the source file to test whether it is zero length. Then you will have one row on your input stream, conta...

You are trying to create a job name that is already in use as a hashed file (or UniVerse table) name. This is not permitted. Choose a different job name, or rename the hashed file. One name, one thing.

Out of curiosity, what is the job name that is being refused?

Check for permissions on the DSParams and DSMFParams files in your project on the server. Also check for the existence and permissions on files matching the pattern .*.adm in your project on the server.

You claim that the second field is an integer but have described the "H" record type as having a date in the second field.

The problem is with your stored procedure, or perhaps with the syntax of the CALL statement. It might be worth enabling an ODBC trace to see what's being requested. Can you post the code of your stored procedure? Does your DBA suggest what the "unimplemented optional feature" may be? Have you search...

Oh, there is so too!

If you right-click on a red expression, you can choose "Validate Expression" from the menu, and DataStage will report t you what the parser in the Expression Editor believes is wrong with your syntax. There is also a Transform called NullToZero that you may prefer to use - though it only gives a si...

All you need is date_from_string[%yyyy%ddd](InputDate) in a Modify stage, or StringToDate(InputDate, "%yyyy%ddd") in a Transformer stage. The result is a date. Its internal format is immaterial. It can be used to populate a field whose data type is date. If you need to convert it back to a string, t...

A job sequence? JOB1 --> P1 --> ExecuteCommand --> JOB2

If P1 is an ExecuteCommand activity in its own right, then it might be wrapped in a script whose exit status can be tested, thereby avoiding the second ExecuteCommand activity.

Check that you have write permission to the folder where the COBOL and JCL are to be written (configurable, so you might also like to try a different location). Check also that the disk is not full and that there are no quota restrictions.

Use (Auto) here. You only need explicit partitioning if rows need to be grouped (for example by key for join/lookup).

Reset the job. Look for a log event "from previous run". It will tell you what happened. You would be better off designing this job with a Transformer stage between the source and the Hashed File stages; even though it does nothing it makes stage tracing and debugging much easier. Did any rows get i...

It's the "D" word that will get you guys.


Guiding principle: there will never be time to retrofit documentation. Do it first. "Later" never happens.

Maximum precision of numeric data within DataStage server jobs is, by default, 15 significant digits. This default can be overridden with the EXACTNUMERIC configuration parameter in uvconfig. The PRECISION statement in BASIC affects the maximum number of digits that will appear to the right of the d...