DSXchange

Why not just use DIR /B *.CSV to get a list of the file names? Then convert the line terminators to commas (maybe in a User Variables activity) and make sure that no empty lines occur. I suspect that the empty value (the last line, which has no file name) is the culprit.

Sounds like the indexing may be corrupt. Search DSXchange for usage of the DS.REINDEX ALL command.

Still very ugly and messy.

Upgrade to version 8.x or even 9.1 and get a "proper" comparison tool right there in Designer.

It means you're modifying an input argument in your code. Arguments are passed to DataStage BASIC routines by reference, which means that any change wrought in the routine will also be available in the caller. If you want this to happen, tolerate the alert message. If you don't want it to happen cop...

There are two other styles of comment, that cause the comment to be incorporated into the compiled code. These are the compiler directives

• $*
  $COPYRIGHT

Again, these can be found in the DataStage BASIC manual.

This is in the DataStage BASIC manual. There are three comments; each ends at the end of the line it is on (that is, there are no block comments). A comment statement begins with one of: * ! REM and must contain at least one space character. A comment can be the final statement on a multi-statement ...

Is there any reason you're not using TAB as the field delimiter character in the Sequential File stage?

More power? (whatever that means)

So you didn't really need to send me a PM asking me to look at this.


I do not spend 24/7 logged in to DSXchange. Indeed, I probably only devote about 1 hour per day, maybe less on weekends.

What exact version of DataStage are you running? What have you tried (for example have you tried using encrypt.bat)?

Pivot stage does not ignore rows.

Unless you change the default settings, the Peek stage will capture 10 rows per node.

The fact that it's on a grid is immaterial. Counters are computed per node. Constraint expressions are evaluated per node. So, with four nodes, counter <= 50 should generate approximately 200 rows.

Count does not permit preservation of type. The result of Count is a Double (dfloat).

Re-run with same data with run ID/timestamp changed.