1. SQLCODE=-723 during insertions in DB2 stackoverflow.comI have a series of insert statements in my code. The table has few triggers to update last updated date and time. Certain insertions are succeeding while other similar inserts into ... |
2. DB2 SQL error: SQLCODE: -8002 coderanch.comHello, I am getting an error on connecting to DB2. Infact it was working all these days.. now suddenly im getting the error: com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -8002, SQLSTATE: 42968, SQLERRMC: ;37;CCTDB2V ;CCTDB001;QDB2; ; ; ;1208; ; any clues on this??? Anyone ever faced this problem before. I belive this is an environment issue with DB2 |
3. DB2 SQL error: SQLCODE: -911, SQLSTATE: 40001, SQLERRMC: 2 coderanch.comExceptioncom.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -911, SQLSTATE: 40001, SQLERRMC: 2. I have a db2 database update statement in java compute node in message broker with which I am getting the above mentioned sql error (due to deadlock). This happened 2 days and I could see that this error is there in the message broker logs but the database logs do not ... |
4. DB2 ZOS DB2 SQL error: SQLCODE: -181, SQLSTATE: 22007, SQLERRMC: null coderanch.comHello all I have a pretty muddling problem at hand. I am trying to insert a row into table which contains a field LAST_UPDATE_TIME. I set this to the current time using java.sql.date and then run my Insert statement. But I keep getting this error in my logs: Error while adding ComSubQuestion : Sql Exception: com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -181, ... |
5. DB2 SQL Error: SQLCODE=-103 coderanch.comDon't build SQL strings like that. For one thing it's error-prone, as you can see from your own post (I will leave you to google those error codes to find out what you did wrong). For another thing it makes your system liable to SQL injection attacks (I will leave you to google that too, and I strongly advise you to ... |