DSXchange

Can dsstage login using the Administrator client?

That doesn't affect my earlier answer.

OK, this incompatibility is at the heart of the problem. Something from the old system has nothing where (now) expected in one of the NLS fields. Given that it's bypassed by the administrative user, I'd suggest that it's something project-specific. Either add dsstage to the DataStage and QualityStag...

Really you have again neglected to provide us with sufficient information. There may or may not be a mechanism for solving this problem. It really depends whether there is some way in the source data for identifying the delta. For example if the source has an auto-incrementing key you can store the ...

Was the system installed without NLS enabled, and any imported job exported from a system with NLS enabled? Or, perhaps, is NLS installed but not enabled?

There's something wrong with the INSERT statement, which is why the INITIATE method failed.

Paul is correct. Overstating the array size will not abort the job; lacking other errors it will finish successfully, though less efficiently. The issue is buffering within Teradata (which is why increasing the default buffer size there is an option).

Perhaps it's csh that can't be found, and you need to provide the full pathname of its executable because its parent directory is not in the command search list ($PATH) of the user under whose identity the job runs.

Firstly, HOW did you try to uninstall? And are all four tiers on the same machine?

You could also increase the default buffer size in Teradata. Beware, however, if you're using multiple sessions, that they share the buffer. So

Welcome aboard. What you say is true, but unnecessary. Consider a record with seven fields, each of which has four characters. AAAABBBBCCCCDDDDEEEEFFFFGGGG And let's call them FieldA, FieldB, ..., FieldG Now it doesn't matter what level any of these fields is at (provided it's not level 01, which is...

OK, I'm not on site till Monday, but you're basically looking for those records in DS_JOBOBJECTS that have an OLETYPE that indicates that they are output links from Transformer stage. Without access to DataStage I can't tell you which field in the record contains the column names and which contains ...

One must assume that EBCIDC is a typo for EBCDIC.

TRUNCATE TablenameA perhaps? This should be non-transactional.

Do you have DB2 Connect installed on the DataStage engine? This is the software needed to connect to DB2 on different platforms.