Topic
No replies
kuriyal
kuriyal
1 Post
ACCEPTED ANSWER

Pinned topic DB2 SQL error: SQLCODE: -206, SQLSTATE: 42703

‏2010-03-15T16:36:39Z |
Hi everyone,

I added a new column in my DB2 table and i am trying to execute select query from my code.while doing that i am getting following error.When i run same query on DB2 client,it works fine.

Select Query --> SELECT INV.INV_IK, BUS_INV_ID, INV_DS_TX, ITM_USG_CD, RPLC_INV_IK, INV_LOC_CD, ITM_PART_D_CD, DEFLT_RVW_PERD, SAMPLE_LOC_TX, CNTRY_OF_ORGN_CD, BKORD_ALW_IN, KIT_IN, KIT_PHYSCL_IN, ALW_IN_KIT_IN, ELCTRC_DOC_AVL_IN, LGL_RGLT_IN, INV_ACTV_DT, INV_ACTV_BY_IK, INV_EFF_STRT_DT, INV_EFF_END_DT, INV_DSPLY_STRT_DT, INV_DSPLY_END_DT, INV.CRTE_TS, INV.CRTE_ID, INV.UPDT_TS, INV.UPDT_ID, INV_STS_CD, UNT_CST_AM, RTL_PRC_AM, UNT_OF_ISSU_CD, REC_RCYCL_DT, REC_RCYCL_BY_IK, REORDR_PNT_PRD_QT, PRDCT_FMLY_CD, DF_IN, GRPHC_ADDR_NM, CPE_STS_CD, LEAD_TM_IN_DAY_CT, RVW_RSPNS_DT, ITM_CT_PER_ISSU_CT, OWN_ID, MTRL_LEN_IN_CT, MTRL_WD_IN_CT, MTRL_DPTH_IN_CT, MTRL_WGHT_LB_CT, CLTHNG_SIZE_CD, RVSN_BUS_INV_ID, PLN_BNFT_PGM_CD, ITEM_OWN_ID, INV.EVER_ACTV_IN, MAX_ORDR_QT,(SELECT SUM(VNDR_INV_QT) FROM HPUB.THPUVIN_VNDR_INV AS VNDINV WHERE VNDINV.INV_IK = INV.INV_IK) AS EST_AVL_QTY, ORDRBL_IN FROM HPUB.THPUGIN_GNRL_INV INV,HPUB.THPUIAU_INV_AUTH AUTHINV where inv.inv_ik = authInv.INV_IK and authInv.AUTH_GRP_IK = 1 ORDER BY INV_DS_TX fetch first 100 rows only with ur

com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -206, SQLSTATE: 42703, SQLERRMC: DEFLT_RVW_PERD
at com.ibm.db2.jcc.a.rf.e(rf.java:1680)
at com.ibm.db2.jcc.a.rf.a(rf.java:1239)
at com.ibm.db2.jcc.b.jb.h(jb.java:139)
at com.ibm.db2.jcc.b.jb.a(jb.java:43)
at com.ibm.db2.jcc.b.w.a(w.java:30)
at com.ibm.db2.jcc.b.cc.g(cc.java:160)
at com.ibm.db2.jcc.a.rf.n(rf.java:1219)
at com.ibm.db2.jcc.a.sf.gb(sf.java:1790)
at com.ibm.db2.jcc.a.sf.d(sf.java:2266)
at com.ibm.db2.jcc.a.sf.Z(sf.java:1298)
at com.ibm.db2.jcc.a.sf.execute(sf.java:1282)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecute(WSJdbcPreparedStatement.java:735)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WSJdbcPreparedStatement.java:503)
at org.kp.hpub.dao.InventoryItemDao.selectRecordsBySearchCriteria(InventoryItemDao.java)
at org.kp.hpub.dao.InventoryItemDao.selectRecordsBySearchCriteria(InventoryItemDao.java)
at org.kp.hpub.action.SearchInventory.execute(SearchInventory.java)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1192)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:430)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:966)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:907)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:145)
at org.kp.hpub.filter.CleanUp.doFilter(CleanUp.java:64)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:701)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:646)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:475)
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:463)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:92)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:744)
at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1433)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:93)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:465)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:394)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:152)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:213)
at com.ibm.io.async.AbstractAsyncFuture.fireCompletionActions(AbstractAsyncFuture.java:195)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:194)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:741)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:863)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1510)

Any help in this is highly appreciated.
Thanks in advance guys