DO NOT REPLY [Bug 29954] - Ant attempts to process result sets for SQL statements that do not return result sets, generating CLI0125E function sequence error in DB2

[bugzilla]

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=29954>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=29954

Ant attempts to process result sets for SQL statements that do not return 
result sets, generating CLI0125E function sequence error in DB2





------- Additional Comments From [EMAIL PROTECTED]  2004-07-07 16:20 -------
Steps to reproduce:

1.  Create an SQL script C:/CreateTables.sql with the following statements:


drop table test;                  
create table test(col1 char(1));  


2.  Create the following build.xml file.  Be sure to adjust the database name 
in the url as well as userid and password:

<?xml version="1.0" encoding="UTF-8"?>             
<project name="DatabaseLoad" default="main">       
  <target name="main">                             
    <echo message="Building Database..."/>         
    <sql                                           
        driver="COM.ibm.db2.jdbc.app.DB2Driver"    
        url="jdbc:db2:MyDataBase"                  
        userid="username"                          
        password="password"                        
        onerror="continue">                        
        <transaction src="C:/CreateTables.sql"/>   
     </sql>                                        
  </target>                                        
</project>                 

3.  Install DB2 8.1 FixPak 6 and Ant 1.6.1.  Run with the command:

ant -v -f build.xml 

4.  To test with earlier DB2 8.1 FixPak releases, you will need to enable CLI 
tracing in DB2 and manually review the trace file to verify that the CLI0125E 
is indeed occurring, though it is never reported to the end user in FixPak 5 
and under.  to enable tracing in DB2 CLI, issue the commands:

    db2 update cli cfg for section common using TRACE 1
    db2 update cli cfg for section common using TRACEFLUSH 1
    db2 update cli cfg for section common using TRACEPATHNAME C:\temp
    db2 terminate

A .cli trace file will be written to the specified TRACEPATHNAME directory.  
This directory must already exist as DB2 will not create it.

Tracing may be disabled using:

    db2 update cli cfg for section common using TRACE 0

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]