DB–Access utility provides a user interface and is used to access, modify, and retrieve information from Informix database servers.
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.
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.