class TestIbmDb2 < Test::Unit::TestCase

  def test_122
    assert_expect {
      conn = DB2::connect database, user, password
      if conn
        drop = "drop table ftest"
        DB2::exec( conn, drop ) rescue nil
        create = "create table ftest ( TEST integer, \"test\" integer, \"Test\" integer  )"
        DB2::exec conn, create
        insert = "INSERT INTO ftest values (1,2,3)"
        DB2::exec conn, insert
        stmt = DB2::exec conn, "SELECT * FROM ftest"
        num1 = DB2::field_name stmt, 0
        num2 = DB2::field_name stmt, 1
        num3 = DB2::field_name stmt, 2
        num4 = DB2::field_name stmt, "TEST"
        num5 = DB2::field_name stmt, 'test'
        num6 = DB2::field_name stmt, 'Test'
        var_dump( num1 )
        var_dump( num2 )
        var_dump( num3 )
        var_dump( num4 )
        var_dump( num5 )
        var_dump( num6 )
      else
        print "Connection failed."
      end
    }
  end

end

__END__
string(4) "TEST"
string(4) "test"
string(4) "Test"
string(4) "TEST"
string(4) "test"
string(4) "Test"