class TestIbmDb2 < Test::Unit::TestCase

  def test_100
    assert_expect {
      conn = DB2::connect database, user, password
      if conn
        stmt = DB2::exec conn, "SELECT * FROM animals ORDER BY breed"
        fields1 = DB2::num_fields stmt
        var_dump( fields1 )
        stmt = DB2::exec conn, "SELECT name, breed FROM animals ORDER BY breed"
        fields2 = DB2::num_fields stmt
        var_dump( fields2 )
        stmt = DB2::exec conn, "DELETE FROM animals"
        fields3 = DB2::num_fields stmt
        var_dump( fields3 )
        stmt = DB2::exec conn, "INSERT INTO animals values (0, 'cat', 'Pook', 3.2)"
        fields4 = DB2::num_fields stmt
        var_dump( fields4 )
        stmt = DB2::exec conn, "SELECT name, breed, 'TEST' FROM animals"
        fields5 = DB2::num_fields stmt
        var_dump( fields5 )
      else
        print "Connection failed."
      end
    }
  end

end

__END__
int(4)
int(2)
int(0)
int(0)
int(3)