length of where clause in filter stage

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
harryhome
Participant
Posts: 112
Joined: Wed Oct 18, 2006 7:10 am

length of where clause in filter stage

Post by harryhome »

APT_CombinedOperatorController,0: <>: Error message (253898) exceeds the maximum message size (131056); dropping.

Getting above error, is there any way to increase the field length of where clause in filter stage
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

None of which I'm aware.
Any chance of using shorter column names to get under the 128KB limit?
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 »

Or perhaps simplify it? Or worst case do it in multiple stages / steps - a "pre" filter to cut the rows down and then a "final" filter to weed out the rest? If possible. Depends on what is making it so long, of course. :?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply