Warning message limit

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
mail2krishna79
Charter Member
Charter Member
Posts: 56
Joined: Fri Apr 21, 2006 9:53 am

Warning message limit

Post by mail2krishna79 »

Hi,
sometimes i am getting warning messages a lot(same warning message).
For example.
APT_CombinedOperatorController(0),0: Null string argument.

Above warning message repeating multiple times.
Is there any technique to limit 2 or 3 warning messages?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Sure. Limit the number of null string arguments.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

In other words, treat the disease and not the symptom.
-craig

"You can never have too many knives" -- Logan Nine Fingers
chandra.shekhar@tcs.com
Premium Member
Premium Member
Posts: 353
Joined: Mon Jan 17, 2011 5:03 am
Location: Mumbai, India

Post by chandra.shekhar@tcs.com »

you have not handled for the columns for which you are getting null from the source. Try one of these solutions:
1. Use IsNull() or IsNotNull where ever required in Transformer.
2. Also if your target is a seq file then Use Null field value constraint and make equal to ''. thats it
3. If you just want to limit the number of warnings then you can add a message handler constraint inthe Director as well.
Thanx and Regards,
ETL User
Post Reply