DSXchange

for the month number. Store that in stage variable svMonthNumber. will yield that number with a leading zero if necessary.

If you know, or can obtain, metadata about the layout of an IXF file then DataStage can read it.

If you are reading using File Pattern then the Sequential File stage can generate file name into another output column that you define. The number of records can be had by counting a constant (even the file name)using an Aggregator stage grouping by file name. You can detect mismatch using a Transfo...

Aggregator stage to calculate MAX.

Sort then use Remove Duplicates stage. For example, if sort is ascending, have Remove Duplicates pass only the last record in each group.

How are you reading the files with DataStage?

I believe that Parameter1 refers to one of the arguments of the ODBC API function SQLSetConnectOption(). This is used, among other things, to establish the operating system credentials for the connection. Find out more about this function in ODBC API documentation or UniVerse BCI documentation.

IsNull() function, IsNotNull() function, NullToValue() function, to name just three.

svarChanged <== IF svarLastFieldB = In.FieldB THEN 0 ELSE 1
svarLastFieldB <== In.FieldB
svarCounter <== IF svarChanged THEN 1 ELSE svarCounter + 1

How often do you need to check for uncompiled jobs?

There's only one way they can become uncompiled, and there's always a person present when that happens.

This would be a valid result if each combination of the first eight columns in the source hashed file had only a single row associated with it.

You can check whether this is the case using an appropriate query, probaby with HAVING COUNT(*) > 1 as one of its clauses.

It's only enabled if the Hashed File stage is the source for a stream link - not for a reference link.

And, as noted, it must be a hashed file (note - it's hashed, not hash) for which a VOC entry exists and the stage must refer to it through that VOC entry.

It is ok to do the fix while jobs are running - DS_JOBOBJECTS contains only design-time information.

Do, however, heed the advice to back up the file before "fixing" it - the "fix" can in some circumstances truncate portions of the hashed file.

Even easier is this approach. Use the Multiple Job Compile tool and check the "select only uncompiled jobs" check box.

One of the Webinars earlier this year discussed Job Sequences, in particular processing multiple files with them.