DSXchange

It is covered in the DataStage BASIC manual, it is covered in the on-line help for the Convert() function. In both cases it states that "expression1 specifies a list of characters to be converted." where expression1 is the first argument to the Convert() function.

I'd use the MONTH.FIRST Transform. Why re-invent the wheel?

In your Hashed File stage, click the Options button and select the "delete before create" check box. This will handle the possibility that the hashed file already exists. Check carefully that the value being supplied by the parameter (and reported in the error message) is totally correct, even unto ...

"Fatal" errors do not necessarily cause parallel jobs to abort.

In this wise parallel jobs behave differently from server jobs.

"//////" is not a legal name for a hashed file.

Exactly.

You can prove, from DS_AUDIT, that it was deleted successfully. This is, if you will, an automatically committed transaction: the job has gone.

Do you have a backup - ideally an export of the project?

An implicit conversion will occur, but you will need to use something like a Left() function because the target string is shorter than the source string; otherwise you will get "potential truncation" alerts.

What has changed on your system between when it ran OK and now when it doesn't run?

What is the environment variable that isn't loaded?

Search the forum for "libgciudt6.so".

Implicit conversions you don't need to do anything. Where you need explicit conversions you can find the function name in the Chapter on the Modify stage or the Chapter on the Transformer stage, depending on which stage type you're using. I note that you have a sig with "urgent" in it. We don't do "...

Define "performance" in this context.

You should be making sure that your data types and nullability are all correct, and using the appropriate functions for type conversion (where required) and null conversion (where required).

Don't you have manuals or on-line help?

Of course they do. They're doing the same processing.

What's a "performance compact"?

The number of rows that passed along the link. Each time a lookup succeeds - irrespective of the number of rows in the reference data set - this counter increments.

Why do you think the delimiter should be "/"? That doesn't really make sense - you'd be parsing partway through the end tags.

Try using 000 (for no delimiter between fields).

Though I really believe that you need to import the XML table definition to make any sense of this file.