The Query-language option

Use 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.

Use the Query-language option to:
  • Learn SQL and SPL.

    For example, use the Query-language option to practice the examples in the IBM® Informix® Guide to SQL: Tutorial.

  • Create and alter table structures as an alternative to the DB-Access Schema Editor.
  • Select, display, add, update, and delete data.
The SQL menu has the following options.
Option Purpose
New Clears current statements and positions cursor in SQL editor.
Run Runs current SQL statements. A message is displayed or the data that is retrieved by a query is displayed with the number of rows retrieved.
Modify Allows you to modify current SQL statements in SQL editor.
Use-editor Starts a system editor so that you can modify current statements or create new statements. Use-editor is interchangeable with New and Modify.
Output Redirects Run-option output to a file, printer, or system pipe.
Choose Lists SQL command files so that you can choose a file to run or modify.
Save Saves current SQL statements in a file for later use.
Info Shows table information, such as columns, indexes, privileges, constraints, triggers, status, and fragmentation strategy.
Drop Deletes a specified SQL command file.
Exit Returns to main menu.

Copyright© 2018 HCL Technologies Limited