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