DSXchange

This is not the function of the Dependencies tab. The Dependencies tab is used so that you can record the other components on which this component depends, so that they are not left behind when promoting from development to test/QA to production. Entries on the grid on the Dependencies tab do not cr...

Complete the following in 24 words or less.

Performance is defined as ...

Then we may begin to ask pertinent questions about what it is you're trying to ask!

Hi , How to delete a hash file using DS or DSCommands ? I am temp. using hash files in a job.I want to delete those files after finishing the job. Is there any way i could do it in the same job itself ? Use an after-stage subroutine or after-job subroutine. Call the ExecDOS subroutine. In the Input...

The same list, for BASIC, is in dsinclude/JOBCONTROL.H in your project directory. The constants are set up using EQUATE (rather than #define, which is for C). To use these in your routines, include the following declarations in the top of your source code. $IFNDEF JOBCONTROL.H $INCLUDE DSINCLUDE JOB...

It is possible, but it's possibly not what you want to do. The technique is to use BASIC SQL Client Interface (BCI) functions to mimic code written to the ODBC API. You will need a licensed ODBC driver; the ones that come with DataStage are not licensed for this type of use. After establishing the t...

The first and obvious one is whether you're licensed for Parallel Extender. The easiest way to tell is when you create a new job in Designer, are you offered a choice that includes Parallel Job? The second criterion is multiple CPUs. The PX concept is to be able to throw LOTS of processing power at ...

You specified Parallel.
For the parallel canvas at 7.x there are two Transformer stage types, called the Transformer stage and the BASIC Transformer stage.
You need the latter. You'll find it in the Processing group on the Palette or in your Repository browser.

Preprocessing the file with the stream editor sed is probably the most efficient way to accomplish removal of non-printing characters. Within a BASIC Transformer stage you could take advantage of Oconv() with the "MCP" conversion specification, which converts non-printing characters to periods (for ...

Your Director may have a filter set that specifies "released jobs only". Check the filter settings (use Ctrl-T or right click in the background to get at the filter).
In Administrator check to see whether the operator role as the right to view all jobs.

The answer, as always, is "depends". You'll get only a slight gain, maybe none, if you're comparing a local Oracle instance to a (the) local UV instance. Indexing the search columns will achieve gains, of course. And if the comparison is between a remote Oracle instance and a local UV instance, 'twi...

"Unable to bind socket" usually results from the socket not having been release properly from an earlier run, or perhaps that something else is using the socket. DataStage RPC (the listener for the DataStage clients) listens on port number 31538 by default. The "Microsoft solution" (re-boot) is guar...

What were the agreement score and disagreement score on the second row? Make sure both your cutoffs are between these two values if you need to discriminate.

DataStage (and UniVerse) treat DECIMAL and NUMERIC as synonyms. They refer to a numeric data type with a fixed number of decimal places.

While you are finding out there are more efficient (and probably safer) ways to go, no-one actually answered your question. At least not directly. @USER0 through @USER4 are common variables, and I said so! Nice thing is, you don't even have to declare them. There's also @USER.RETURN.CODE, should yo...

Putting a value on the link between two Transformer stages means that it is treated as a shared variable. There is no more efficient way. The so-called "user status area" is, in fact, a column in a row in a hashed file in the Repository, so involves I/O. There are five "user" common variables called...