DSXchange

No. There is only encryption.

But you could write your own.

On your client machine. The actual location depends on where Information Server client was installed (default is C:\IBM). You should be able to find it searching from there.

Specifications in the Modify stage can be fully parameterized.

However, the Modify stage has only a subset of the Transformer stage in terms of transformations; in particular it can only (in general) effect transformations that have a single input field.

Many years ago I created a DataStage routine to reverse-engineer DDL from a DataStage table definition. So it's definitely do-able. Alas, I have long since lost the code. (It also generated IFX format.)

What have you tried?

We are not here to solve your requirements - that would be consulting, and that's how some of us earn a living.

We are here to help you to resolve any problems, but expect you to have made some kind of attempt first.

All global variables are string. Use the val() function to convert to numeric value to use in comparisons. I have used this extensively to create Data Rule Definitions that compute and verify check digits.

Don't push. If someone can help you, they will. DSXchange is an all-volunteer site whose members post when they can, and in any case are not compelled to do so, nor to meet arbitrary timelines. If you need urgent help sign up with with your official support provider for premium service, and learn ju...

As a general rule, a DataStage Connector will be silent about a successful commit. It may be possible to use Before-SQL to set a state that causes the database to report successful commits.

Eliminate your Final Delimiter property and set the Record Delimiter String property (which is different from the Record Delimiter property) to "DOS style". Let us know whether that works.

What do you mean by "faster"?

Do not believe anything expressed as rows/sec. Search DSXchange for reasons.

Is TZ being set for your project/environment?

Bonne chance!

Each values file allows you to specify a different set of default values for the parameters in the Parameter Set.

Typically the symbols preceded with "\\\\" are the structure of the repository; they represent folders in the local DataStage repository, control records, class type records, and so on. I would imagine (guess) that an export excluding read-only components would not include these (unless th...

Might the table be getting new rows from sources other than DataStage, and not updating the Oracle sequence?

You can probably retrieve the system's timezone from the TZ environment variable.