Db2 Sql Error Code 433
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might
Db2 Sql Error Code 811
have Meta Discuss the workings and policies of this site About db2 sql error code 204 Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads db2 sql error code 206 with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/codes/src/tpc/n433.html programmers, just like you, helping each other. Join them; it only takes a minute: Sign up DB2 SQLCODE -433, SQLSTATE 22001 up vote 0 down vote favorite I have created a trigger, inside the trigger I am appending lot of varchar and creating a new varchar. if I append too many varchars then I am http://stackoverflow.com/questions/30117030/db2-sqlcode-433-sqlstate-22001 getting below Sql Exception. (if I append 4 or 5 varchar then I am not getting this error) I have found out that varchar maximum size is based on page size of the table space. I have checked my page size, its 8K bytes. But The content I am appending is not 8K bytes. Please help me to resolve this error. An error occurred in a triggered SQL statement in trigger "ORDDBA.ORD_IR_IN". Information returned for the error includes SQLCODE "-433", SQLSTATE "22001" and message tokens "ACTION|AREA_UNIT|BAL_CHG_FLAG|CANCEL_DATE|".. SQLCODE=-723, SQLSTATE=09000, DRIVER=3.66.46 declare columnNames varchar(5000); SET columnNames=''; SET columnNames = 'value1' ; SET columnNames = CONCAT(columnNames, '|') ; SET columnNames = CONCAT(columnNames, 'value2') ; SET columnNames = CONCAT(columnNames, '|') ; SET columnNames = CONCAT(columnNames, 'value3') ; SET columnNames = CONCAT(columnNames, '|') ; SET columnNames = CONCAT(columnNames, 'value14') ; SET columnNames = CONCAT(columnNames, '|') ; SET columnNames = CONCAT(columnNames, 'value5') ; SET columnNames = CONCAT(columnNames, '|') ; SET columnNames = CONCAT(columnNames, 'value6') ; SET columnNames = CONCAT(columnNames, '
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more http://stackoverflow.com/questions/28978614/strange-db2-exception-while-executing-queries about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up strange DB2 Exception while executing queries up vote 1 down vote favorite db2 sql I am running some DB2 queries and after that I am calling a PL sql procedure calling of Procedure is CallableStatement callStmt = con.prepareCall( // "CALL INIT_PAYROLL(?,?,?,?,?,?,?,?,?,?)"); // Set IN parameters callStmt.setString(1, start_date);//IN callStmt.setString(2, end_date); //IN callStmt.setInt(3, customer_id);//IN callStmt.setString(4, payrollMain_id+"");//IN callStmt.setString(5, ruleFreq );//IN callStmt.setInt(6, 0); callStmt.setString(7, outerArray);//IN callStmt.setString(8, commsSepEmps);//IN callStmt.setInt(9, isIncremental); callStmt.registerOutParameter (10, Types.VARCHAR); //Call the procedure callStmt.executeUpdate(); toReturnStatus = callStmt.getString(10); System.out.println("OutPutResult-- : " + toReturnStatus); But some strange problem db2 sql error I am facing. I am clueless about why that is happening. Another Question is if I call this procedure from within of Java files, and If an exception occurs in PLSql procedure, will the exception be printed as DB2 exception? Error : [2/27/15 17:00:15:778 IST] 0000280f SystemErr R com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-433, SQLSTATE=22001, SQLERRMC=129727:12068,133389:12069,133390:12070,133391:12071,133393:1, DRIVER=3.62.56 in this error 129727:12068 , is employee_id:primaryKeyOFtable , EDIT : The SP don't give problem in every case, I pass comma separated employeeIds in SP, only when it exceeds some certain limit/length, it fails and give this error. EDIT I solved/found the error, Actually I was passing a String whose length was exceeding the defined VarChar limit. :) java stored-procedures db2 share|improve this question edited Apr 2 '15 at 4:31 asked Mar 11 '15 at 4:31 Rishi Prakash 740316 Try running your SP from SSMS. –Paresh J Mar 11 '15 at 4:41 No, it don't fails in every case. I have updated the Details ,please check. –Rishi Prakash Mar 11 '15 at 4:51 1 Did you have a chance to read the explanation of SQLCODE -433 in the manual? –mustaccio Mar 11 '15 at 11:41 add a comment| 1 Answer 1 active oldest votes u