class TestIbmDb2 < Test::Unit::TestCase

  def test_016
    assert_expect {
      conn = DB2::connect db,username,password
      if conn
        prepare_t_string conn
        result = DB2::exec conn,"insert into t_string values(123,1.222333,'one to one')"
        if result
          cols = DB2::num_fields result
          print "col: #{cols},"
          rows = DB2::num_rows result
          print "affected row: #{rows }"
        else
          print DB2::stmt_errormsg()
        end
        result = DB2::exec conn,"delete from t_string where a=123"
        if result
          cols = DB2::num_fields result
          print "col: #{cols},"
          rows = DB2::num_rows result
          print "affected row: #{rows }"
        else
          print DB2::stmt_errormsg()
        end
        DB2::close conn
      else
        print "no connection: #{DB2::conn_errormsg()}"
      end
    }
  end

end

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