DSXchange

There is no "Raise Error" in DataStage BASIC expressions. You do not appear to have a complete set of matching Else clauses. Every If must have a Then and an Else when used in an expression. Can you re-post your code, single spaced and properly indented, surrounded by Code tags to preserve the inden...

You can pass any valid UNIX command string via the Input Values field. This includes pipelines, redirection, and so on. To invoke ExecSH from job control is possible but inefficient, and you would need to create a wrapper function to invoke it. You should prefer to use an Execute Command activity, w...

How strong do you need to encryption to be? Does it ever need to be decrypted? You can do the encryption in DataStage BASIC, but would only ever be able to decrypt using a reciprocal function. For strong encryption, DataStage BASIC is not recommended.

There's a check box in the Transformer stage in the input link properties for enabling multi-row return. It only appears if there is an ODBC or UV stage connected to the reference input link.

Convert() is more efficient than either Ereplace() or Change(). If you had NLS enabled, then the regional settings (locale) would have automatically managed the decimal place character. You could also have used Fmt() with a literal replacement for the decimal place character. Do you also need a non-...

I seriously doubt that you will receive any, because a unit test tests the unit of "code" under test. It is thus specific to that unit of "code" (or of DataStage design in this case).

Any time SQL Server generates an informational message, DataStage logs it as a warning, because it regards receiving messages from the database or ODBC driver as "unusual". Unfortunately you can not change this behaviour in DataStage. Is there an environment variable you can set so that SQL Server d...

Under the covers there is no way to read a file other than a byte at a time.

I am having datastage 7.5 installed and when I open a new desingner window i get a list to choose from. I have parallel jobs also in this list. Is this parallel job same as Datastage PX. When Ascential acquired Torrent Systems for their "Orchestrate" parallel execution technology, they named this c...

are there any other ways to obtain this information or approach this problem (which i am sure is pretty common)? Open a Director client in Status view (usually the default). Set the refresh interval to your snapshot interval (maybe 900 seconds). In the View menu choose "disable categories". Click i...

Instead of double click on the row number in the Columns grid you can also right click on the row, and choose Edit Row from the pop-up menu to get to the dialog.

You can also triple-click (!) on the row using the left mouse button, but you have to get the timing of a triple-click just right.

The PDF is in the Docs sub-folder under Version Control on the DataStage clients CD. You can move it to the same location as your other docs if you choose to install Version Control on a particular client machine.

"Compiled again" is not always an option in production environments.

Use a shell script or master job sequence to determine the current status, reset if required, then run in normal mode.

What do you mean by "lookup data set"? A Lookup File Set includes its own index. A virtual Data Set does not. However, if you look at the record schema you will note that there are four control columns, including partition number, partition count, and row number; these could be used for a "binary ch...

Looks like it might be a bug. What does your support provider have to say?