Accessing TurboIMAGE/XL Data with ISQL

This task briefly describes how IMAGE/SQL users access TurboIMAGE/XL data with ISQL.

Getting Ready

To successfully select TurboIMAGE/XL data with ISQL, IMAGE/SQL users need to know the following:

How to use the IMAGE/SQL interface provided for them. The examples in this manual use ISQL, which also requires familiarity with the SQL SELECT statement.
The names of the mapped tables and/or views to which they have access (see Task Reference).
Which columns map to TurboIMAGE/XL search items. Under certain circumstances, using these mapped columns when selecting data can improve performance (see Task Reference).
Which data is of type FLOAT. When selecting this data, users should specify a range of values rather than a particular number. This is necessary because some precision is lost when converting to FLOAT.

Performing the Task

Because data has not yet been added to the MUSIC database, using a SELECT statement at this point would not demonstrate its use. If you want to see SELECT statements using the MUSIC database, see the section "Selecting Data" in Chapter 6, "Practicing with IMAGE/SQL Using MusicDBE."

Task Reference

The structure of the TurboIMAGE/XL database cannot be changed with SQL statements. Therefore, SQL statements that alter the structure of the database are not available to IMAGE/SQL users.
When users have access to the entire data entry, they can select data from the table itself. If they do not have access to the entire data entry, they must select data from a view of the table created for them by IMAGE/SQL. Table names are of the form OwnerName.MappedTableName. View names are of the form OwnerName.MappedTableName_VUserClass#.
For examples of using the SELECT statement on the MUSIC database, refer to Chapter 6, "Practicing with IMAGE/SQL Using MusicDBE."
For detailed information about using the SELECT statement, refer to the ALLBASE/SQL Reference Manual.

Accessing TurboIMAGE/XL Data with ISQL

Technical documentation

» Table of Contents

» Glossary

» Index