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

class TestIbmDb2 < Test::Unit::TestCase

  def test_191
    assert_equal expected, capture {
      conn = DB2::connect(db,username,password)
      
      if (conn)
       result = DB2::columns(conn,NULL,NULL,"EMP_PHOTO");	
       while (row = DB2::fetch_both(result))
         printf("%s,%s,%s,%s\n", row['TABLE_SCHEM'], 
         row['TABLE_NAME'], row['COLUMN_NAME'], row['IS_NULLABLE'])
       end
       puts "done!"
      else
       puts'no connection: ' . DB2::conn_errormsg();	
      end
    }
  end

end

__END__
%s,EMP_PHOTO,EMPNO,NO
%s,EMP_PHOTO,PHOTO_FORMAT,NO
%s,EMP_PHOTO,PICTURE,YES
done!