Phantom 2892 warning

arasan · Post by **arasan** » Tue May 09, 2006 3:11 am

I am getting this Phantom warning can any one suggest me how to get rid of it..........

DataStage Job 1095 Phantom 2892
Program "JOB.166157985.DT.1400823392.TRANS1": Line 376, Division by zero, zero returned.
Program "JOB.166157985.DT.1400823392.TRANS1": Line 377, Division by zero, zero returned.
Program "JOB.166157985.DT.1400823392.TRANS1": Line 378, Division by zero, zero returned.
Program "JOB.166157985.DT.1400823392.TRANS1": Line 379, Division by zero, zero returned.
Program "JOB.166157985.DT.1400823392.TRANS1": Line 380, Division by zero, zero returned.
Program "JOB.166157985.DT.1400823392.TRANS1": Line 381, Division by zero, zero returned.
Program "JOB.166157985.DT.1400823392.TRANS1": Line 376, Division by zero, zero returned.
Program "JOB.166157985.DT.1400823392.TRANS1": Line 377, Division by zero, zero returned.

maheshsada · Post by **maheshsada** » Tue May 09, 2006 3:17 am

Check in the transformer of your job, You are trying to divide some variable with zero, check the rows fetched by the source

ray.wurlod · Post by **ray.wurlod** » Tue May 09, 2006 5:00 am

Look in the file RT_BP1095/JOB.166157985.DT.1400823392.TRANS1 on your server around about the line numbers indicated. Identify the corresponding expressions in your Transformer stage, and add If functions to make sure that zero-valued divisors are properly handled.