DSXchange

It's not an error, it's really an informational message. Each DataStage phantom (background process) is allocated a segment in shared memory. For historical reasons, this segment is called the process's "printer shared memory segment". When a process is finished, and another process starts soon afte...

How about the PREVDTD and PREVDELETOR columns in my previous answer?

The exit status of the dsjob command without its -jobstatus option is exactly that, the exit status of the dsjob command. Even if the job failed in DataStage, the dsjob command (which requested the run) completed successfully, and will return 0. The -jobstatus option not only produces a job status r...

Write caching disabled is usually an informational message. When a hashed file stage has an input link, an information message is logged to show whether write caching was enabled, disabled, or unable to be used (normally because the hashed file is larger than the space allocated for caching in the p...

Can you start a new thread with a subject "COMMON variables"? There are quite a few things that need to be said about them. One is that their use inhibits later conversion to Parallel Extender components.

For a gentle introduction to multi-valued columns, look here . Before you can use multi-valued columns, in hashed files or in UV tables, you have to enable them in the metadata. Because none of yours have multi-valued columns defined, the "normalize on" button is disabled. If you did have multi-valu...

There is a table called DS_AUDIT, but it does not have any exposure on the clients except as the date/time modified. The first thing that you can do is to switch to Details view (choose View > Details from the menu or the standard Windows tool from the toolbar). DS_AUDIT stores the following columns...

The long answer is also no. While it's certainly possible to pass a table definition as a parameter, there's nowhere in the ODBC stage that would allow you to use the information contained therein to construct dynamic queries. The DataStage architecture model is that the statement executed by ODBC m...

Probably not, unless you are running DataStage on Windows platform.

Probably worth starting a new thread on this one. Quick answer: hashed files work best when the average record size is small (less than 10% of group size) with the smallest possible variance, and when there is maximum variability (randomness?) in key values. To determine the counts of distinct value...

Welcome aboard! :D What you're describing here is how to implement slowly changing dimensions within DataStage. You can search the Forum (this topic has been covered a number of times). The Ascential class "DataStage Best Practices" class (DS306) encompasses robust techniques for managing slowly cha...

Welcome aboard! :D The expression used a Transfomer stage is exactly that; an expression. It's not an assignment statement. Get rid of the "TXN_DATE=". The result of the expression is used to become the value of that particular column on the output link. Use the expression editor to build expression...

Does the LIBPATH set in the dsenv file also include the directory containing this library?
DataStage background processes use dsenv, rather than any .profile file, to initialize their environments.

That information has not been published by Ascential and is thus not in the public domain. The answer to your first question is that you would need to query each dependent job; job type IS one of the publicly visible fields. However, can you determine how to get the list of dependent jobs in your qu...

Yes, it's possible, but you're going to need to spend a lot more money on gateway software.

It's not possible with DataStage. One stage connects to one data source.