DSXchange

Specifically, Chapter 2 of the Parallel Job Developer's Guide

There are several restrictions on what you can do within the server shared container - read all about them in the manual.

I thought it was talking about those fruits that originate in the Middle East.

Parallel jobs reserve filename suffixes ".v", ".ds" and ".fs" for virtual Data Set control files, persistent Data Set control files, and File Set and Lookup File Set control files respectively. It throws this exception if you try to use these suffixes in an inappropriate location or in an inappropri...

Yes.

Semi-colon DOES work in DOS. So do most of the pipeline operators, such as &&, !!, >, |, and so on.

For example: dsjob -run -wait -param ParamName=Value1 Myproject Myjob.1 dsjob -run -wait -param ParamName=Value2 Myproject Myjob.2 dsjob -run -wait -param ParamName=Value3 Myproject Myjob.3 dsjob -run -wait -param ParamName=Value4 Myproject Myjob.4 dsjob -run -wait -param ParamName=Value5 Myproject ...

Status is a reserved word (it's both the name of a statement and the name of a function).

It's not good practice to use reserved words as variable or parameter names, in case they change the compiler to enforce the reservedness of these words. It's happened in other languages.

Try making a copy of SouthBreeze and adding primary keys. Then try an import from that. I would guess that ProfileStage should be able to import table definitions that lack primary keys, though lacking them will severely hinder some of the later analyses, especially table and cross-table analyses, s...

It's unique to Oracle.

Unfortunately copy/paste of job activities wipes out the parameter expressions in version 7.5. It used to keep them up to version 7.1.

The next class begins March 26, 2007.

Version 8.0 has a neat mechanism called a "parameter set" - you can define a block of related parameters and move them all together (subsequently editing the individual parameters if desired).

Are you sure the bottleneck is in the Transformer stage, or is this simply a convenient scapegoat? What throughput do you get if you replace the Oracle stage with a Peek stage? What does that reveal to you? What settings are you using in your Oracle stage? What are the settings of the two environmen...

A requirement of the File Pattern value is that all files share the same structure. Unless you're reading them as a single VarChar column, it appears that this is not the case in your situation.

Get your DBA to perform a raw export of some of the rows from this table so you can see precisely what's stored in them. Create another DataStage job that selects from the table and writes to a text file. This will help you to establish whether storage is correct and the fault is in the viewer(s), o...