DSXchange

Can you please do a listing of everything in the directory that begins with DS_ or D_ ?

You must also copy D_DSG_BP.O and D_DSD_BP.O if they're not already there. (I should have mentioned this earlier.)

Please post the resolution (to aid future searchers) and mark the thread as Resolved.
(I'd be inclined to use cat and maybe pipe the output through tr to strip off the line terminators.)

No, you just do it in the Designer GUI - no need for coding. Use on-line help to guide you.

So "Able to develop conversions and transformation data using an ETL Teamworker" means "able to delegate"?

NChar and NVarChar data types typically allocate two bytes per character.

Data Set is perfect to use as a staging area, for it preserves partitioning and sorting and does not require export/import operators.

There is no limit imposed by DataStage. The rest is an issue of supply and demand for system resources - CPU, memory, I/O bandwidth and, perhaps, network bandwidth.

I'd guess either the 2GB limit, or the occurrence of a mark character other than @TM in the key value.

It's probably not the files but the indexing.
Get exclusive access to the project and execute DS.REINDEX ALL

By not doing it in the same job, as originally advised.

You may need to copy DSD_BP.O as well. This is a SEVERELY corrupted project!

I (we) have no authority to speak on behalf of IBM. Perhaps you should ask IBM, and post the answer here?

Enterprise Edition

How would you do it usng Sybase Open Client - that is if DataStage were not in the picture?