DSXchange

You're wrong. Nulls can be passed to parallel routines - but the routine has to be able to handle null arguments.

Yes it could.

Only it's a hashed file, not a hash file.

Specify the "table definition" to contain one VarChar field. Please strive to maintain a professional standard of written English on DSXchange. The second person personal pronoun in English is spelled "your". Ur was a city in ancient Babylonia. The present tense of the verb "...

Did you Search DSXchange? This question has been answered on more than one occasion.

If the directory is mounted on the DataStage server it can be accessed as if it were local, provided ALLOWNFS is set in the uvconfig file (which it is by default).

If you can't find it, please post the "summary of sequence run" entry from the log.

If that's the status there IS a warning. Make sure you're not using message handlers to demote warnings or a filter that suppresses display of warnings.

Yes, that's a definite drawback. Check with your support provider if there's a patch for your particular version 7 - it may, for example, be fixed in version 7.5.3.

It seems you me that you're needing a vertical pivot and starting a new record when the sequence number resets to 1.

This is easily accomplished with a Sort stage, a Transformer stage and a Remove Duplicates stage. The technique can be found on DSXchange; search for vertical pivot.

Try setting quote character as 000 (which means there is no quote character).

Case insensitive is more costly, because an internal conversion (to all upper case, as fas as I am aware) has to be performed and the sort performed on that field.

The original error message tells you that on the input to Tr_HISTORIQUE_SOLDE_PREPAYE it is a string[8] data type.

Within that Transformer stage use StringToTime() function to convert to time, and specify "%hh:%nn:%ss" as the format string.

There is no TO_CHAR function in DataStage.

That is not the same problem.

One was a SELECT, yours is an INSERT. There are many other things to consider.

So as future searchers aren't confused please begin a new thread.

You need to improve your skills at specification. For example, the first two columns are (or appear to me to be) the pivot keys and you want only the first three non-key columns from each row to be included in a vertical pivot, with missing values replaced by empty string (or do you want null?). Do ...