470,849 Members | 1,314 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,849 developers. It's quick & easy.

handling DB2 warnings


Hi,

This is a very general problem which iam sure application programmers
all over have faced.
How does one handle the warnings that DB2 issues ? Should they be
ignored or treated the same as errors (i.e. as failures).
Is there anything recommended by DB2 itself ?
As you well know it becomes very cumbersome when we start handling
specific warnings.

Appreciate your inputs.

Oct 5 '06 #1
1 1538
Vivek wrote:
Hi,

This is a very general problem which iam sure application programmers
all over have faced.
How does one handle the warnings that DB2 issues ? Should they be
ignored or treated the same as errors (i.e. as failures).
Is there anything recommended by DB2 itself ?
As you well know it becomes very cumbersome when we start handling
specific warnings.

Appreciate your inputs.
The most important warning is for +100 which is "row not found" or
"end of cursor on fetch", etc. In most cases, you need to handle
this in your application logic and act accordingly.

There are also warnings for arithmetic overflow, which probably only
need to be handled n certain situations where calculations are done in
the SQL, or when the columns/host variables are different sizes.

Most people ignore all other warnings.

Oct 5 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Pete Forman | last post: by
1 post views Thread by Dan Williams | last post: by
3 posts views Thread by Alberto Giménez | last post: by
2 posts views Thread by Sergei Shelukhin | last post: by
2 posts views Thread by erbrose | last post: by
16 posts views Thread by john6630 | last post: by
5 posts views Thread by kellygreer1 | last post: by
5 posts views Thread by Conrad Lender | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.