Db2 Sql Error Sqlcode=-802 Sqlstate=22003
Contents |
Sign in Pricing Blog Support Search GitHub This repository Watch 26 Star https://github.com/ibmdb/python-ibmdb/issues/95 36 Fork 27 ibmdb/python-ibmdb Code Issues 22 Pull requests http://database.ittoolbox.com/groups/technical-functional/db2-l/arithmetic-overflow-or-other-arithmetic-exception-occurred-sqls-tate22003-424048 2 Projects 0 Wiki Pulse Graphs New issue Errors -413 or -802 ignored by ibm_db_dbi #95 Closed GoogleCodeExporter opened this Issue Mar 16, 2015 · 10 comments Projects None yet Labels auto-migrated Milestone No milestone db2 sql Assignees No one assigned 2 participants GoogleCodeExporter commented Mar 16, 2015 What steps will reproduce the problem? for error -802 execute the following from the command line db2-dev:~# python Python 2.7 (r27:82500, Aug 07 2010, 16:54:59) [GCC] on linux2 Type "help", "copyright", "credits" or "license" for more information. db2 sql error >>> import ibm_db_dbi; conn =ibm_db_dbi.connect("DB2"); cursor = conn.cursor() >>> res=cursor.execute("SELECT CAST (DAYS(CAST('0001-01-01 00:00:00' AS TIMESTAMP)) - DAYS('1970-01-01') AS INTEGER) * 86400 FROM SYSIBM.SYSDUMMY1") >>> rs=cursor.fetchone() >>> print res,rs True None >>> What is the expected output? Exception thrown and a message similar to or containing the following: SQLCODE=-802, SQLSTATE=22003 for error -413 execute the following from the command line >>> res=cursor.execute("SELECT CAST('2147483649' AS INTEGER) FROM SYSIBM.SYSDUMMY1") >>> rs=cursor.fetchone() >>> print res,rs True None Expected output: Exception and traceback. odbc trace ----------- [ Process: 20150, Thread: 140737353971456 ] [ Date & Time: 01/30/2012 09:03:10.594982 ] [ Product: QDB2/LINUXX8664 DB2 v9.7.0.4 ] [ Level Identifier: 08050107 ] [ CLI Driver Version: 09.02.0000 ] [ Informational Tokens: "DB2 v9.7.0.4","s110330","IP23243","Fixpack 4" ] [ Install Path: /opt/ibm/db2/V9.7 ] [ db2cli.ini Location: /home/db2inst1/sqllib/cfg/db2cli.ini ] [ CLI Driver Type: IBM Data Server Runtime Client ] [01/30/2012 09:03:10.710389] (
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries Inside-ERP MacProTX VoIP_News Inside-CRM PCMag I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker JoeTorre bracke Locutus Ramnath.Awate Richard DukeGanote Craig Borysowich Dennis Stevenson Nikki Klein mircea_luca AbhaiTripathi knowscognosdoi bluesguyAZ59 Iqbalyk Clinton Jones blrvenkat COMPANIES Juniper Networks CloudLock Avaya Adaptive Planning View All Topics View All Members View All Companies Toolbox for IT Topics Database Groups Ask a New Question DB2 LUW The DB2 LUW (Linux, Unix, Windows) group is for the discussion of technical issues related to the installation, configuration, or daily administration of IBM DB2 LUW databases. Home | Invite Peers | More Database Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Arithmetic overflow or other arithmetic exception occurred. SQLS TATE=22003 Byron Pierce asked Mar 1, 2004 | Replies (6) Hi All, Please see below.... I have a customer that has submitted this problem to me and I am at a loss as for why this is happen