DB–Access utility provides a user interface and is used to access, modify, and retrieve information from Informix database servers.

Starting dbaccess

dbaccess is located in /usr/informix/bin/. This path should be included in the $PATH variable.
In a UNIX/LINUX environment, the database server must have the appropriate terminal set up from among those listed in the INFORMIXTERM environment variable.
If the TERM, TERMCAP, or TERMINFO environment variables do not enable DB–Access to recognize the type of terminal you use, the main menu does not appear.

Main Menu


For using SQL query language.


Connect or disconnect from a database environment.


Select, Create, Info, Drop or Close a database.


Create, Alter, or Drop a database table.


Retrieve information about the current DB-Access session.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-Share Alike 2.5 License.