Online Documentation for SQL Manager for DB2

Common options


The Options section of the Database Registration Info dialog allows you to set various options for the database.

 

Database Registration Info - Setting common database options

 

 

Customize common database options according to your needs. The detailed description is given below.

 

CheckBox Login prompt before connection

Enables SQL Manager for DB2 to prompt for user name and password each time you connect to the database.

 

CheckBox Autoconnect at startup

Check this option to specify that SQL Manager for DB2 automatically establishes connection to the registered database at application startup.

 

CheckBox Show system objects

This option determines whether DB2 system objects are displayed in the DB Explorer tree.

 

CheckBox Refresh objects on connection

This option allows you to enable/disable refreshing objects on connection to the database. It is highly recommended to uncheck this option if your database contains many objects or if connection to the database is slow.

 

CheckBox Always capitalize database object names

All new object names are capitalized if the option is enabled. New object names can't contain small letters until the option is disabled.