class TestIbmDb2 < Test::Unit::TestCase

  def test_192
    assert_expectf do
      conn = DB2::connect db,username,password
      
      if conn
        result = DB2::columns(conn,NULL,username.upcase,"EMP_RESUME");    
        while (row = DB2::fetch_both(result))
         printf("%s,%s,%s,%s\n", row[1], 
         row[2], row[3], row[17])
        end
      else
        print "no connection: #{DB2::conn_errormsg}";    
      end
    end
  end

end

__END__
%s,EMP_RESUME,EMPNO,NO
%s,EMP_RESUME,RESUME_FORMAT,NO
%s,EMP_RESUME,RESUME,YES