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.

Syntax

dbaccess [ -ansi ] [ -X ] { database [ @server ] [ { -q [ <QUERY-LANGUAGE menu options> (explicit id ) ] [ { filename | table } ] | -t [ <TABLE menu options> (explicit id ) ] [ table ] } ] | -d [ <DATABASE menu options> (explicit id ) ] | -c [ <CONNECTION menu options> (explicit id ) ] | -s | [ { -e | -m } ] { database | - } filename } [ -a ] [ { (explicit id ) | -version | -V | -history } ]

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

-ansi
Causes DB-Access to generate a warning whenever it encounters Informix® extension to ANSI-compliant syntax. For more information, see Example: Check for ANSI compliance.
-a
Stops a process directly after the first error is encountered. Stopping a process from continuing after the first error can ensure greater database consistency.
-c
Starts with the CONNECTION menu as the top-level menu.
-d
Starts with the DATABASE menu as the top-level menu.
-e
Echoes each line from a command file designated by filename.
-history
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.
-m
Displays all error messages generated by multiple levels of the server that pertain to an SQL statement in command files.
-q
Starts at the query-language menu (SQL-menu) as the top-level menu.
-s
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.

-t
Starts at the TABLE menu as the top-level menu.
-V
Displays the version number and serial number for DB-Access without launching the application. You cannot use any other options with -V.
-version
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.
-X
Activates the hexadecimal format for LOAD and UNLOAD statements.
database
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.
filename
Names a command file to load with the SQL menu.
server
Name of the database server.
table
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.

5 Cannot be combined with any other option.