DSXchange

When the result of the (correct) VLIST command is posted, then we'll be able to offer more cogent advice.

Generating the key value in the second row of each pair is straightforward also. Extract the first field from the entre record and add 1 to it.

Then clearly you must demand that Microsoft and IBM get their act together so that you can!

You could hard-code the required names in the Routine activity and create a routine that accepted them as arguments.

I am beginning to see this more frequently. It used to be as narashima suggests only when surfing away from the site - even when following a link - but now it's in the middle of working through the postings. From here it is many hops to the server, so I thought it may have been my network. Now I'm l...

What is the data type of this field and of all preceding fields in the record schema? Can you post the schema?

You must have a compatible C++ compiler to compile jobs containing Transformer and Build stages.

Do you have a C++ compiler?

None installs with DataStage - you must provide it yourself.

The convention here is to mark the thread as resolved.

And there's no need to thank "u" - whoever "u" is did not contribute to the answers.

Char(10) (called string[10] in the record schema) is fully supported in Data Sets. But you must provide exactly 10 characters to store in one.

We need to know the precise error message if we are to help you to resolve your issue.

Now, now, you're going start a war here. Not everyone has a religious belief that involves a single god, or even a religious belief at all.

Though I've heard it claimed that atheism is the strongest form of faith.

Please delete the duplicate post.

How do you propose to manage all these files in a parallel execution environment, were you have no direct control over which row is processed on which node (because someone might run the job under a different configuration)?

Why incredible? If the syntax exists (much like inserting rows into a SQL Server (Plato edition) cube), why shouldn't an ETL tool be able to take advantage of that?

Yes, I meant in the first Transformer stage. And it's perfectly OK that this stage does "other stuff". All my suggestion adds is an additional condition on the output constraint expression - it does not affect anything else you are doing with this Transformer stage.

Change Apply stage can rebuild the original data set from the result of a Change Capture stage.