DSXchange

How about you give US examples about the data you're needing to read?

Use the full pathname of the isql command or make sure that isql's parent directory is in your command search list (the PATH environment variable).

Values = the ASCII or Unicode code points. You will not read anything about bitrotate in any DataStage manual, but should find it in any decent C programming manual. Really, you don't need to know. All you need to know is that it works, and that the essence of Hash partitioning algorithm is: hashval...

Do you mean to be using as the actual command? If so, put that in.

Welcome aboard, Tony. Will check your blog when I get more time than I have in this particular airport lounge!

Perhaps you need a StringToTimestamp() function in the Transformer stage.

Welcome aboard. Runtime Column Propagation in version 8.1 is the same as it was in 8.0 and 7.5. A search of DSXchange, or of on-line help or in the manuals will answer your question.

Could be something to do with the PATH for the sql command. Could be the fact that the statement that sets this should have quotes around the command (SQL = "sql "). You might also like to investigate the BCI functions. A search of DSXchange will throw up code examples. These mimic the ODB...

Welcome aboard.

Where do you believe you should be getting microseconds from? Are there truly microseconds in source?

Unless you take steps to force it, less than 32KB of data will always go only to one node in a Data Set. 32KB is the smallest amount of data moved around by DataStage parallel engine.

... or perhaps that /tmp became full so the file could not be created in the first place.

outputcolumnname = make_null(inputcolumnname)

And, just out of curiosity, does a "where does column come from" performed within DataStage give a different result?

Try make_null() function.

How are you running this job? Try some other method, such as dsjob command, to eliminate the invocation method. If, for example, it works from dsjob but not from Director (also try with a sequence), you can at least isolate the genesis of the problem.