While running a job, you getting following error:
|
1 |
Field "NAME" has keyprep export buffer overrun 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).
Very simple procedure to generate random number in DataStage. Grab a transformer on your canvas and use following code:
|
1 |
Mod(Rand(),MAXNUMBER) |
This code will return you a pseudorandom number in the range from zero to (MAXNUMBER – 1). So for example Mod(Rand(),500) will return number from 0 to 499.
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 »