Browse/Edit/SQL Analysis Display Options

The Browse/Edit/SQL Analysis Display Options (Browse/Edit/SQL Analysis Display Options screen (Part 1) and Browse/Edit/SQL Analysis Display Options screen (Part 2)) screens are displayed when you select option 1 from the User Parms menu. They let you specify the Browse, Edit, and SQL Analysis display options.

Browse/Edit/SQL Analysis Display Options screen (Part 1)

Primary, Foreign and Unique Key Options Area

Allow update of primary key in edit

Specify ON to update primary keys during an edit session. This option can also be set with the PROFILE primary command.

Indicate foreign key columns while in edit

Specify ON to highlight foreign keys during an edit session. This option only applies to local tables. Because Db2 does not maintain an index on the table containing foreign key information, setting this option to ON may have a negative impact on performance. This option can also be set with the PROFILE primary command.

Retrieve UNIQUE KEY information prior to edit

Specify ON to retrieve unique key information before the edit session begins. This applies only if there is no primary key. This option only applies to local tables.

Commit Options in Edit Area

AUTOCOMMIT commits changes upon pressing enter

Specify ON to commit changes each time you press Enter during an edit session. This option can also be set with the PROFILE primary command.

AUTOSAVE commits changes upon exiting session

Specify ON to save changes each time you press END during an edit session. This option can also be set with the PROFILE primary command during a browse or edit session.

Lowercase Support for Object Names Browse/Edit

Object names are converted to uppercase

Specify ON to automatically convert all object names entered in lowercase characters to uppercase characters. Specify OFF if you need to edit a table with a DBCS table name or DBCS column name. This option can also be set with the PROFILE primary command.

Lowercase Support for Data in Browse/Edit/SQL Analysis Area

Data is converted to uppercase

Specify ON to automatically convert all data entered in lowercase characters to uppercase characters.

Row Selection Option Area

Maximum Rows to Select

Specify a numeric value or an asterisk (*) to denote the maximum number of rows to be selected for an edit/browse session or a table extract. The value may be changed for individual edit or browse sessions, (Maximum Rows to Select) or table extracts (Maximum Rows to Select).

Identity Column Options Area

Allow update of Identity Columns in edit

Specify ON to allow update of identity columns in edit. This option can also be set with the PROFILE primary command. This applies only to columns set to GENERATED BY DEFAULT. Columns set to GENERATED ALWAYS cannot be edited. If the column is both an identity column and a primary key, then ALLOW UPDATE OF PRIMARY KEY IN EDIT must also be ON to edit the column.

Column Length Display Limit Option Area

Maximum Column length display

Specify the maximum display width of columns for a browse/edit session. This option only applies to the following column data types: CHAR, VARCHAR, LONG VARCHAR, GRAPHIC, VARGRAPHIC, LONG VARGRAPHIC, BLOB, CLOB, and XML. The value can be an even number or OFF (the default is OFF). See also MAXCOL.

Browse/Edit/SQL Analysis Display Options screen (Part 2)

Null Handling Options Area

Null Display Character

Specify the character that displays for null columns. This option can also be set with the PROFILE primary command.

Null Entry Character

Specify the character that, when entered, sets a column to null. You must enter the null entry character in the first position of the column for it be converted to nulls. If the character is not entered in the first position, it is accepted as the actual character and not converted to nulls. If the column is defined as NOT NULL, the null entry character is also accepted as the actual character and not converted. This option can also be set with the PROFILE primary command.

Spaces imply null in character columns

Specify ON to have spaces imply nulls for character columns. This can also be set with the PROFILE primary command.

Variable Length Options Area

End of variable length column character

Specify the character used to signal the end of a column. This option can also be set with the PROFILE primary command.

Truncate trailing spaces on insert/update

Specify ON to truncate trailing spaces on an insert or update. This option can also be set with the PROFILE primary command.

Distinct Type Autocast Options Area

Allow Autocast

Indicates whether File-AID for Db2 should automatically cast a distinct type field to its source data type and scale. Specify Y to apply automatic casting to the field on the left-hand side of a WHERE clause if and only if the WHERE clause contains no fields that are DISTINCT types. Specify N if you do not want automatic casting to occur. This applies to edit, browse, copy, and extract/load.

Issue warning before Autocast

Specify Y to display a warning in a window before applying the cast. The window asks whether the cast should be applied and whether the warning should appear in the future.

LOB Options Area

Maximum size LOB data retrieved

Specify the maximum byte size of LOB data that can be retrieved in a table being browsed or edited. The setting only affects BLOB, CLOB, DBCLOB, and XML data types. Valid values are 2 through 4096. The value must be even and cannot exceed your site configured LOB_MAXIMUM_DATA_RETRIEVED size. For more information, see LOB_MAXIMUM_DATA_RETRIEVED in the File-AID for Db2 product configuration.

Other Options Area

Insert default for date/time/timestamp

Specify 1 for local or 2 for GMT (Greenwich Mean Time) to determine the date/time format used as the default during inserts and when CURRENT is used to enter a date/time field. This option can also be set with the PROFILE primary command.

Non-displayable data character

Specify the character used to signify nondisplayable data when in browse mode. Does not apply for edit mode (NON-DISPLAY). This option can also be set with the PROFILE primary command.

Issue warning if SQL cannot be parsed

Specify Y to display a warning in a window if SQL for existing criteria cannot be parsed into the Template Selection screen (Edit Selection Template). If N is specified, then File-AID for Db2 will proceed with the action last specified in the warning window, either Execute SQL or Edit SQL.

Enable Predictive Governor Warning

This option allows you to specify how File-AID for Db2 should respond when Db2 executes an SQL statement that exceeds the limit set up by RLIMIT when the Db2 Resource Limit Facility is activated for a subsystem. Refer to the IBM Db2 documentation for more information on the Db2 Resource Limit Facility (governor).

Valid values

Y
Will issue the Predictive Governor Warning prompt when an SQL 495 is returned which then allows you to decide whether or not to proceed with execution.

N
Ignores the 495 warning and will execute the SQL statement.

P
(default) Uses the value set for the current subsystem with the Db2 environment parameter DB2_ENABLE_PREDICTIVE_GOVERNOR_WARNING in PARMLIB member FADEnnnn (see also DB2_ENABLE_PREDICTIVE_GOVERNOR_WARNING in the Db2 environment).

Setting this option to Y or N will override the value defined for the Db2 subsystem with the Db2 environment parameter DB2_ENABLE_PREDICTIVE_GOVERNOR_WARNING.

Predictive Governor Warning Window

When Db2 executes an SQL statement that exceeds the limit set up by RLIMIT, an SQL 495 is returned and File-AID for Db2 displays the Predictive Governor Warning Window (see the following figure) as long as the Predictive Governor Warning has been enabled.

Predictive Governor Warning

Continue Process (Yes/No)

Decide whether to execute the SQL statement or cancel it.

Y = Continue the operation.

N = Cancel the operation.