HP 3000 Manuals HP 3000 Manuals
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.