all Viewers,
i written one procedure using ibm workbench.it return all values in workbench tool.but in java side iam calling that procedure.it returns below error.
--------***any body Please help me ***---------


com.ibm.db2.jcc.c.SqlException: [ibm][db2][jcc][1061][10303] Escape syntax error. See attached Throwable for details.
com.ibm.db2.jcc.c.SqlException: [ibm][db2][jcc][1061][10303] Escape syntax error. See attached Throwable for details.
at com.ibm.db2.jcc.c.p.c(p.java:573)
at com.ibm.db2.jcc.c.fg.m(fg.java:2456)
at com.ibm.db2.jcc.c.gg.b(gg.java:222)
at com.ibm.db2.jcc.c.gg.<init>(gg.java:204)
at com.ibm.db2.jcc.c.hg.<init>(hg.java:50)
at com.ibm.db2.jcc.b.xb.<init>(xb.java:80)
at com.ibm.db2.jcc.b.b.b(b.java:1738)
at com.ibm.db2.jcc.c.p.a(p.java:1553)
at com.ibm.db2.jcc.c.p.prepareCall(p.java:503)
at com.karishma.twofieldmaster.TwoFieldMasterDAO.getL istDetails(TwoFieldMasterDAO.java:80)
at com.karishma.twofieldmaster.TwoFieldMaster.getList Details(TwoFieldMaster.java:72)
at com.karishma.twofieldmaster.TwoFieldMaster.service (TwoFieldMaster.java:30)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:802)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:173)
at org.netbeans.modules.web.monitor.server.MonitorFil ter.doFilter(MonitorFilter.java:368)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11 ConnectionHandler.processConnection(Http11BaseProt ocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.process Socket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThr ead****nIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlR unnable****n(ThreadPool.java:684)
at java.lang.Thread****n(Thread.java:619)
Caused by: com.ibm.db2.jcc.c.h: [ibm][db2][jcc][1064][10658] Unrecognized keyword in escape clause: SP_GBL_GETTWOFIELDMASTERDATA(?,?,?,?,?).
at com.ibm.db2.jcc.c.hb.a(hb.java:51)
at com.ibm.db2.jcc.c.hb.a(hb.java:119)
at com.ibm.db2.jcc.c.p.c(p.java:570)
... 29 more
in list

Please provide DB2 version and OS. Also provide SP code (at least name and parameters) and the java code you are using to make the call.

Andy

Have you tried what the message tells you to do: See attached Throwable for details.