DSXchange

Help yourself, with Search - the question has been comprehensively answered previously.

The short answer is 0.5.

What are the input and output columns' data types? This matters in parallel jobs - it does not matter in server jobs. In a parallel job you probably need to convert to string then insert the thousands separators explicitly. A custom routine or a Build stage will provide a generic solution; if your n...

string_trim() has further options. You can find these in the chapter on the modify operator in the Orchestrate Operators manual.

Did you use the Expression Editor to insert the job parameter reference into the expression?

Is your integer of the form 57700505 ? If so, all you need to do is to insert the delimiters. InLink.TheInteger[1,4] : "/" : InLink.TheInteger[5,2] : "/" : InLink.TheInteger[7,2] or Fmt(InLink.TheInteger,"####/##/##") Make sure, too, that Sybase expects dates in...

The schema name is the same as the project name, but is not necessary if you are in the project "account". So, when you choose the project in the Administrator client before opening the Command window, the schema is automatically selected. Therefore, SELECT * FROM RT_LOG10; (with the terminating sem...

The Slowly Changing Dimesion stage does all that for you, except that you don't need to use a flat file. It loads an image of the Dimension table into a virtual Data Set (similar to a Lookup File Set, but without the need to import anything into internal format). It's used like this: DimTable | | V ...

Odd. I got 16 hits searching for "dynamic lookup". The Slowly Changing Dimension stage has the equivalent of Informatica's dynamic lookup built into it, though it performs the lookups against an in-memory copy of the (dimension) table. There are other techniques, and others pertintent to server jobs...

The Parallel Job Developer's Guide incorrectly gives the Transformer Stage function rather than the Modify stage function. The Modify stage function is

You're not really on version 5 are you?!

Having "captured" the parameters (or at least their values) what do you wish to do with them?

Are you actually connecting as dsadm or as a member of the dstage group?

Is the file system full?

Is the DS_STAGETYPES hashed file corrupted (check with UVFIXFILE)?

1. Basically that you are detected as running tracing.

2. Trace mode is a sum of powers of 2 based on the check boxes selected when enabling trace mode. You have selected them all.

Welcome aboard.

The answer is to be found via Search - it has been asked and answered previously.

And it won't be a UniVerse query. UniVerse ceased being the DataStage engine in version 5.2.