DSXchange

The Compare stage reports direction of difference between two inputs. To use this you'd need to generate a sequential key on two copies of the sorted Data Set (Column Generator stages) with an offset of 1 between the two copies, then compare based on matching that key.

Ernie, is there some executable in a different directory for WISD than for all other jobs, and that directory is not in the user's PATH? That's what it appears to be, but I can't think which directory it might be.

You need to specify a timestamp format string that incorporates the fractional second digits.

The largest permissible int32 (Integer) value is 2^31-1, or 2,147,483,647.

Your generated number (3,000,000,000) is larger than this, hence the error.

For small jobs server jobs are faster (finish more quickly). The startup cost of parallel jobs (even just starting the conductor process, composing the score, starting the section leader processes, distributing the score and starting the player processes - oh, and license checking) is an overhead th...

No I didn't. The asterisk is wrong. The dot was missing; I have edited my previous post to include it.

No reason. Parallel jobs do give you the future flexibility to spread your processing over multiple CPUs in multiple machines (e.g. in a cluster or grid configuration) and to be able to change the number of partitions without needing to recompile or provide different parameter values, which you woul...

In a BASIC Transformer stage only (or in a server job): If InLink.Product Matches "0X'V'1N0N0X" Then MatchField(InLink.Product, "0X'V'0N0X", 3) Else If InLink.Product Matches "0X'V-'1N0N0X" Then MatchField(InLink.Product, "0X'V-'0N0X", 3) Else ...

Have you read through all of that? Did you find an error anywhere in it? If so, what means have you tried to resolve your problem? Do you have runtime propagation (RCP) enabled?

Data Source Names for ODBC are configured in a file called .odbc.ini for DataStage on UNIX. You also need an entry for the DSN in the uvodbc.config file in the project directory. You also need to be able to resolve the TNS name, unless you are using a wired ODBC driver.

Please post the value of the environment variable LD_LIBRARY_PATH (or SHLIB_PATH or LIBPATH, depending on your UNIX variant), taken from the second event in a successful job run. Check that the parent directory of the library in quesion is in that search path.

Search the forum for a server routine called IsValid() which will allow you to verify whether each value is a valid decimal(12,2) value or not. Use this in the constraint expression in your Transformer stage.

You can load the hashed file from your Time dimension table, and create the smart key (if required) during that process. Basically, however, all you need is a two-column hashed file with the date as its key and the corresponding Time dimension surrogate key value as its other column.

For something a little more esoteric search the forum for a server routine called IsValid() which allows you to check for particular data types.

1. DSD.RUN is the command DataStage uses to run server jobs. DSD.StageRun is the command DataStage uses to execute code generated by server Transformer stages. Files in &PH& with names ending in "trace" are from stage tracing. 2. Use the find command, filter on owner name, and exec the rm co...