DSXchange

Begin by identifying the complete set of "special characters". Then use a Convert() function to replace them with a zero-length string.

Don't refer to a file name ending in ".v" in the stage servicing the reference input link to the Lookup stage or to the links servicing the Transformer or whatever stage type "UdmPolDim" is.

Then (a) stop thinking like a server developer in your Iconv/Oconv rut, (b) explore all the date/time conversion functions that are available (Appendix A of Parallel Job Developer's Guide would be a good place to start) and (c) be prepared to experiment.

Not using ODBC! Could it be that one of your data items is larger than the allowed data type, or that you might be trying to send null to a non-nullable column? Either of these has been known to cause an access violation. Also check with your support provider that you have the exact version of the I...

"They" are working on a new version of DSXchange built with version 3 php bb software. I think that tracking your own posts can be done with a single click from the home page (not 100% on that, but I will provide feedback - the site is in beta at the moment). And the answer to your next question is ...

Looking ahead (8.1? 8.2?) more of AuditStage functionality (business rules compliance) will be merged into the Information Analyzer product.

It's a Good Thing in my opinion that there are (at least) two such robustly competitive products - neither vendor can rest on their laurels.

Beware that, by default, Char(128) is DataStage's internal representation of NULL, which may yield unexpected effects!

Good so far. How would you go about "search for next minimum date"?

In the expression where you want to use the date in YMD order you can use an Iconv() function to convert the date to the internal format required by ConvertTag().

Use same solution as Ragu.

The thread has, after all, been marked as Resolved.

Write out in English how the time slices are derived. It will give you some idea of your own rules, and assist in designing an algorithm.

Depends on how you've set the restart options in the job properties and in the individual activities.

Good catch. That was in my mind, but didn't translate to the keyboard.

If you replace "garbage" with "non-alphanumeric" you pretty much have the original question - how to remove non-alphanumeric characters from a string.

A later reply from the OP indicated that he (she?) would try what I suggested.

That the thread is marked as resolved suggests that it works.