Restricting the data that FM/Db2 loads from Db2®

When you view a Db2® table or view in a File Manager/Db2 editor session, FM/Db2 accesses Db2® to obtain a copy of the data in the table or view. This copy of the data is loaded into the FM/Db2 editor. In normal circumstances, the data for every column of the Db2® object is retrieved - with the exception of any LOB or XML columns (see Viewing and changing LOB data and XML documents for more information). This occurs regardless of whether you have deselected one or more columns using the template editor.

However, you may find that you want to restrict the data that FM/Db2 loads, either because you are only interested in data that satisfies certain selection criteria, or simply to limit the number of rows of data that FM/Db2 retrieves.

The following sections discuss the ways in which you can restrict the data that FM/Db2 loads.

Related tasks

• Storage considerations
• Viewing large tables or views
• Restricting the rows to view by specifying row selection criteria
• Restricting the rows to view with the "Row count" entry field
• Interactively developing row selection criteria
• Using Select Statement Edit to limit the data retrieved by FM/Db2
• Specifying the editor session mode: "normal mode" or "large mode"
• Specifying the start position for your FM/Db2 editor session