Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL Informix® database servers.
DB-Access User's GuideThe Informix® DB-Access User's Guide describes how to use the DB-Access utility to access, modify, and retrieve information from Informix® database servers.
The full-screen menu interfaceThe DB-Access full-screen menu interface guides you through running SQL statements.
The Query-language optionUse the Query-language option to enter, modify, save, retrieve, and run SQL statements. DB-Access retains the statements, if any, in the editor. These statements are called the current statements.
What happens when errors occurIf you make any syntax or typing mistakes in an SQL statement, DB-Access does not process the statement. Instead, it continues to display the text of the statement with a message that describes the error.

What happens when errors occur

If you make any syntax or typing mistakes in an SQL statement, DB-Access does not process the statement. Instead, it continues to display the text of the statement with a message that describes the error.

If an execution or runtime error occurs, DB-Access continues to process the statement and returns an error message. For example, if you try to create a table that was already created, the following message is displayed at the bottom of the screen:

310: Table (mavis.mystock) already exists in database.

If you try to run a statement that contains more than one SQL statement, you might not see an error message immediately. If, for example, the first statement is a SELECT statement that runs correctly and the next statement contains a typing error, the data that the first statement retrieved shows on the screen before the error message is displayed for the second statement.

When DB-Access detects an error, processing stops and the Modify option on the SQL menu is highlighted. Select one of the following methods to correct the statement:

Press Enter to choose Modify, which returns you to the SQL editor.
Select the Use-editor option to use the default editor of your choice.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.