AcuODBC User's Guide
Version 6.0

5.1 Writing Queries to Access Data

ODBC programs retrieve data through Structured Query Language (SQL). Although many Windows applications let you use Microsoft Query to generate SQL queries transparently, others require you to generate the SQL yourself. In some instances, you may want to generate your own SQL queries even for applications that could otherwise use MS Query. For example, you might want to perform functions that MS Query does not allow, such as generating a complex set of instructions for a custom query and displaying the result in a formatted dialog box.

This chapter gives you information you need to write your own queries (also known as commands or statements) for accessing COBOL data from ODBC-enabled applications. It describes what to consider when writing queries and explains which SQL queries are supported by the AcuODBC® interface.

To understand the concepts in this chapter, you must have a minimum knowledge of the BASIC language, because many Windows application languages have a BASIC-like syntax. Before you begin, you should verify that the application from which you want access to COBOL data is ODBC-enabled.

Caution: To safeguard your system, we recommend that you perform all custom programming functions on a dedicated development machine.

Acucorp, Inc.
Voice: (800) 262-6585 (U.S.A. and Canada)
Voice: (858) 689-4500
Fax: (858) 689-4550

Please share your comments on this manual
or on any Acucorp documentation with the
Acucorp Communications Department.
© 1988-2003 Acucorp, Inc.
All rights reserved.