Tag Archives: lookup

Datastage error: Field “NAME” has keyprep export buffer overrun error

While running a job, you getting following error:

This error happens during processing data in Lookup stage and  the solution of this error is very simple. Check the key attributes in the lookup stage and ensure that all attributes have same type and length (check the extended parameter too).

How to cleanup old Datasets in DataStage automatically

This is a procedure useful not only for DataStage environment. Often you need to delete old logs periodically in order to save disk space. But especially in DataStage, which lacks automatic datasets cleanup is handy to delete old datasets. These may originate from your DataStage Dataset stages, or as a temporary resource from Lookup stage… Read More »