DSXchange

Thanks for all you reply. The real issue is, i have more than 100 columns and need to process around 10 million records and the problem here is i need to check nvl condition for all the columns. one more issue is except key columns i need to concatenate all the other columns into one single column ...

If RT_CONFIG1219 can not be opened, reindexing will have no benefit at all, because there are no indexes on the configuration files. Probably the best thing to do is to make a copy of the job, compile and run that (then delete the old version of the job that has a corrupted configuration file).

srinagesh wrote:is that a work around for all expired licences

Please qualify "all". For example, I don't know how SAP licensing works.

Is that user a member of the Administrators group?

It's all documented in the DataStage Plug-In Writer's Guide , which should be available for the asking from the vendor. To create the stage itself you need to be a very competent C programmer while to create a GUI for it you need C++ skills. In my experience there ought almost never be a need to cre...

Install the 7.5 client in a different location on the PC. Use MCM (Multi Client Manager - the newer name for Client Switcher) to switch between clients. You can only have one active at a time.

Take a look using the Data Set Management utility in Manager to see how much of each segment in each partition is actually in use. Then ask the vendor how come the files are so large.

Is there another format that can handle this issue?
Only the precise format specified will satisfy the function. Otherwise, as Arnd states, you must reformat to the requisite format.

If they are, they're likely to occur in the tagged subrecord stage types. In addition you can create your own stages that invoke any operator - read the chapter on Custom stages in Advanced Parallel Job Developer's Guide

DataStage 7.5 is (remains) a 32-bit application. There are lots of goodies in 7.5, especially in job sequences, that it's definitely worth having.
As for performance, that depends on your definition of performance.

Does this happen during design, during compilation or when the job is run?

Set this environment variable in the Administrator client, project properties. This is a very fundamental question; perhaps you could also enrol on the DataStage Essentials (Enterprise Edition) class.

There is a system error within DB2. All DataStage can do is to repeat the generated error message. Therefore all we - DataStage developers - can do is suggest that you ask your DB2 DBA nicely to take a look at the logs and let you know what the problem is. Hopefully what the problem was - the DBA sh...

Aha, that's what you got with View Data. Add more column definitions - even to the metadata in the Columns grid, and look again! That is, the Hashed File stage has the ability to populate undefined columns, in exactly the same way that the Repository database tables contain undefined columns that ar...

DataStage is not a report-writer.

Please don't ask for urgent help here - it causes offence. We are an all-volunteer site, who post (unpaid) when we can.

If you want urgent support, sign up for premium support from your service provider, and discover the true cost of "urgent".