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

class TestIbmDb2 < Test::Unit::TestCase

  def test_101
    assert_equal expected, capture {
      conn = DB2::connect(db,user,password)
      if conn
        result = DB2::exec(conn,"insert into 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 
        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 
        end    
      else
        puts'no connection';    
      end
    }
  end

end

__END__
col: 0,affected row: 1col: 0,affected row: 1