BROWSE

The following applies to initiating a browse session from the data display.

BROwse  [ TABle table 
        [ COLumns | SELection | SQL ] ]   |
      [ [ STArt table ] [ CREator cid ] ad ] 

TABLE table

Specifies the table to be browsed.

COLUMNS

For use with TABLE, displays the Describe Columns panel prior to the data display.

SELECTION

For use with TABLE, displays the Specify Selection Criteria panel prior to the data display.

SQL

For use with TABLE, displays the Enter the SQL WHERE Clause panel prior to the data display.

START table

Overrides the Start Table defined in the Access Definition with the specified table.

CREATOR cid

Overrides the default Creator ID defined in the Access Definition with the specified Creator ID. CID is an alternate abbreviation for CREATOR.

ad

Specifies the Access Definition to use for browsing data. Optional if an Access Definition is currently being used.

• A browse session can be invoked from the Main Menu using Option 1 BROWSE TABLE or Option 3 BROWSE USING AD. The operands on this command correspond to these two options and are available only in Access.
• You cannot specify an Access Definition and TABLE. If the TABLE keyword is omitted, Access assumes that an Access Definition is to be browsed.
• The BROWSE command can be invoked recursively within the editor. BROWSE suspends the current browse or edit session and uses the named Access Definition or table. When the browse session for the named Access Definition or table terminates, control is returned to the suspended activity.
• The EDIT command is used to edit a table or the set of data defined by an Access Definition.
• The RESTART command is used to terminate the current browse session and start again.

For Access Definitions

• You cannot specify an Access Definition that is already accessed during this session by either EDIT or BROWSE. You can, however, BROWSE any number of other Access Definitions.
• You can specify the name of an Access Definition using DB2^® LIKE syntax to display a selection list of Access Definitions.
• During an edit or browse session using an Access Definition, if the BROWSE command is used to browse an Access Definition, and Group and User are omitted, the current Group and User are used as high-level qualifiers for the Access Definition. If editing or browsing using a table, the complete name of the Access Definition must be supplied.

For Tables

• The TABLE keyword is used to invoke a browse session for the data from a specific table without first creating an Access Definition. Optionally, when you terminate the session, Access can offer the opportunity to save the specifications from the browse session as an Access Definition. This is determined by your specifications on the Choose a Table to Browse panel.
• When you specify the keyword TABLE, you can specify COLUMNS, SELECTION or SQL to enable you to specify criteria for the accessed data prior to displaying the data. If no operand is specified, all data in the table is assumed and the session begins with the data display.
• If the BROWSE command is used to browse a table during an edit/ browse session, and the Creator ID is omitted, the default Creator ID for the current edit or browse session is used.