在IBM Data Studio上增加SQL结果列的限制 [英] Increasing SQL result column limit on IBM Data Studio

问题描述

我正在使用IBM Data Studio 当我使用数据源资源管理器向下浏览表中的列时，它限制了它显示的列数.我认为这不是权限问题，因为相同的凭据可以在其他程序中使用.

I'm using IBM Data Studio when I browse down to the columns in a table using the data source explorer it is limiting the number of columns it shows. I don't think it is not a permissions problem as the same credentials work in a different program.

任何人都知道可以在某处进行更改吗?

Anyone know is there a setting somewhere to change this?

推荐答案

在屏幕底部，您会找到一个部分，告知您fetched 500 records, 500 records shown.

At the bottom of the screen you'll find a section informing you with fetched 500 records, 500 records shown.

右键单击此行以显示一个屏幕，可让您更改此选项.

Right click on this line to bring up a screen that lets you change this option.

针对版本4.1.2进行验证

Validated for version 4.1.2

这篇关于在IBM Data Studio上增加SQL结果列的限制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！