dbaccess command: Start DB-Access

Use the dbaccess command to start DB-Access. Include options to specify the database, command files, or to go to a specific menu screen.


Read syntax diagramSkip visual syntax diagram
             '- -ansi-'  '- -X-'   

   |           '-@--server-'  +- -q--+-------------------------------------+--+----------+-+ |   
   |                          |      |                                 (1) |  +-filename-+ | |   
   |                          |      '-| QUERY-LANGUAGE menu options |-----'  '-table----' | |   
   |                          '- -t--+----------------------------+--+-------+-------------' |   
   |                                 |                        (2) |  '-table-'               |   
   |                                 '-| TABLE menu options |-----'                          |   
   +- -d--+-------------------------------+--------------------------------------------------+   
   |      |                           (3) |                                                  |   
   |      '-| DATABASE menu options |-----'                                                  |   
   +- -c--+---------------------------------+------------------------------------------------+   
   |      |                             (4) |                                                |   
   |      '-| CONNECTION menu options |-----'                                                |   
   +- -s-------------------------------------------------------------------------------------+   
     +- -e-+  '- - ------'                                                                       
     '- -m-'                                                                                     

   '- -a-'      +- -version-+   
                +- -V-------+   
                '- -history-'   

  1. See QUERY-LANGUAGE menu options.
  2. See TABLE menu options.
  3. See DATABASE menu options.
  4. See CONNECTION menu options.
  5. Cannot be combined with any other option.

The dbaccess command without options starts the main menu with no database selected and no options activated. You select submenus from the main menu.

Causes DB-Access to generate a warning whenever it encounters HCL Informix® extension to ANSI-compliant syntax. For more information, see Example: Check for ANSI compliance.
Stops a process directly after the first error is encountered. Stopping a process from continuing after the first error can ensure greater database consistency.
Starts with the CONNECTION menu as the top-level menu.
Starts with the DATABASE menu as the top-level menu.
Echoes each line from a command file designated by filename.
Can be abbreviated to -his. Displays the previous commands that you ran from the dbaccess command line during the current session. Commands that you ran from the menu interfaces are not shown. Each command is numbered. In the interactive mode without menus, you can rerun previous commands with the following command:
run number
The number is the number of the command to run. For an example, see Run DB-Access in interactive mode without menus.
Displays all error messages generated by multiple levels of the server that pertain to an SQL statement in command files.
Starts at the query-language menu (SQL-menu) as the top-level menu.
Connects you to the main DB-Access menu and displays information about the current session.

This information includes database server name, database server type, the host computer, server capabilities, and other settings.

Starts at the TABLE menu as the top-level menu.
Displays the version number and serial number for DB-Access without launching the application. You cannot use any other options with -V.
Displays the version number and build information for DB-Access, including the GLS library version, without launching the application. You cannot use any other options with -version.
Activates the hexadecimal format for LOAD and UNLOAD statements.
Name of the database that you want DB-Access to connect to at the startup of your current session. A hyphen (-) indicates that the database is specified in a DATABASE statement in a command file.
Names a command file to load with the SQL menu.
Name of the database server.
Specifies a table in the database.

If you exit from a submenu or option that you specified from the command line, you will exit directly to the operating-system command line.

Copyright© 2018 HCL Technologies Limited