User profile defaults

Option

Description

AUTOCOMMIT

Specify ON to commit changes each time you press Enter during an Edit session.

AUTOSAVE

Specify ON to save changes each time you press END (PF3) during an Edit session.

CAPS

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

OBJECT NAMES UPPERCASE

Specify ON to automatically change all object names entered in lowercase characters to uppercase characters.

MAXROWS

Specify a numeric value or an asterisk (*) to denote the number of rows to be selected. You can also change this value for individual Browse or Edit sessions.

NON-DISPLAY

NULL ENTRY

Specify the character that, when entered, sets a column to null.

NULL DISPLAY

Specify the character that appears for null columns.

SPACES IMPLY NULL

Specify ON to have spaces imply nulls for character columns.

VARIABLE LENGTH MARK

Specify the character used to indicate the end of a column.

UPDATE PRIMARY KEY

Specify ON to update primary keys during an Edit session.

SHOW FOREIGN KEYS

Specify ON to show foreign keys during an Edit session. Foreign Key information is only shown for 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.

VARIABLE LENGTH TRUNCATE

Specify ON to truncate trailing spaces on an insert or update during an Edit session.

INSERT DT/TM/TS TRUNCATE

Specify date/time format used as a default value when you enter date, time, or timestamp in NOT NULL WITH DEFAULT field by using CURRENT. Specify Local or GMT (Greenwich Mean Time).

RETRIEVE UNIQUE KEY INFO

Specify ON to retrieve unique key information before the Edit session begins. This value applies only if there is no primary key. Unique key information is only retrieved for local tables.

REPEAT COMMAND PROMPT

Specify ON to display the REPEAT Column Range Specification window for the REPEAT primary or line command. Specify OFF to suppress the pop-up window. Does not apply when editing Unicode table data.

UPDATE IDENTITY COLUMN

Specify ON to allow update of identity columns in edit. 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 UPDATE PRIMARY KEY must also be ON to edit the column.

MAX SIZE LOB 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.