DSXchange

Please confirm that this is a mainframe job. It seems unusual to me that you have a CSV file on a mainframe.

I note also that you have marked the thread as resolved. The convention on DSXchange is to make a short post indicating HOW it was resolved, the better to aid future searchers.

Does the parameter value for the directory have a terminating slash and this particular job have a slash between the parameter reference and the hashed file name?

Curiously neither of these columns was mentioned in your original question. You apparently need the RMM stage.

How is this character getting into the data in the first place? It seems to me that prevention may be better than cure, if the field is simply intended to be space padded.

8.1

Do you have an ODBC driver for Excel? If not, dump them in CSV format and process as you would your other CSV files.

2. Derivation substitution is your friend.

Select all the column derivations affected, right click and choose Derivation Substitution from the menu. The rest is intuitive for someone who lusts after regexps (if that's the correct plural).

Simple enough. That's not a query.

Not directly, but the extended form of the Trim() function can shrink multiple spaces to single space.

It's not urgent, because it will never be possible. You will need to upgrade DataStage too. We don't do "urgent". DSXchange is an all-volunteer site whose members post as and when they can. If you want urgent help, sign up with your support provider for priority service and learn the true ...

35 is not a valid day number, this is what it's telling you.

For a small enough volume of data only one segment file will be created, at least on an SMP server. I have not verified this result in a cluster or grid environment.

My reason for asking about remote data is that the variability might be in the load on database servers.

Yes, that's what the Maximum() function does.

Server 2003