Db2 Sql Error Sqlcode=-310
Contents |
3 CONTAINS NON-DECIMAL DATA z/os A fix is available Obtain the db2 sql error sqlcode list fix for this APAR. Subscribe You can track all active APARs db2 sql error sqlcode 305 for this component. APAR status Closed as program error. Error description Error message 'SQLCODE =
Db2 Sql Error Sqlcode 440 Sqlstate 42884 Stored Procedure
-310, ERROR: DECIMAL HOST VARIABLE OR PARAMETER 3 CONTAINS NON-DECIMAL DATA' may occur when editing XML. KEYWORD SQLCODE310 Local fix Problem summary **************************************************************** * USERS AFFECTED:
Db2 Sql Error Sqlcode 804
Users of DB2 Table Editor. * **************************************************************** * PROBLEM DESCRIPTION: Error message 'SQLCODE = -310, ERROR: * * DECIMAL HOST VARIABLE OR PARAMETER 3 * * CONTAINS NON-DECIMAL DATA' may occur * * when editing XML. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct db2 sql error sqlcode 204 sqlstate 42704 this condition. Problem conclusion APPLY the PTF. Temporary fix Comments APAR Information APAR numberPM21877 Reported component nameDB2 TABLE EDITO Reported component ID5697G6500 Reported release130 StatusCLOSED PER PENoPE HIPERNoHIPER Special AttentionNoSpecatt Submitted date2010-09-02 Closed date2011-02-08 Last modified date2011-03-02 APAR is sysrouted FROM one or more of the following: APAR is sysrouted TO one or more of the following: UK64653 Modules/Macros ETI@LOB Fix information Fixed component nameDB2 TABLE EDITO Fixed component ID5697G6500 Applicable component levels R130 PSY UK64653UP11/02/15 P F102 Fix is available Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries. Document information More support for: DB2 Tools for z/OS DB2 Table Editor Software version: 4.3.0 Reference #: PM21877 Modified date: 2011-03-02 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility
on select statement? IBM's flagship relational database management system Post a reply Previous topic • Next topic • 4 posts • Page 1 of 1 SQLCODE -310 on select statement? by fornanthakumar » Tue Jan 04, 2011 7:27 am Hi,I have an query in my
Db2 Sql Error Sqlcode 803
application program like below,Select allEXEC SQL db2 sql error sqlcode 104 sqlstate 42601 SELECT CENTR_NAME_X, db2 sql error sqlcode 206 sqlstate 42703 CENTR_TYPE_C, HMLN_RGION_N http://www.ibm.com/support/docview.wss?uid=swg1PM21877 INTO :CENTR-NAME-X, :CENTR-TYPE-C, :HMLN-RGION-N FROM HMLN.ONLIN_CENTR WHERE http://www.ibmmainframeforum.com/db2/topic5027.html CENTR_IBT_N = :DCLHMLN-RGSTN.RGION-IBT-N WITH UR END-EXEC. both CENTR_IBT_N and DCLHMLN-RGSTN.RGION-IBT-N declared as decimal (5,0) not null. The actual value of DCLHMLN-RGSTN.RGION-IBT-N is 00000.While the program was executing, i have got an ABEND with SQLCODE is -31} (-310). Which is DECIMAL HOST VARIABLE OR PARAMETER number CONTAINS NON-DECIMAL DATA. I was puzzled here because while i execute the same query in spufi like belowSelect allSELECT CENTR_NAME_X, CENTR_TYPE_C, HMLN_RGION_N FROM HMLN.ONLIN_CENTR WHERE CENTR_IBT_N = 00000;I have got an empty result set.Someone please help out on this.? Regards,Nanthu.Y. fornanthakumar Posts: 70Joined: Fri Oct 22, 2010 1:58 pm Hasthanked: 0 time Beenthanked: 0 time Top Re: SQLCODE -310 on select statement? Top Re: SQLCODE -310 on select statement? by dick scherrer » Tue Jan 04, 2011 11:39 am Hello,The literal 00000 is valid - the host variable is not. . .How is this defined and what value is in this variable when the problem occurs? Hope this helps,d.sch. dick scherrer Global moderator Posts: 6308Joined: Sat Jun 09, 2007 8:58 am Hasthanked: 3 times Beenthan
MainFrame >> DB2 Suggest New Category How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2). Question Posted / nitin 2 Answers 19206 Views IBM, Infosys, http://www.allinterview.com/showanswers/61936/how-to-resolve-sql-code-310-the-db-table-feild-is-declared-as-decimal-7-2.html I also Faced E-Mail Answers Answers were Sorted based on User's Feedback Answer http://www.sqlserverf1.com/tag/error-db2-sql-error-sqlcode-310-sqlstate22023/ / ashu Check your program and make sure that the data you are passing to this host variable do not contain NON-DECIMAL value. Is This Answer Correct ? 26 Yes 1 No Answer / satty its just like your soc7 error... check your decimal data... whether it is decimal or not Is This Answer Correct ? 0 Yes 8 No db2 sql Post New Answer Categories COBOL (884)JCL (728)CICS (459)DB2 (684)IMS (80)IDMS (42)Natural (43)ADABAS (9)REXX (23)Assembler (31)CLIST (6)QMF (30)MVS (12)OS390 (8)OS 2 (6)VSAM (177)QSAM (4)Sysplex (5)IBM MainFrame AllOther (160) More DB2 Interview Questions How to resolve -805 error in DB2? 1 Answers Cap Gemini, query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop 2 db2 sql error Answers IBM, In terms of DB2 indexing, what is the root page? 1 Answers What are the four lockable units for DB2? 1 Answers How do you prepare a COBOL + DB2 program from coading till execution ? 1 Answers Xansa, Amdocs, what is the difference between join and union? 4 Answers can we view the access paths created by dbrm ? how ? thx 2 Answers IBM, Bind concepts in DB2 cobol 10 Answers TCS, IBM, Virtusa, TRD, How many sub queries can you combine together ? 4 Answers I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT. 0 Answers Syntel, ITC Infotech, Where are plans stored? 2 Answers in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....? 3 Answers Infosys, For more DB2 Interview Questions Click Here Copyright Policy | Terms of Service | Site Map | Contact Us Copyright © 2016 ALLInterview.com. All Rights Reserved.
Tag: Error: DB2 SQL Error: SQLCODE=-310 SQLSTATE=22023 DB2 SQL Errors Codes and Error Messages and Warnings from Error -309 to -311 February 6, 2015 SQLServerF1 Leave a comment Error: DB2 SQL Error: SQLCODE=-309, SQLSTATE=22512, SQLERRMC=TBSPACEID=, TABLEID=, COLNO=, DRIVER= A PREDICATE IS INVALID BECAUSE A REFERENCED HOST VARIABLE HAS THE NULL VALUE Explanation: The statement could not be processed because a host variable appearing in a predicate such as column-name = host-variable had the NULL value. Such a predicate is not permitted when the host variable contains the NULL value even though the object column might contain nulls. System action: The statement cannot be executed. Programmer response: Rebind the plan or package containing the statement. The condition described is not an error in DB2 Version 2 Release 3 and later releases. SQLSTATE: 22512 Error: DB2 SQL Error: SQLCODE=-310, SQLSTATE=22023, SQLERRMC=TBSPACEID=, TABLEID=, COLNO=, DRIVER= DECIMAL HOST VARIABLE OR PARAMETER number CONTAINS NON-DECIMAL DATA Explanation: DB2 received nondecimal data from either an application (in the form of a host variable), function or a stored procedure (in the form of a parameter that was passed to or from function or a stored procedure). number Identifies either the host variable number (if the message is issued as a result of a FETCH, INSERT, UPDATE, MERGE, DELETE, SELECT, VALUES INTO, or SET assignment statement), or the parameter number (if the message is issued as the result of the invocation of a function, or a CALL statement). System action: The statement cannot be processed. Programmer response: Correct the application program or stored procedure. Ensure that all decimal variables or parameters contain valid System/370 packed decimal numbers. SQLSTATE: 22023 Error: DB2 SQL Error: SQLCODE=-311, SQLSTATE=22501, SQLERRMC=TBSPACEID=, TABLEID=, COLNO=, DRIVER= THE LENGTH OF INPUT HOST VARIABLE NUMBER position-number IS NEGATIVE OR GREATER THAN THE MAXIMUM Explanation: When evaluated, the length specification for input host string variable, whose entry in the SQLDA is indicated by position-number, was negative or greater than the maximum. System action: The statement cannot be executed. Programmer response: Correct the program to ensure that the lengths of all host string variables are not nega