Db2 Sql 401 Error
Contents |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 4 of 4 Thread: com.ibm.db2.jcc.b.nm: DB2 SQL Error: SQLCODE=-401, SQLSTATE=42818, SQLERRMC==, Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/codes/src/tpc/n401.html Hybrid Mode Switch to Threaded Mode 10-13-09,03:07 #1 ramesh.ibm View Profile View Forum Posts Registered User Join Date Oct 2009 Posts 16 Unanswered: com.ibm.db2.jcc.b.nm: DB2 SQL Error: SQLCODE=-401, SQLSTATE=42818, SQLERRMC==, Hi i want to select the roles for a product. i am getting following exception ..and what could be reason. Please any help will be appreciated com.ibm.ws.webcontainer.servlet.ServletWrapper init SRVE0242I: http://www.dbforums.com/showthread.php?1648915-com-ibm-db2-jcc-b-nm-DB2-SQL-Error-SQLCODE-401-SQLSTATE-42818-SQLERRMC [/AdminRoleProduct.jsp]: Initialization successful. [10/13/09 12:30:22:695 IST] 0000003e application E com.ibm.db2.jcc.b.nm: DB2 SQL Error: SQLCODE=-401, SQLSTATE=42818, SQLERRMC==, DRIVER=3.50.152 javax.faces.el.EvaluationException: com.ibm.db2.jcc.b.nm: DB2 SQL Error: SQLCODE=-401, SQLSTATE=42818, SQLERRMC==, DRIVER=3.50.152 Thanks in advance Ramesh Reply With Quote 10-13-09,08:09 #2 ARWinner View Profile View Forum Posts Registered User Join Date Jan 2003 Posts 4,286 Provided Answers: 5 SQL0401N The data types of the operands for the operation "
Tag: Error: DB2 SQL Error: SQLCODE=-401 SQLSTATE=42818 DB2 SQL Errors Codes and Error Messages and Warnings from Error -400 to -402 February 11, 2015 SQLServerF1 Leave a comment Error: DB2 SQL Error: SQLCODE=-400, SQLSTATE=54027, http://www.sqlserverf1.com/tag/error-db2-sql-error-sqlcode-401-sqlstate42818/ SQLERRMC=TBSPACEID=, TABLEID=, COLNO=, DRIVER= THE CATALOG HAS THE MAXIMUM NUMBER OF USER DEFINED INDEXES Explanation: No more than 500 user-defined indexes can be created in the catalog database. System action: The statement cannot be executed. Programmer response: If this index must be created, another user-defined index on the catalog must be dropped. After that index is dropped, this statement can be executed. SQLSTATE: 54027 Error: DB2 SQL Error: SQLCODE=-401, db2 sql SQLSTATE=42818, SQLERRMC=TBSPACEID=, TABLEID=, COLNO=, DRIVER= THE OPERANDS OF AN ARITHMETIC OR COMPARISON OPERATION ARE NOT COMPARABLE Explanation: An arithmetic operation appearing within the SQL statement contains a mixture of numeric and non-numeric operands, or the operands of a comparison operation are not compatible. One reason for this error is that a field procedure exists on one of the columns. If one column of arithmetic or comparison operation is db2 sql 401 defined with a field procedure, other columns in the operation must be defined with the same field procedure. System action: The statement cannot be executed. Programmer response: Check the data types of all operands to ensure that their data types are comparable and compatible with their usage in the statement. If all the operands of the SQL statement are correct, then, if a view is being accessed, check the data types of all the operands in the view definition. SQLSTATE: 42818 Error: DB2 SQL Error: SQLCODE=-402, SQLSTATE=42819, SQLERRMC=TBSPACEID=, TABLEID=, COLNO=, DRIVER= AN ARITHMETIC FUNCTION OR OPERATOR function-operator IS APPLIED TO CHARACTER OR DATETIME DATA Explanation: A nonnumeric operand has been specified for the arithmetic function or operator. function-operator The name of the arithmetic function or operator. System action: The statement was not executed. Programmer response: Examine and correct the syntax of the SQL statement so that all operands of the specified function or operator are numeric. SQLSTATE: 42819 Above are list of DB2 SQL Errors and Warnings from Error -400 to -402 received while performing certain operation against DB2 Database or related products. SQLCODE - Regardless of whether the application program provides an SQLCA or a stand-alone variable, SQLCODE is set by DB2 afte