class TestIbmDb2 < Test::Unit::TestCase

  def test_190
    assert_expectf do
      conn = DB2::connect db,username,password
      
      if conn
        result = DB2::columns conn,NULL,NULL,"EMPLOYEE"
        while (row = DB2::fetch_array(result))
         str = row[1] + "/" + row[3];    
         puts str
        end
        print "done!"
      else
        print "no connection: #{DB2::conn_errormsg}";    
      end
    end
  end

end

__END__
%s/EMPNO
%s/FIRSTNME
%s/MIDINIT
%s/LASTNAME
%s/WORKDEPT
%s/PHONENO
%s/HIREDATE
%s/JOB
%s/EDLEVEL
%s/SEX
%s/BIRTHDATE
%s/SALARY
%s/BONUS
%s/COMM
done!