require 'ibm_db2'
require 'stringio'
require 'test/unit'

class TestIbmDb2 < Test::Unit::TestCase

  def test_180
    assert_equal expected, capture {
      conn = DB2::connect(db,username,password)
      if conn
        result = @DB2::exec(conn,"insert int0 t_string values(123,1.222333,'one to one')")
        if result
          cols = DB2::num_fields(result)
          puts'col: ' . cols . ','
          rows = DB2::num_rows(result)
          puts'affected row: ' . rows 
        else
          putsDB2::stmt_errormsg();    
        end
        result = @DB2::exec(conn,"delete from t_string where a=123")
        if result
          cols = DB2::num_fields(result)
          puts'col: ' . cols . ','
          rows = DB2::num_rows(result)
          puts'affected row: ' . rows 
        else
          putsDB2::stmt_errormsg();    
        end
      
      else
        puts'no connection';    
      end
    }
  end

end

__END__
[IBM][CLI Driver][DB2/%s] SQL0104N  An unexpected token "insert int0 t_string" was found following "BEGIN-OF-STATEMENT".  Expected tokens may include:  "<space>".  SQLSTATE=42601 SQLCODE=-104col: 0,affected row: 0