DSXchange

Are you using unbounded VarChar data types (where no maximum length is specified)? Are you using bounded VarChar data types (where a maximum length is specified)?

Cross table analysis has to compare each column in one table with every column in the other table, and every pair of columns in one table with every pair in the other, and maybe more depending on how you've specified the task. So it's a lot of work. The only way you could reduce the time is to remov...

No, because I don't know the exact solution. It may, for example, depend on how SAP BW is configured at your site. Wait for someone who does to post it. Meanwhile search for what others have done when this timeout error has occurred. And involve your support provider - that's what you're paying them...

Are you sure that you didn't remove the ^J characters when you removed the ^M characters?

Try working with the original file, and using a Record Terminator String property rather than a Record Terminator property.

What specific null handling are you doing? Is there any field where you may have missed handling nulls?

In an after-job subroutine use DataStage API functions such as DSGetLogSummary(), DSGetNewestLogId() and DSGetLogEntry().

cc_holder_nm is definitely short. Get better data.

Please delete your duplicate post on this topic

Try Search - this question has been asked in the past.

Welcome aboard.

This message usually indicates that you have licensed only DataStage, not QualityStage.

Try changing the action to Insert or Update (so Insert is attempted first).
What difference does that make?

Then try changing the array size to 100. Do not change rows/transaction.
What difference does that make?

Only change one thing at a time.
What is the average size of the data in a row?

Try Search - there have been several solutions posted on DSXchange to this particular question.

If you are using DataStage EE MVS edition (that is, jobs that run on the mainframe) then JCL for running the job is generated by DataStage, and you should be able to invoke that from any COBOL program. Since you can view the COBOL that DataStage generates, you could also edit that and convert it int...

What is the data type of the lookup (reference) key? Are you certain that you trimmed trailing space when loading the hashed file and when you form the reference key value?

Procedural Note We don't do "urgent" here. If you want urgent support, sign up with your support provider for premium support, and learn the true cost of urgent. This is an all-volunteer site; people post as and when they can, and are not paid for doing so. Personal Note Anyone marking a post as ur...

Very well, if the default behaviour is not what you require, specify the Quote character at the individual field level - right click on the row in the Columns grid choose Edit Row, and adjust the individual quote characters there.