[z/OS DB2v8] SQLCODE 802

Sam Baugh

[z/OS DB2v8] SQLCODE 802
Just curious if there was a change in SQLCODE returned for "zero divide"
exception between DB2v7 and DB2v8. An application failed with an +802
error and supposedly it did not fail because of this before. We have
migrated all our systems to DB2v8, so I can't verify this. Would
someone still on DB2v7 let me know what return code you get with the
following SQL? Thanks! SELECT 10.0 / 0 FROM SYSIBM.SYSDUMMY1



Sam Baugh

Motion Industies






-----------------------------------------
The information in this communication, including any attachments,
is intended only for the person or entity to which it is addressed
and may contain confidential, proprietary, and/or privileged
material. Any review, retransmission, dissemination or other use
of, or taking of any action in reliance upon, this information by
persons or entities other than the intended recipient is
prohibited. If you received this in error, please contact the
sender and delete the material from all computers.


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

William Shipley

Re: [z/OS DB2v8] SQLCODE 802
(in response to Pradeep Gunjala)

Sam, I ran your select in DB2v7 and got the following:
---------+---------+---------+---------+---------+---------+---------+---------+
SELECT 10.0 / 0 FROM SYSIBM.SYSDUMMY1
00010000
---------+---------+---------+---------+---------+---------+---------+---------+
---------+---------+---------+---------+---------+---------+---------+---------+
?????????????????
DSNT404I SQLCODE = 802, WARNING: EXCEPTION ERROR ZERO DIVIDE HAS OCCURRED
DURING DIVISION OPERATION ON DECIMAL DATA, POSITION 001
DSNT418I SQLSTATE = 01519 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXRDEC SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 1009 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'000003F1' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION
DSNE610I NUMBER OF ROWS DISPLAYED IS 1
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100
---------+---------+---------+---------+---------+---------+---------+---------+
DSNE617I COMMIT PERFORMED, SQLCODE IS 0
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0

(Embedded image moved to file: pic12722.gif)



Sam Baugh
<Sam.Baugh@M
OTION-IND.CO To
M> [login to unmask email]
Sent by: DB2 cc
Data Base
Discussion Subject
List [DB2-L] [z/OS DB2v8] SQLCODE 802
<[login to unmask email]
B2-L.ORG>


11/09/2006
01:21 PM


Please
respond
to
DB2
Databas
e
Discuss
ion
list at
IDUG
<DB2-L@
WWW.IDU
GDB2-L.
ORG>






Just curious if there was a change in SQLCODE returned for "zero divide"
exception between DB2v7 and DB2v8. An application failed with an +802
error and supposedly it did not fail because of this before. We have
migrated all our systems to DB2v8, so I can't verify this. Would someone
still on DB2v7 let me know what return code you get with the following SQL?
Thanks! SELECT 10.0 / 0 FROM SYSIBM.SYSDUMMY1

Sam Baugh
Motion Industies




The information in this communication, including any attachments,
is intended only for the person or entity to which it is addressed
and may contain confidential, proprietary, and/or privileged
material. Any review, retransmission, dissemination or other use
of, or taking of any action in reliance upon, this information by
persons or entities other than the intended recipient is
prohibited. If you received this in error, please contact the
sender and delete the material from all computers.
---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm


----------------------------------------------------------------------
CONFIDENTIALITY STATEMENT. The information contained in this e-mail message, including attachments, is the confidential information of, and/or is the property of, Vanguard. The information is intended for use solely by the individual or entity named in the message. If you are not an intended recipient or you received this in error, then any review, printing, copying, or distribution of any such information is prohibited, and please notify the sender immediately by reply e-mail and then delete this e-mail from your system.

Chris Hoelscher

Re: [z/OS DB2v8] SQLCODE 802
(in response to William Shipley)
V7.1 z/OS


SELECT 10.0 / 0 FROM SYSIBM.SYSDUMMY1
;
DSNT404I SQLCODE = 802, WARNING: EXCEPTION ERROR ZERO DIVIDE HAS
OCCURRED DURING DIVISION OPERATION ON DECIMAL DATA, POSITION
001
ROLLBACK WORK ;
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
CONTROL PROCESS CARD:


Chris Hoelscher
IDMS & DB2 Database Administrator
Humana Inc
502-476-2538
[login to unmask email]




The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Sam Baugh

Re: [z/OS DB2v8] SQLCODE 802
(in response to Chris Hoelscher)
Thanks for the responses. I guess the problem runs deeper than just the
simple divide by zero example. The application uses functions SUM, DEC,
FLOAT, ROUND, and VALUE on the dividend and divisor. Perhaps the VALUE
function was overriding the exception somehow. I will just say they got
away with this exception in v7.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

ANAND JAYACHANDRAN

Re: [z/OS DB2v8] SQLCODE 802
(in response to Sam Baugh)
I executed the SQL using DB2 connect & BMC catalog manager against z/OS
database(s), SQLCODE = 0

In SPUFI, SQLCODE = 802

Against AIX DB2, I receive error.
SQL0801N Division by zero was attempted. SQLSTATE=22012


From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Sam Baugh
Sent: Thursday, November 09, 2006 10:22
To: [login to unmask email]
Subject: [DB2-L] [z/OS DB2v8] SQLCODE 802

Just curious if there was a change in SQLCODE returned for "zero divide"
exception between DB2v7 and DB2v8. An application failed with an +802
error and supposedly it did not fail because of this before. We have
migrated all our systems to DB2v8, so I can't verify this. Would
someone still on DB2v7 let me know what return code you get with the
following SQL? Thanks! SELECT 10.0 / 0 FROM SYSIBM.SYSDUMMY1

Sam Baugh
Motion Industies



---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Pradeep Gunjala

Re: [z/OS DB2v8] SQLCODE 802
(in response to Sam Baugh)
yes, getting the same error in V7 and V8(CM).

Thanks,
Pradeep




Sam Baugh <[login to unmask email]>
Sent by: DB2 Data Base Discussion List <[login to unmask email]>
11/09/2006 01:21 PM
Please respond to
DB2 Database Discussion list at IDUG <[login to unmask email]>


To
[login to unmask email]
cc

Subject
[DB2-L] [z/OS DB2v8] SQLCODE 802






Just curious if there was a change in SQLCODE returned for ?zero divide?
exception between DB2v7 and DB2v8. An application failed with an +802
error and supposedly it did not fail because of this before. We have
migrated all our systems to DB2v8, so I can?t verify this. Would someone
still on DB2v7 let me know what return code you get with the following
SQL? Thanks! SELECT 10.0 / 0 FROM SYSIBM.SYSDUMMY1

Sam Baugh
Motion Industies


The information in this communication, including any attachments,
is intended only for the person or entity to which it is addressed
and may contain confidential, proprietary, and/or privileged
material. Any review, retransmission, dissemination or other use
of, or taking of any action in reliance upon, this information by
persons or entities other than the intended recipient is
prohibited. If you received this in error, please contact the
sender and delete the material from all computers.
---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm