HP 3000 Manuals HP 3000 Manuals
Index
A
aborted transaction
accessing mapped tables
accounts
attaching from different
adding IMAGE/SQL users
events that take place when
example of
getting ready
reference information for
ADD USER
administering IMAGE/SQL
ALTER TABLE
ATCINFO file
characteristics of
reference information for
setting a file equation for
when purged
ATCLOG file
reference information for
setting a file equation for
ATTACH
attaching a TurboIMAGE/XL database
events that take place during
example of
getting ready
three commands required for
when DBEnvironment is in different account
with same name as one already attached
authorization group
naming convention for
status when deleting IMAGE/SQL users
when created
B
basic terms
batch
using IMAGE/SQL utility command files in
BEGIN ARCHIVE
beginning an IMAGE/SQL utility session
BEGIN WORK
C
CHECKPOINT
COMMIT ARCHIVE
COMMIT WORK
configuring a DBEnvironment
DBE file size considerations
example of
getting ready
reference information for
when TurboIMAGE/XL database is in different account
CONNECT
using to connect to a DBEnvironment
CREATE INDEX
CREATE SCHEMA
CREATE TABLE
D
database See TurboIMAGE/XL database
database security
database utilities, enhancements for IMAGE/SQL
data type mapping
about
example of updating
reference information for
table of defaults and alternatives
DATE
DATETIME
DBA authority
when to grant
DBaseNameTC file
when purged
DBEFILE0 size considerations
DBELOG1 size considerations
DBEnvironment
setting a maintenance word
DBNameTC file
characteristics of
DBOPEN mode
DBUTIL
enhancements for IMAGE/SQL
deadlocks
DECLARE CURSOR
default values
DELETE
DELETE USER
DELETE WHERE CURRENT
deleting IMAGE/SQL users
example of
getting ready
reference information for
DETACH
detaching a TurboIMAGE/XL database
events that take place during
example of
getting ready
reasons for
reference information for
DISPLAY commands
two options
displaying IMAGE/SQL utility information
displaying TurboIMAGE/XL database information
displaying TurboIMAGE/XL database mapping
getting ready
DISPLAY MAP
DISPLAY OPTIONS
DISPLAY SQLDBES
DISPLAY TURBODBS
DISPLAY USERS
DROP DBEFILE
DROP TABLE
DROP VIEW
E
ECHO
example of
connecting to a DBEnvironment
deleting IMAGE/SQL users
detaching a TurboIMAGE/XL database
displaying TurboIMAGE/XL database information
issuing MPE XL commands from the IMAGE/SQL utility
logging IMAGE/SQL utility commands
maintaining the ATCINFO file
selecting TurboIMAGE/XL data with ALLBASE/SQL
setting file equations
splitting mapped columns
updating data type mapping
updating IMAGE/SQL user information
exceptions
EXIT
F
file equations
examples of setting
reference information for
setting for ATCINFO
setting for ATCLOG
G
getting started with IMAGE/SQL
attaching a TurboIMAGE/XL database
configuring a DBEnvironment
GRANT
H
HELP
I
IMAGE/SQL
and database utilities
at run time
data access, controlling
data type mapping, about
DBOPEN modes for
environment, maintaining
environment, setting up
introduction to
performance considerations
security, about
security, to control IMAGE/SQL user access
terms, introduction to basic
users, adding
users, events that occur when adding
users, reason for explicitly adding
views, naming convention for
views, when created
views, when dropped
IMAGESQL command
IMAGE/SQL utility
displaying information about
introduction to
IMAGE/SQL utility commands
ADD USER
ATTACH
DELETE USER
DETACH
DISPLAY MAP
DISPLAY OPTIONS
DISPLAY SQLDBES
DISPLAY TURBODBS
DISPLAY USERS
ECHO
EXIT
HELP
listed for each task
LOG
prerequisites for issuing
QUIT
RECOVER
REDO
SET SQLDBE
SET TURBO
SPLIT
UPDATE TYPE
UPDATE USER
XEQ
IMAGE/SQL utility tasks
checklists of
numbered list of
summary of commands needed to perform
INSERT
INTERVAL
invoking the IMAGE/SQL utility
isolation level
ISQL
example
issuing IMAGE/SQL utility commands
prerequisites for
issuing MPE XL commands from the IMAGE/SQL utility
J
joining mapped tables
example of
performance considerations when
L
locking
lock assignment
LOCK TABLE
LOG
logging IMAGE/SQL utility commands
example of
reference information for
M
maintaining the ATCINFO file
example of
getting ready
reference information for
maintaining the IMAGE/SQL environment
checklist for
maintenance words
setting a DBEnvironment
when needed
mapped columns
splitting of
mapped tables
access to
controlling access to
naming conventions for
mapping data types
table of defaults and alternatives
messages See error messages
MPE XL
commands issued from the IMAGE/SQL utility
security rules enforced
N
naming conventions
SQL
NOT NULL
null values
O
OPEN
overview
administering IMAGE/SQL
getting started with IMAGE/SQL
IMAGE/SQL concepts
using IMAGE/SQL utility
P
performance considerations
programming guidelines
use of search items in queries
prerequisites for issuing IMAGE/SQL utility commands
programming guidelines
PUBLIC tables
purging an attached database
Q
QUIT
R
RECOVER
REDO
reference information
ATCINFO
ATCLOG
repeatable read
resetting ATCLOG file equations from within the IMAGE/SQL utility
restrictions on transactions
restructuring in the IMAGE/SQL environment
checklist for
REVOKE
ROLLBACK WORK
run time
IMAGE/SQL at
S
SAVEPOINTS
SELECT
using to query TurboIMAGE/XL data
selecting TurboIMAGE/XL data with ALLBASE/SQL
example of
getting ready
reference information for
selecting TurboIMAGE/XL data with SQL
SET commands
used before displaying IMAGE/SQL utility information
SET CONSTRAINTS
SET DML ATOMICITY
SET SQLDBE
setting IMAGE/SQL utility file equations
examples of
for ATCINFO
for ATCLOG
reference information for
setting up the IMAGE/SQL environment
adding IMAGE/SQL users
attaching a TurboIMAGE/XL database
checklist for
configuring a DBEnvironment
splitting mapped columns
updating data type mapping
SET TURBO
SPLIT
splitting mapped columns
example of
getting ready
reference information for
when to perform
SQL naming conventions
SQLUtil
enhancements for IMAGE/SQL
using to set DBEnvironment maintenance word
START DBE NEW
T
task reference information
configuring a DBEnvironment
deleting IMAGE/SQL users
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
splitting mapped columns
updating IMAGE/SQL user information
using IMAGE/SQL utility command files in batch
using IMAGE/SQL utility command files interactively
tasks See IMAGE/SQL utility tasks
TIME
transactions
aborted
definition
restrictions
TRANSFER OWNERSHIP
TurboIMAGE/XL database
passwords, protecting
purging an attached
security, protecting passwords
U
UPDATE
UPDATE TYPE
UPDATE USER
UPDATE WHERE CURRENT
updating IMAGE/SQL data type mapping
example of
getting ready
reference information for
updating IMAGE/SQL user information
example of
getting ready
reference information
user-created views
when dropped
using IMAGE/SQL utility command files
example of using in batch mode
example of using interactively
getting ready
reference information for
V
views
IMAGE/SQL
user-created
X
XEQ