Selecting columns

To select which columns are displayed in a File Manager/Db2 editor session, use the Column Selection/Edit panel. Selected columns are displayed with an S in the S column. To toggle between selecting and deselecting a column, enter S in the Cmd column of the Column Selection/Edit panel.

By default, FM/Db2 selects all of the columns in the Db2® object for display, in the order that they are defined to Db2®. The initial display shows all columns as selected, with the exception of any ROWID column.

Note: Deselecting a column does not alter the SQL statement that FM/Db2 uses to retrieve data from Db2®. In a File Manager/Db2 editor session, FM/Db2 always generates an SQL statement that specifies every column in the Db2® object.