DSXchange

You will need to change the data type to Varchar. DataStage will always add leading and trailing nonsignificant zeroes to Decimal data type when writing to text file or displaying through data browser. This proves that precision and scale are being handled properly.

Don't do those products except as a contractor to IBM. Have not developed my own curriculum for these.

Also kinda booked out through October 2010.

You should have had compile error. DSLogInfo() within the WriteSeq statement requires two arguments. You supply only one. Also, you do not check (using FileInfo()) that the call to OpenSequentialFile() succeeds.

When the volume is huge ANYTHING will be time consuming.

The only way you can influence the status code returned by a DataStage job is to write it:

• so that it generates no warnings or errors (returns 1)
  
  so that it generates warnings but no fatal errors (returns 2)
  
  so that it generates at least one fatal error (returns 3)

What do you want to do if your regular expression matches more than one file name?

Not all Data Direct drivers are bundled with DataStage - you can purchase others from Data Direct.

You learn about APT_PERFORMANCE_DATA in IBM training - in the advanced class if I recall correctly.

You learn about APT_PERFORMANCE_DATA in IBM training - in the advanced class if I recall correctly.

Bread in a suppository configuration?

You go back to your support provider/vendor and get them to do what you're paying them to do.

which a Search would quickly have revealed.

I can't recall ever seeing that information in Manager. Certainly not for QualityStage jobs.

It would appear, from the install log, that the fix pack was not applied successfully.

Have you tested SF.com with something else? Maybe it simply does not deliver the information you want.