How to avoid warnings?
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 196
- Joined: Tue Nov 23, 2004 11:50 pm
- Location: Sydney (Australia)
How to avoid warnings?
Hi,
One of my jobs updates the oracle table with input data. Job is running successfully but whenever it is not finding a match it is giving warning also. Can we not avoid these kind of warnings?
Regards,
Nripendra
One of my jobs updates the oracle table with input data. Job is running successfully but whenever it is not finding a match it is giving warning also. Can we not avoid these kind of warnings?
Regards,
Nripendra
Nripendra,
as you rightly wish to do, the warnings you are getting should be removed. In order to do so you will have to tell us what the warnings are and in which stage they are occurring.
as you rightly wish to do, the warnings you are getting should be removed. In order to do so you will have to tell us what the warnings are and in which stage they are occurring.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Premium Member
- Posts: 196
- Joined: Tue Nov 23, 2004 11:50 pm
- Location: Sydney (Australia)
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Premium Member
- Posts: 196
- Joined: Tue Nov 23, 2004 11:50 pm
- Location: Sydney (Australia)
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Premium Member
- Posts: 196
- Joined: Tue Nov 23, 2004 11:50 pm
- Location: Sydney (Australia)
Hi,
you managed to confuse me wih your last post Nripendra Chand,
If you use insert or update then there is no way you'll get this message (if it isyourload method)
in case you use only update you can, as mentioned, prepare or perform a lookup verifying the record exists and only then update it (use constraint to filter rows for update not in the table you try to update).
this way no warning will pop up.
IHTH,
you managed to confuse me wih your last post Nripendra Chand,
If you use insert or update then there is no way you'll get this message (if it isyourload method)
in case you use only update you can, as mentioned, prepare or perform a lookup verifying the record exists and only then update it (use constraint to filter rows for update not in the table you try to update).
this way no warning will pop up.
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Obviously, hence the little winky guy.
However, I have encountered people that don't care if an update doesn't actually update anything. If you consider it a failure, as previously noted several times, you need to create a reference hash and do a lookup check ahead of time, validating your inserts and your updates before actually shipping them off to the database.
However, I have encountered people that don't care if an update doesn't actually update anything. If you consider it a failure, as previously noted several times, you need to create a reference hash and do a lookup check ahead of time, validating your inserts and your updates before actually shipping them off to the database.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom