DSXchange

Check the stored procedure itself. Has it been programmed with an infinite loop?

We don't know what you're trying to do, and therefore can not challenge your assertion about RCP. I recently have had good success generating SQL dynamically based on reading metadata from the system tables and passing the SQL statements as job parameters. But this used RCP. Even if you use the Sche...

You can prove the location of the bottleneck by writing to a Sequential File rather than Oracle. If that's no faster, the problem is in DataStage. If it is markedly faster, then the problem is in Oracle. Updating tables where the columns mentioned in the WHERE clause are not indexed is notoriously s...

There are four great examples in the Parallel Job Developer's Guide for version 8.5.

Stop pushing!!! You waited one hour (which was the hour between 2am and 3am my time) before demanding a reply. If it's that urgent or important, BUY some support.

Use Copy stage if the conversion can be done implicitly, or any stage that supports input to output mapping (again if the conversion can be done implicitly).

It may, of course, be a VARCHAR2 column for which you don't have sufficient length allocated. Apart from explicit Len() tests, I can't think of any way to validate data. Maybe some direct queries (outside of DataStage maybe) to check lengths?

tanaya.deshpande@tieto.co wrote:What I know is RCP is only for sequential file stage ,Fileset ..and external target and source..

RCP is available for almost every stage type.

How big (in bytes) are your rows?

Is the product of array size and row size too large to fit in memory?

There's also a couple of examples (e.g. DSSendMailTester) supplied with the product.

There's a few examples to be found if you Search DSXchange.

Add them to your design, using Transformer or Column Generator stage, as already mentioned.

VOMITAMUS

Yes, and I included it in my response.

You may need to "escape" the single-quote characters.