DSXchange

Change() in server jobs is a subset of Ereplace(). There is a parallel Ereplace() function created by DSGuru2B and posted on DSXchange. There is nothing out of the box.

Not necessarily. The Peek stage has properties that govern what will be reported.

Use the Resource Estimator tool.

I have never used RCP.

What was your response?

How the heck did you get invalid data into a Data Set in the first place?!!

These should be rejected in the job that populates the Data Set.

Then you must learn what the unknown characters are, and deal with them. Could they be 0x00 characters?

I am getting "Unknown" for the Business Glossary Browser session type, and "Web Console" for the Metadata Workbench session type. Same versions of software. Business Glossary tab on web console shows "Web Console" which is only to be expected. Perhaps you need a term in...

I think my solution would achieve that. Particularly if the final line in each file were "special" in some way.

Does ColumnName exist in the metadata for the output link?

Are you sure that RCP is not enabled?

I have no idea what U (one of our members) thinks, but nothing needs to be added. Maybe something (RCP perhaps) needs to be removed.

What stage type? Is RCP enabled?

Why not use IsNull() in the constraint expression?

Then you can properly Trim() strings on the other link, provided that the output column is VarChar. If the output column is of type Char, then the pads will be replaced after the Trim() has been applied.

Parallel routines are external to DataStage in any case, and would not be exported as far as I am aware.

What exact version of the tools? (In particular, do you have 8.1.2.1?)