User Parms Menu

Select option 0, Defaults and User Parms from the Primary Option Menu. The User Parms menu displays (see the following figure). From this menu, you can select the set of parameters you want to modify.

User Parms Menu

File-AID for Db2 ----------------- User Parms ---------------------------------
OPTION ===>                                                    Scroll ===> PAGE

Db2 Subsystem: DSN           ===> DSN                    Db2 Version: 12.1.5
Current SQLID: FDDBA         ===> FDDBA                FADb2 Version: 21.1.0
Current SCHEMA: TSOID01      ===> USER                  SQLP Version: 21.1.0
                                                          FM Version: R2.1
Display CCSID Warning (when SSID is switched)   ===> Y (Y/N)
Display Unicode Warning (in Copy/Extract/Load) ===> Y (Y/N)
Display XLOB Character Conversion Warning (in Browse/Edit) ===> Y (Y/N)

               1   Browse/Edit/SQL Analysis Display Options
               2   Dataset Allocation
               3   Batch Options
               4   Not Used
               5   Object Administration Default Values
               6   Logging Options
               7   Print Options
               8   Special Register Values
               9   Trigger Terminator

Db2 Subsystem

The first value next to the field name is the current Db2 subsystem and is display only. The subsystem is modified by typing over the value to the right of the arrow and pressing Enter. If the Db2 subsystem is modified, the File-AID for Db2 plan name is also changed to the subsystem’s default plan name defined when the product is installed.

Db2 Version

Version of Db2 you are using. Display only.

FADb2 Version

Version of File-AID for Db2 you are using. Display only.

Current SQLID

The first value next to the field name is the current SQLID and is display only. You can change the SQLID by typing over the value to the right of the arrow, and pressing Enter.

Current SCHEMA

The first value next to the field name is the current SCHEMA and is display only. You can change the SCHEMA by typing over the value to the right of the arrow, and pressing Enter.

Important

Current SCHEMA is a scrollable field. You can use the EXPAND command to scroll through the field.

SQLP Version

Version of the SQL processor you are using. Display only.

FM Version

Version of the Function Manager you are using. Display only.

Display CCSID Warning (when SSID is switched)

Displays the CCSID Warning Window, when your current terminal CCSID and Db2 subsystem default CCSID are different. Refer to CCSID Warning Window for more information.

- Specify Y to display the CCSID Warning Window.
- Specify N to suppress the CCSID Warning Window.

Display Unicode Warning (in Copy/Extract/Load)

Displays the Warning for Unicode Data Window, when a table to be extracted or copied includes Unicode data and your CCSID is different from Db2’s. Refer to Warning-for-Unicode-Data for more information.

- Specify Y to display the Warning for Unicode Data Window.
- Specify N to suppress the Warning for Unicode Data Window.

Display XLOB Character Conversion Warning (in Browse and Edit)

Displays the XLOB: Warning - Character Conversion Window, when the selected LOB column includes data that requires character conversion. Refer to Warning for XLOB Character Conversion for more information.

- Specify Y to display the XLOB: Warning - Character Conversion Window.
- Specify N to suppress the XLOB: Warning - Character Conversion Window.