Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ IBM Data Studio to use ---- window displays all rows     - Analysis: Little Notebook facing a major security threat secure online (Linux)

- Linux System Getting Started Learning: Using the Linux command line detected DVD burner name and write speeds (Linux)

- How to install the client sqlplus under linux (Database)

- HttpClient4 usage upgrade from HttpClient3 (Programming)

- Linux compiler of GCC (Linux)

- How Ubuntu Snappy Core 2 running on Raspberry Pi (Linux)

- Linux disk virtualization (Linux)

- Linux system installation and usage instructions Wetty (Linux)

- Linux package management (Linux)

- tcpdump Linux system security tools (Linux)

- MySQL Server Time Synchronization Problem (Database)

- Linux System Getting Started Learning: rename multiple files in Linux (Linux)

- MySQL5.6.12 Waiting for commit lock lead to hang from the library housing problem analysis (Database)

- File upload via AngularJS and ASP.NET MVC5 (Programming)

- Hard disk encryption to protect data security (Linux)

- Linux cron job (crontab) Examples (Linux)

- Objective-C basic program structure (Programming)

- Android Studio and Git Git configuration file status (Linux)

- How apt-get limited use IPv4 or IPv6 protocol to download (Linux)

- RedHat Linux 5.5 installation process SVN Service Notes (Server)

 
         
  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:      
 
- Linux System Getting Started Learning: Repair (Linux)
- After installation of Debian 6.0 do a few things first (Linux)
- Linux more efficient than select a model epoll (Linux)
- Adjust the size of the hard disk VirtualBox (Linux)
- The Linux OOM Terminator (Server)
- Teach you how to protect the Linux operating system security tips (Linux)
- Go constructed using an interpreted language (Programming)
- SQL MySQL query table duplicate data (Database)
- Ubuntu Series Installation Docker (Linux)
- Linux dual physical network card set to a virtual NIC (Linux)
- Java implementation chain store binary search tree (recursive method) (Programming)
- Linux usage in echo (Linux)
- Search Linux commands and files - which, whereis, locate, find (Linux)
- Linux System Getting Started Tutorial: How to change the default Java version in Linux (Linux)
- Use install_updates upgrade GAMIT / GLOBK (Linux)
- Docker build their own private warehouses (Linux)
- Oracle View index and use indexes Precautions (Database)
- How to use the beta / unstable version of the software in Debian library (Linux)
- RabbitMQ tutorial examples: the Hello RabbitMQ World Java realization (Linux)
- C language programming entry - macro definitions and enum (Programming)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.