Online Documentation for SQL Query for DB2

Setting database options

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


hs3262 - Setting database options


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


CheckBox Login Prompt

Check this option if you wish to be prompted for authorization information (User name and Password) each time you connect to the DB2 database.


CheckBox Show System Objects

If this option is checked, system objects of the database are displayed in DB Explorer.


CheckBox Autoconnect on Startup

Setting this option enables connection to the database automatically when the application is started.