DSXchange

No. (I assume you mean "simultaneously".) The operating system imposes a limit of 1 on the number of writers to a file, and the data in Data Sets are stored in operating system files on the resource disk(s).

i set it all..... its not working..... actually i d/l visual c++ and sdk later...... i set the values but it ddnt work wat to do...... Please strive for a professional standard of written English on DSXchange, to make life easier for those whose first language is not English. There is no need at al...

For the environment variables copy the relevant lines from DSParams from one project to the other (remembering that there are two sections for environment variables - definitions and default values). I'm not sure where the Parallel options are stored in a version 7 project, and don't have one in whi...

Performance wise Inline sort is best compare to explicit sort stages. I disagree 100%. But I'd be interested to hear your reasons. Two reasons an explicit Sort stage is better (and can be better for performance): you can control the amount of memory allocated you can generate key change indicators

Since the Data Set stage does not support a Schema File property, my immediate thought is that the answer is no.

U need to use sequencer looping activities U (one of our posters) did not ask the question. The first person personal pronoun in English is spelled "you", not "u". Please strive for a professional standard of written English on DSXchange, to aid those whose first language is not...

You don't build expressions in a Switch stage - you supply values of the discriminating column. Values only.

There are tunable limits on how much memory is used for virtual Data Sets and for buffers. (It will come as no surprise that they are tuned by setting environment variable values.) When this memory is reached, then DataStage uses scratchdisk.

That's what I would suggest too. Constrain the outputs based on the value in column #3.

Slowly Changing Dimension stage performs this functionality (and more).

What about after you're restored an old version of XMETA ?

The tutorial that ships with the product is a start point, taking IBM or other vendors' training classes is probably beneficial too. As your confidence develops, download the Red Book on DataStage (from IBM website, for free).

DSXchange is not a substitute for training, for reading the manuals or for consulting on-line help. We're happy to address specific questions, but not happy to answer general questions like this one, the answer to which is basically a paraphrase of what's in the manuals. The 92 and 93 are cutoff po...

Create another field containing the initial and match on that as CHAR.

Use a Sequential File stage with metadata for the detail rows. Set up a reject link, which will capture the header and trailer rows. Downstream on the reject link use Column Import stages to re-parse these rows.