Warning while running Validate and Load job

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
sujaoschin
Premium Member
Premium Member
Posts: 102
Joined: Tue Jan 31, 2006 4:13 am

Warning while running Validate and Load job

Post by sujaoschin »

I am getting the below warning when running my validate and load job. How to avoid this below warning?

BISEPS_MODULEITEMS_ASSET_LOAD..od_ASSET: This update action 'insert or update' is not compatible with parameter array binding. Array Size property will be set to 1.
Sujatha K
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Don't try to use array binding with mixed update and insert statements. Set array size to 1.
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 don't use the 'combo' actions. Split your input stream into discrete insert and update actions.
-craig

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