Jump to main content
IBM Logo Product Documentation
  • Products
  • Support
IBM File Manager for z/OS® User’s Guide and Reference for Db2 Data Version 15.1.1
  • PDF documentation
  • About this document
  • Summary of changes
  • Working with FM/Db2
  • FM/Db2 reference
  • Messages
  • Support resources
  • Notices
This version is no longer supported.
View the latest version.
A newer version of this product documentation is available.
View the latest version.
  1. Home
  2. FM/Db2 reference
  3. FM/Db2 panels and fields
  4. Select Statement Edit panel
  • FM/Db2 reference
    • Db2® data types
    • FM/Db2 panels and fields
      • Scrollable fields on FM/Db2 panels
      • Action bar pull-down menu
      • Additional LISTDEF Statements panel
      • Additional TEMPLATE Statements panel
      • Advanced SELECT Prototyping panel
      • Alter Database panel
      • Alter External Scalar Function panel
      • Alter Index panel
      • Alter Stored Procedure panel
      • Alter Table panel
      • Alter Table - ADD CHECK Constraint panel
      • Alter Table - ADD Column panel
      • Alter Table - ADD FOREIGN KEY Constraint panel
      • Alter Table - ADD PRIMARY KEY panel
      • Alter Table - AUDIT panel
      • Alter Table - DATA CAPTURE panel
      • Alter Table - DROP CHECK Constraint panel
      • Alter Table - DROP FOREIGN KEY Constraint panel
      • Alter Table - DROP PRIMARY KEY panel
      • Alter Table - RESTRICT ON DROP panel
      • Alter Table - VALIDPROC panel
      • Alter Table Space panel
      • Application Packages panel
      • Application Plans panel
      • Basic SELECT Prototyping panel
      • Bind Application Plan panel
      • Bind Package panel
      • Children of Table panel
      • Collections panel
      • Column Attributes panel (alphanumeric)
      • Column Attributes panel (DATE)
      • Column Attributes panel (numeric)
      • Column Attributes panel (TIME)
      • Column Attributes panel (TIMESTAMP)
      • Column Distribution panel
      • Column Part Statistics panel
      • Column Selection/Edit panel
      • Columns panel
      • Columns in Index panel
      • Columns in Table panel
      • Comment panels
      • Compiler Language Selection panel
      • Constraint Columns for panel
      • Copy Options panel
      • Copy Utility ("From") panel
      • COPY Utility (Index Spaces) panel
      • COPY Utility (Index Spaces) with LISTDEF panel
      • Copy Utility ("To") panel
      • COPY Utility (Table Spaces) panel
      • COPY Utility (Table Spaces) with LISTDEF panel
      • Create Alias panel
      • Create Auxiliary Table panel
      • Create Database panel
      • Create Distinct Type panel
      • Create Function: Option List (1/2) panel
      • Create Function: Option List (2/2) panel
      • Create Function panel
      • Create Function: Parameter Types panel
      • Create Function: Parameters panel
      • Create Function: Returned Data Type panel
      • Create Index panel
      • Create Index: Allocation panel
      • Create Index: Column Selection panel
      • Create Index: Options panel
      • Create Index: Partitions panel
      • Create Index: Partition Values panel
      • Create Index: Type panel
      • Create Procedure panel
      • Create Procedure: Option List (1/2) panel
      • Create Procedure: Option List (2/2) panel
      • Create Procedure: Parameter Types panel
      • Create Procedure: Parameters panel
      • Create Synonym panel
      • Create Table panel
      • Create Table Space panel
      • Create Table Space: Allocation panel
      • Create Table Space: Data Sharing Options panel
      • Create Table Space: Data Storage Options panel
      • Create Table Space: Define Partitions panel
      • Create Table Space: Locking Options panel
      • Create Table Space: Type panel
      • Create Table: Column Check Constraints panel
      • Create Table: Column Referential Constraints panel
      • Create Table: Columns panel
      • Create Table: Generate Values panel
      • Create Table: Model Load panel
      • Create Table: Nulls and Default Values panel
      • Create Table: Options panel
      • Create Table: Procedure Exits panel
      • Create Table: Table Check Constraints panel
      • Create Table: Table Referential Constraint panel
      • Create Table: Table Referential Constraints panel
      • Create Table: Unique Constraints panel
      • Create Trigger panel
      • Create Trigger: Details panel
      • Create Trigger: Search Condition panel
      • Create Trigger: SQL statement panel
      • Create View panel
      • Create View Source Statements panel
      • Data Create Utility panel
      • Database Request Modules panel
      • Database Structure panel
      • Databases panel
      • Db2® Browse panel
      • Db2® Edit panel
      • Db2® Location Selection panel
      • Db2® Object Functions panel
      • Db2® Save Error Action panel
      • Db2® Subsystem Selection panel
      • Db2® Template Description panel
      • Db2® Utilities panel
      • Db2® View panel
      • Db2I Primary Option Menu panel
      • Details panels
      • Display Row panel
      • Distinct Types panel
      • Drop panels
      • Drop Confirmation panel
      • Edit/Execute SQL (Data Set) panel
      • Editor Options (1 of 8) panel
      • Editor Options (2 of 8) panel
      • Editor Options (3 of 8) panel
      • Editor Options (4 of 8) panel
      • Editor Options (5 of 8) panel
      • Editor Options (6 of 8) panel
      • Editor Options (7 of 8) panel
      • Editor Options (8 of 8) panel
      • Enter and Execute Db2® Commands panel
      • Enter, Execute and Explain SQL Statements panel
      • EXPLAIN Interpretation panel
      • Explain Utilities panel
      • Export Options (1 of 3) panel
      • Export Options (2 of 3) panel
      • Export Options (3 of 3) panel
      • Export Utility ("From") panel
      • Export Utility ("To") panel
      • Field Selection/Edit panel
      • FM/Db2 Release News panel
      • Foreign Keys for Table panel
      • Free Application Plan panel
      • Free Package panel
      • From Column Mapping panel
      • Functions panel
      • Generate SQL From Db2® Catalog panel
      • Grant privileges panels
      • Import Options panel
      • Import Utility ("From") panel
      • Import Utility ("To") panel
      • Index Parts panel
      • Indexes panel
      • Indexes and Columns for panel
      • ISPF Primary Option panel
      • ISPF Settings panel
      • Label Column panel
      • Label Table panel
      • LISTCAT Output Display panel
      • LISTDEF Options panel
      • LOAD from panel
      • LOAD Utility panel
      • LOAD Utility panel using Db2® templates
      • LOAD Utility - Using Templates panel
      • LOAD Utility Options panel
      • Manage Db2® Privileges panel
      • Object List Line Commands panel
      • Object List Options (1 of 2) panel
      • Object List Options (2 of 2) panel
      • Object List Utility panel
      • OPTIONS Options panel
      • Package Dependencies panel
      • Package List panel
      • Parents of Table panel
      • Partitioned Table Statistics panel
      • Plan Dependencies panel
      • Plan Enabled/Disabled Connections panel
      • Plan Table Rows panel
      • Primary Key for Table panel
      • Primary Option Menu panel
      • Print Audit Trail panel
      • Print Utility Options panel
      • Print Utility panel
      • Privilege details panels
      • Privileges panels
      • Rebind Application Plan panel
      • Rebind Package panel
      • REBUILD (Indexes for Table Spaces) panel
      • REBUILD (Indexes for Table Spaces) with LISTDEF panel
      • REBUILD Utility (Indexes) panel
      • REBUILD (Indexes) with LISTDEF panel
      • Record Type Selection panel
      • RECOVER Utility (Index Spaces) panel
      • RECOVER Utility (Index Spaces) with LISTDEF panel
      • RECOVER Utility (Table Spaces) panel
      • RECOVER Utility (Table Spaces) with LISTDEF panel
      • Recovery Information panel
      • Related tables panel
      • Remote Db2® Location Selection panel
      • REORG Utility (Indexes) panel
      • REORG Utility (Indexes) with LISTDEF panel
      • REORG Utility (Table Spaces) panel
      • REORG Utility (Table Spaces) with LISTDEF panel
      • Revoke privileges panels
      • Routine Parameters panel
      • Row Selection Criteria panel
      • RUNSTATS Utility (Indexes) panel
      • RUNSTATS Utility (Indexes) with LISTDEF panel
      • RUNSTATS Utility (Table Spaces) panel
      • RUNSTATS Utility (Table Spaces) with LISTDEF panel
      • Schemas panel
      • Scramble Exit Specification panel
      • Select Statement Browse panel
      • Select Statement Edit panel
      • Sequences panel
      • Set Batch Job Card Information panel
      • Set COBOL Processing Options panel
      • Set HLASM Processing Options panel
      • Set Optimizer Hint panel
      • Set Output Data Set Allocation Options panel
      • Set PL/I Processing Options panel
      • Set Print Processing Options panel
      • Set Processing Options panel
      • Set System Processing Options panel
      • Set Temporary Data Set Allocation Options panel
      • Set Trace options panel
      • Set Utility Options panel
      • Sort Fields panel
      • SQL Prototyping, Execution and Analysis panel
      • Statement Table Rows panel
      • Storage Group(s) panel
      • Storage Group Usage Privileges panel
      • Stored Procedures panel
      • Synonym Dependencies panel
      • Synonyms panel
      • Systems Options (1 of 4) panel
      • Systems Options (2 of 4) panel
      • Systems Options (3 of 4) panel
      • Systems Options (4 of 4) panel
      • Table Browse panel
      • Table Check Constraint Dependencies panel
      • Table Check Constraint Details panel
      • Table Check Constraints panel
      • Table Edit panel
      • Table Edit (related) panel
      • Table Selection panel
      • Table Space Parts panel
      • Table Spaces panel
      • Table View panel
      • Table/View/Alias Selection panel
      • Tables, Views and Aliases panel
      • TEMPLATE Options (1 of 2) panel
      • TEMPLATE Options (2 of 2) panel
      • Template Mapping panel
      • Template Save panel
      • Triggers panel
      • UNLOAD Options panel
      • UNLOAD Utility (Table Spaces) panel
      • UNLOAD Utility (Table Spaces) with LISTDEF panel
      • UNLOAD Utility (Tables) "From" panel
      • UNLOAD Utility (Tables) "To" panel
      • UNLOAD Utility (Tables) with LISTDEF panel
      • Utility Functions panel
      • Value List Edit panel
      • Volumes panel
    • FM/Db2 commands
    • FM/Db2 functions

Select Statement Edit panel

FM/Db2 displays the Select Statement Edit panel if the Use edit (instead of browse) to display results option is selected, and you press Enter when one of these panels is displayed:
  • Basic SELECT Prototyping panel
  • Advanced SELECT Prototyping panel

Related tasks

  • Systems Options (1 of 4) panel

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.

Rate this topic


To add feedback about this topic, select the following checkbox:
  • Share: Email
  • Twitter
  • Disclaimer
  • Privacy
  • Terms of use
  • Cookie Preferences