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:
- -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.
2 See TABLE menu options.
3 See DATABASE menu options.
4 See CONNECTION menu options.
5 Cannot be combined with any other option.