Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ IBM Data Studio to use ---- window displays all rows     - Linux Crontab Timing task command Detailed (Linux)

- Linux three ways to set environment variables (Linux)

- CentOS 6.5 installation using a data recovery software extundelete (Linux)

- Shuffle Process Arrangement in MapReduce (Server)

- CentOS install Memcached (Server)

- Java multi-threaded in a three way (inheritance, implementation, anonymous inner classes) (Programming)

- Ubuntu 15.10 installation and deployment Swift development environment (Linux)

- Ubuntu How to install and upgrade Linux Kernel 3.15 (Linux)

- Python Dir find a folder several files (Programming)

- Java study notes: String (Programming)

- Oracle conditional select statements and looping statements (Database)

- Linux System Getting Started Tutorial: Installing Brother printer in Linux (Linux)

- PostgreSQL log classification and management (Database)

- Mount and unloading disks under Linux (Linux)

- Remote installation of Net-SNMP whole process (Linux)

- Installation JDK1.7 under Ubuntu14.04 64-bit (Linux)

- ORA-01157 & ORA-01110 Troubleshooting (Database)

- Oracle multi-user concurrency and transaction processing (Database)

- C # dynamic class notes --- (Dynamic) Applications (Programming)

- Linux operating system to solve a serious fault handling (Linux)

 
         
  IBM Data Studio to use ---- window displays all rows
     
  Add Date : 2018-11-21      
         
       
         
  Problem Description

When using Data Studio browsing data in DB2 tables or query results, the default is to display only the first 500 lines:

Solution

How to display all the rows or specify the number of rows to display it? In the "Preferences - SQL developer> - -> Data Management> SQL results view options" settings:

The default number of rows to display SQL query result set to 500. Before custom settings to explain "the maximum row count" and "Max display row count" of these two parameters.

Maximum row count: the number of rows in the result set to fetch. Namely: the need to access memory in the result set number of rows. (CPU memory access)

The maximum display line count: the number of rows fetched to be displayed. Namely: For those rows have been fetched, the number of rows to be displayed in the corresponding Data Studio window. Cache line does not appear in the file.

If both are set to 0, indicating that all rows in the result set to fetch and display all the rows.

If the specified number of rows fetch row is greater than the result set, then fetch all the rows in the result set.

If greater than the specified display row fetched row, show all fetched rows.

If you want to fetch all the rows, but only displays a number of rows, the maximum row count is set to 0, the maximum display line count to the specified value on the line.


Anyway, to understand the meaning of these two parameters can be freely set. But one thing is to note:

When SQL query will be displayed according to the setting below the SQL Results tab Data Studio work space. But browse table data (right-click the table, choose "Browse Data"), will fetch and display all the specified row fetched row. Ignoring the "maximum display line count" setting.

For example, the "maximum row count" is set to 0 (ie fetch all rows), "the greatest display line count" is set to 1000, then proceeds SQL query and browsing data workspace is shown below:


The last point to emphasize is: the value of "maximum row count" should not be set too large, because memory access large amounts of data will affect the performance (in the example fetch all 250,000 rows takes about 1 minute). In fact, the "maximum row count" parameter is equivalent to an additional query fetch first N rows only.

If the maximum row count is 0, then browse the table data is equivalent to execute the SQL statement:

select * from mobile (requires longer execution time)

If the maximum row count is 1000, then the browser time table is the equivalent to the SQL statement:

select * from mobile fetch first 1000 rows only (inquiry be completed soon)
     
         
       
         
  More:      
 
- Spark parquet merge metadata problem (Server)
- A brief description of Java 8 new features introduced syntax (Programming)
- How to enable fbcon in Debian (Linux)
- Ubuntu install Wireshark (Linux)
- Category prevent DoS attacks against Linux (Linux)
- PF_RING 6.0.2 compiled and installed on Redhat 6.3 x86_64 (Linux)
- Ubuntu U disk do not have write privileges can only read but not write (Linux)
- Use custom backup plans for Debian backupninja (Linux)
- How to install Docker and basic usage on Ubuntu 15.04 (Server)
- OpenSUSE installation on CentOS6 (GUI) (Linux)
- Using Android Studio integrated development environment to build Android (Linux)
- Github Remote Assistance (Linux)
- HBase in MVCC implementation mechanism and its application (Database)
- Java multi-threaded shared communications variables (Programming)
- IOS interview questions Summary (Programming)
- RHEL7 Apache MPM configuration (Server)
- Java reflection summary (Programming)
- CentOS6.5 installation Docker (Linux)
- Installation and Configuration ISC DHCP server on Debian Linux (Server)
- Ubuntu 14.04 compile RT288x_SDK / toolchain / squashfs3.2-r2 Error (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.