DSXchange

Possibly the indexing in the Repository needs re-building. Use the Cleanup button in the Administrator client, or the Re-Build Indexes option from the DS.TOOLS menu on the server.

Are you selecting "DS Routine" from the expression editor's operand menu?

Au contraire, it's extremely useful, as it includes templates for every piece of documentation (MS Word, MS Excel and MS Project) that you need. But it would have taken too long to explain all this! Get someone at Ascential to send you just the schematic (a single A3 sheet). If there's enough intere...

That's why I suggested a "BASIC Transformer" stage, not a "Transformer" stage.

Here it is!

Keep in mind that there are three quote characters available in DataStage BASIC expressions. \The title is "Alice's Restaurant."\ is a valid string constant. If you're only converting on a character-by-character basis, Convert() is a more efficient function to use than Ereplace(). To remov...

Correctly the name is all upper case (ITERATIONS). Allegedly it's the methodology used by all Ascential consultants world-wide, but I have seen no evidence of that. It is a very comprehensive methodology; the first steps, for example, seek to determine whether the enterprise is even ready to adopt D...

The end day of the previous month is the day before the first day of the current month. The latter is easy to construct. I will have to check what DateDiff functions are available in PX to do the "day before" part. If the data are coming out of a database, it's almost certain to have date manipulati...

Most activities support multiple outputs. For example, a Job Activity might have three outputs, triggered by "Run OK", "Run with Warnings" and "Otherwise". You can use Custom triggers anywhere. The Exception handler is a stand-alone component that is triggered if something goes wrong (read "aborts")...

MS Access timestamps include milliseconds, so anything you generate to perform comparisons also need milliseconds. The easiest way to do this is to concatenate ".000" to an ISO8601 timestamp.

Beware, too, of case sensitivity. "Timestamp" and "TimeStamp" are not the same thing.

There's no parameter. There IS, however, good design and good operational practice. One of these is determining the cause for the aborts (reset the job and read the log entry called "from previous run") then fixing the design so that they don't recur. Another is to limit the total number of simultan...

Any time you import an ODBC table definition DataStage "updates" - and therefore re-creates if necessary - the uvodbc.config file in the project.
There is no configurable option to suppress this behaviour.

It CAN be done; this is what is referred to by "custom UniVerse function" as a type of Routine. The Routine, in this case, is an interlude to the custom function, which may be either locally or globally catalogued.

For single-character replacement, Convert is more efficient than Ereplace. The original YMD follows the default rule, returning the shortest possible string for each component. This is where the zero from the month vanished to. Specifying [4,2,2] forces the conversion to use that many digits for eac...

Are there always exactly three characters in Field002? If so, you can use something like this. source ----> Transformer -----> SeqFile -----> Target The Transformer stage writes a single column to the SeqFile stage, of the form Key:",":Field001:",":Field002[1,1]:NL:Key:",&qu...

You could re-design, where you read the entire record as a single column, then parse out only the pieces you require.
Using this design, you can also report on erroneous input data.