HP 3000 Manuals HP 3000 Manuals
Index
A
access
interactive
programmatic
to a database
accounts
attaching from different
adding data to the sample database
ALLBASE/NET
component of IMAGE/SQL
ALLBASE/SQL
DBA authority, when to grant
DBEFILE0, size considerations
DBELOG1, size considerations
DBEnvironment, setting a maintenance word
defined
ATC
defined
ATCINFO file
maintaining
reference information for
setting a file equation for
when purged
ATCLOG file
reference information for
setting a file equation for
attaching a TurboIMAGE/XL database
example of
getting ready
three commands required for
when DBEnvironment is in different account
with same name as one already attached
attributes
defined
authority
defined
in IMAGE/SQL
in the sample DBEnvironment
authorization group
defined
in the sample DBEnvironment MusicDBE
automatic master set
B
base table
defined
basic mapping
batch
using IMAGE/SQL utility command files in
benefits of IMAGE/SQL
C
CHAR data types
check constraint
defined
class
defined
column
corresponding TurboIMAGE/XL term
defined
in a relational database table
column authorization
defined
described
column list
defined
command files
COMMIT WORK
example
why necessary
compound items
concurrency
defined
when accessing
configuring a DBEnvironment
DBE file size considerations
example of
getting ready
when TurboIMAGE/XL database is in different account
CONNECT
constraint
defined
creating
a database
DBEnvironment
D
data
adding to a database
deleting
modifying
data analysis
basic explanation
defined
database
accessing
access in IMAGE/SQL and TurboIMAGE/XL
adding data
administrator
administrator (DBA), defined
administrator (DBA), explained
controlling access
creating
creating a TurboIMAGE/XL
creator
defined
design, basic explanation
design, defined
example
explained
in IMAGE/SQL and TurboIMAGE/XL
setting up with ISQL
data control language
defined
explained
data entities
data item
corresponding IMAGE/SQL term
data manipulation
defined
example
data manipulation language
defined
data set
corresponding IMAGE/SQL term
defining
differences from IMAGE/SQL table
data type
defined
mapping
DB01 file
corresponding IMAGE/SQL term
DB02 file
corresponding IMAGE/SQL term
DB03 file
corresponding IMAGE/SQL term
DBA authority
defined
explained
DBaseNameTC file
when purged
DBC
database creator
DBC authority
DBECon file
corresponding TurboIMAGE/XL term
defined
differences from TurboIMAGE/XL root file
explained
name and content
DBECreator
defined
explained
DBEFile
corresponding TurboIMAGE/XL term
explained
DBEFile0
DBEFile containing system catalog
name and content
DBEFileset
explained
DBEFileSets
defined
explained
DBEnvironment
basic explanation
corresponding TurboIMAGE/XL term
creating
default files in
defined
differences from TurboIMAGE/XL
explained
starting
DBEnvironment-nameCR
DBEUserID
corresponding TurboIMAGE/XL term
defined
DBLOCK intrinsic
DBSCHEMA
DBUTIL
DECIMAL data types
default values
DELETE
deleting
data
detaching a TurboIMAGE/XL database
example of
getting ready
reasons for
reference information for
detail data sets
detail set
DISPLAY commands
two options
displaying IMAGE/SQL utility information
displaying DBEnvironment information
displaying TurboIMAGE/XL database information
displaying TurboIMAGE/XL database mapping
displaying user information
getting ready
DISPLAY MAP
DISPLAY OPTIONS
DISPLAY SQLDBE
DISPLAY TURBODB
DISPLAY USER
E
embedded SQL programming
defined
entities
defined
entry
corresponding IMAGE/SQL term
environment
explicit locking
defined
expression
defined
F
file equations
examples of setting
reference information for
setting for ATCINFO
setting for ATCLOG
files
DBECon file
DBEFile0
default in a DBEnvironment
log file
FLOAT data types
G
getting ready for
detaching a TurboIMAGE/XL database
displaying IMAGE/SQL utility information
maintaining the ATCINFO file
selecting TurboIMAGE/XL data with ALLBASE/SQL
using IMAGE/SQL utility command files
getting started with IMAGE/SQL
configuring a DBEnvironment
GRANT
authorities
statement
group
defined
defining
in the sample DBEnvironment MusicDBE
H
HELP
HP PC API
component of IMAGE/SQL
for ALLBASE/SQL and IMAGE/SQL
I
IMAGE/SQL
and ALLBASE/SQL
basic concepts
basic structure
benefits
command
compared with TurboIMAGE/XL
components
defining groups
defining views
environment
introduction
locking
permissions
sample DBEnvironment
tasks
tools
IMAGE/SQL utility
component of IMAGE/SQL
displaying information about
example of using in batch mode
example of using interactively
issuing commands
logging commands
prerequisites for issuing
setting up a database
implicit locking
defined
INFO
INSERT
INTEGER data types
integrity constraint
defined
interactive access to data
in IMAGE/SQL and TurboIMAGE/XL
isolation level
defined
ISQL
accessing TurboIMAGE/XL data
component of IMAGE/SQL
defined
how to run
setting up a database
item part of TurboIMAGE/XL database
J
joining
defined
K
key
defined
L
LOAD
description
EXTERNAL option
INTERNAL option
locking
defined
mechanisms in IMAGE/SQL and TurboIMAGE/XL
log file
defined
name and content
logging
defined
explained
logging IMAGE/SQL utility commands
example of
reference information for
logical data entities
M
maintaining the ATCINFO file
example of
getting ready
reference information for
maintenance word
setting a DBEnvironment
when needed
manual master set
mapping of data types
master data sets
master set
modifying data
MPE/iX
commands issued from the IMAGE/SQL utility
security rules enforced
N
names
differences between TurboIMAGE/XL and IMAGE/SQL
naming conventions
NOT NULL
null values
O
object
defined
in an IMAGE/SQL DBEnvironment
owner
defined
P
password
corresponding IMAGE/SQL term
part of TurboIMAGE/XL database
PC API
component of IMAGE/SQL
permissions in IMAGE/SQL
explained
predicate
defined
preprocessor
component of IMAGE/SQL
defined
prerequisites for issuing IMAGE/SQL utility commands
primary key
defined
PRIV files
procedure
defined
programmatic access to data
in IMAGE/SQL and TurboIMAGE/XL
projection
defined
Q
query
defined
explained
relational operations in
result, defined
Query/3000
query language
defined
explained
R
read committed (RC)
defined
read uncommitted (RU)
defined
record
corresponding IMAGE/SQL term
reference information
ATCINFO
ATCLOG
referential integrity
defined
example of
maintaining
relational database
explained
relational operations
defined
joining
projection
selection
relationship
defined
relation (table)
defined
in a relational database
repeatable read (RR)
defined
resetting ATCLOG file equations from within IMAGE/SQL utility
result table
defined
REVOKE authorities
ROLLBACK WORK
root file
corresponding IMAGE/SQL term
differences from IMAGE/SQL DBECon file
row
corresponding TurboIMAGE/XL term
defined
in a relational database table
rule
defined
S
schema
defined
in IMAGE/SQL and TurboIMAGE/XL
script for sample database
security
in IMAGE/SQL and TurboIMAGE/XL
scheme
SELECT
selecting data
selecting TurboIMAGE/XL data with ALLBASE/SQL
example of
getting ready
reference information for
selection
defined
serial scan
defined
SET commands
used before displaying IMAGE/SQL utility information
set part of TurboIMAGE/XL database
setting IMAGE/SQL utility file equations
examples of
for ATCINFO
for ATCLOG
reference information for
setting up a database with ISQL
SMALLINT data types
SQL
CONNECT
defined
explained
SQLGEN
component of IMAGE/SQL
defined
SQLUtil
component of IMAGE/SQL
defined
using to set DBEnvironment maintenance word
standards
ANSI and X/OPEN
START DBE
structured query language
defined
explained
types of statements
subquery
defined
SYSTEM
DBEFileSet containing system catalog
defined
system catalog
corresponding TurboIMAGE/XL term
defined
differences from TurboIMAGE/XL root file
explained
system table
defined
system view
defined
T
table
as database object
corresponding TurboIMAGE/XL term
defined
differences from TurboIMAGE/XL data set
in a relational database
rows and columns in
sample in a relational database
using several
table authority
defined
task reference information
configuring a DBEnvironment
detaching a TurboIMAGE/XL database
logging IMAGE/SQL utility commands
maintaining the ATCINFO file
selecting TurboIMAGE/XL data with ALLBASE/SQL
setting IMAGE/SQL utility file equations
using IMAGE/SQL utility command files in batch
using IMAGE/SQL utility command files interactively
tasks
accessing TurboIMAGE/XL data with ISQL
adding data to the sample database
attaching a TurboIMAGE/XL database
committing work
configuring a DBEnvironment
creating a DBEnvironment
deleting data
detaching a TurboIMAGE/XL database
displaying IMAGE/SQL utility information
displaying TurboIMAGE/XL database information
examining authority structure
examining table description
examining the database
issuing MPE/iX commands from IMAGE/SQL utility
logging IMAGE/SQL utility commands
maintaining the ATCINFO file
modifying data
rolling back work
running ISQL
selecting data
selecting TurboIMAGE/XL data with ALLBASE/SQL
setting IMAGE/SQL file equations for ATCINFO
setting IMAGE/SQL file equations for ATCLOG
setting up a database
setting up the sample MUSIC database
setting up the sample MusicDBE DBEnvironment
using IMAGE/SQL utility command files
using the sample DBEnvironment
third-party tools
tools for IMAGE/SQL
transaction
defined
ended with COMMIT WORK
TurboIMAGE/XL
basic structure
compared with IMAGE/SQL
creating a database
defined
defining a database
detaching a database
explained
security
transition to IMAGE/SQL
U
unique constraint
defined
UPDATE
using IMAGE/SQL utility command files
getting ready
reference information for
V
view
defined
defining