Home |
Previous Page | Next Page Getting Started with DB-Access >
DB–Access provides a user interface for entering, executing,
and debugging Structured Query Language (SQL) statements and
Stored Procedure Language (SPL) routines.
SQL and SPL allow you to perform
data-definition tasks, such as specifying the number and type of
data columns in a table, and data-management tasks, such as storing,
viewing, and changing table data. The DB–Access interface allows you
to apply powerful Informix extensions to SQL and SPL.
You can use DB–Access for the following aspects of database
processing:
- Using ad hoc queries that you execute infrequently
- Connecting to one or more databases, transferring data between
the database and external text files, and displaying information
about a database
- Displaying system catalog tables and the Information Schema,
which are explained in the IBM Informix: Guide to SQL Reference
- Practicing the statements and examples provided in the IBM Informix: Guide to SQL Tutorial or the IBM Informix: Database Design and Implementation Guide
- Testing applications that you intend to store for use in a production environment
Important:
DB–Access is not intended as an application-development environment.
You branch conditionally or loop through SQL statements when
you run them within DB–Access.
Home |
[ Top of Page | Previous Page | Next Page | Contents |
Index ]