DSXchange

In server we don't need StringToDecimal().

Why should uvwalk be different from any other operating system command?

You can open the file's directory with OpenPath which treats the directory as a database table. You can then use ReadU to read the record in its entirety, looping through it with Remove. Using this algorithm, you CAN update individual lines. Make sure to release the update lock if you don't Write th...

Iconv() and Oconv() functions can perform multiple conversions; the list of conversion specifications is presented as a multi-valued field (that is, conversion specifications separated from each other by value marks). It's a handy shortcut sometimes. The DIGITS Transform is, under the covers, Oconv(...

Welcome aboard! :D

The technique you describe is called a "vertical pivot". If you search for this term you should get a couple of techniques from which to choose.

Read the Parallel Job Developer's Guide chapters on Modify stage - particularly the list of data type conversion functions, such as decimal_from_string or decimal_from_decimal. When you use the expression editor in the Transformer stage you are presented with a set of functions, one class of which a...

Look in the job log. The second or third entry for a job shows the environment variable settings. Check that PATH is correct.
When you find that it isn't, you will need either to correct PATH in the BAT file, or provide the full pathname of the osql command.

Pin 4 refers to the fourth (or is it fifth?) link connected to a stage. A "pin" is one end of a link. There is another "pin" at its other end. The terminology comes from links on printed circuit boards in electronics. Chances are that it is a stage variable that lacks an initial value, but where the...

Or

Copying folders won't help. You might try logging in to the server as a user with DBA privilege and granting CONNECT privilege to the user in question, doing manually what DataStage seems unable to have done. Ultimately, however, you need to have the integrity of your Engine and SQL Catalog database...

There is a little-known utility that ships in the DataStage bin folder. The utility is called uvwalk and can perform a treewalk in a directory structure, much like find does in UNIX. This might provide a more flexible solution. Get to a DOS prompt and execute uvwalk with no command line arguments; i...

dls wrote:What's wrong with using stage variables?

In your case, it seems appropriate.

Stage variables approach isn't flexible enough to handle an arbitrary number of columns.

Otherwise it's viable.

You can use a UV stage (or any other database stage) to sort your data. If the data are in a file, however, you may find it easier - and faster - to use the UNIX sort command (perhaps as a before/stage subroutine) to effect the sort. Sort by the grouping column(s). You must then inform the Aggregato...

SADD did not give you an error. Your job would have compiled correctly with SADD(x,y) in an expression. What you saw was the expression being red, which indicates that the expression editor's parser discovered a syntax problem. This is because the SADD function - which is a legal BASIC function - do...

DS_TEMPnn contains information about the relationships between objects in the design of job number nn. This information is used to construct the run-time configuration (RT_CONFIGnn) when the job is compiled.

If you delete DS_TEMPnn you will not be able to compile the job.