require 'ibm_db2'
require 'stringio'
require 'test/unit'

class TestIbmDb2 < Test::Unit::TestCase

  def test_190
    assert_equal expected, capture {
      conn = DB2::connect(db,username,password)
      
      if (conn)
       result = DB2::columns(conn,NULL,NULL,"EMPLOYEE")
       while (row = DB2::fetch_{result})
         str = row[1] ."/". row[3];	
         puts "#{str}\n"
       end
       puts "done!"
      else
       puts'no connection: ' . DB2::conn_errormsg();	
      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!