Warning 0 row updated

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
aoriano
Participant
Posts: 15
Joined: Fri Apr 25, 2008 8:00 am

Warning 0 row updated

Post by aoriano »

Hi, I use DataStage Server 7.5.

I use "Shared Container" with parameters such as the database table. The job is supposed to update some rows of the table but sometimes it updates 0 row.

I don't want to use a "Look Up" to know if the row i want to update exists in the table because of the performances.

So i would like to know if it's possible to disable the warning when the update query updates 0 row.
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Re: Warning 0 row updated

Post by chulett »

aoriano wrote:I don't want to use a "Look Up" to know if the row i want to update exists in the table because of the performances.
:? That's what hashed files exist for. They are the heart and soul of the Server product. Done properly, there's no performance penalty.
aoriano also wrote:So i would like to know if it's possible to disable the warning when the update query updates 0 row.
Sure, with a hashed file to prequalify the operation. :wink:

Are we talking DB2 here?
-craig

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

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”