COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0637E QUERY cannot be found.
 Technote (FAQ)
 
Problem
Using DB2's statement "SET SCHEMA ..." causes the exception: COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0637E QUERY cannot be found.
 
Solution
In DB2 UDB Version 7.2 FixPack 5 and higher (because of J2EE compliance), the method executeQuery must be used for query statements (SELECT) and executeUpdate should be used for non-query (INSERT, UPDATE, DDL, etc.) statements.

The SET SCHEMA statement changes the value of the CURRENT SCHEMA special register (for more information, please see DB2's SQL Reference manual). It is a non-query statement, so the executeUpdate method must be used.

 
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > Java 2 Connectivity (J2C)
Operating system(s): HP-UX
Software version: 4.0
Software edition:
Reference #: 1066402
IBM Group: Software Group
Modified date: Sep 9, 2003