HP 3000 Manuals HP 3000 Manuals
Index
A
aborted transaction
accessing mapped tables
accounts
attaching from different
ADD DBEFILE
syntax
adding a log file
adding IMAGE/SQL users
events that take place when
example of
getting ready
reference information for
adding pages
to IMAGESQL fileset
ADD USER
administering IMAGE/SQL
ALLBASE/Turbo CONNECT
ALTER TABLE
ATC
ATCINFO file
characteristics of
DBEnvironmentNameCR
reference information for
setting a file equation for
when purged
ATCLOG file
reference information for
setting a file equation for
ATCUtil
ATTACH
attached database
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
backwards migration
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
DBEFile 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 DBEFILE
syntax
CREATE INDEX
CREATE SCHEMA
CREATE TABLE
D
database See TurboIMAGE/XL database
administrator
creator
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
defined
DBA authority
when to grant
DBaseNameTC file
when purged
DBC
defined
DBCORE Errors
DBECon file
defined
DBECreator
defined
DBEFile
maximum size
DBEFILE0 size considerations
DBEFiles
creating
DBELOG1 size considerations
DBEnvironment
configuring
defined
setting a maintenance word
DBEnvironmentNameCR file
characteristics of
DBEnvironmentNameTC file
characteristics of
DBEUserID
DBNameTC
DBOPEN mode
DBUTIL
enhancements for IMAGE/SQL
deadlocks
deadlock situations
avoiding
DECLARE CURSOR
DEFAULT TIMEOUT
default values
DELETE
DELETE USER
DELETE WHERE CURRENT
deleting IMAGE/SQL users
example of
getting ready
reference information for
DETACH
detached database
detaching a TurboIMAGE/XL database
events that take place during
example of
getting ready
reasons for
reference information for
DISPLAY BASE
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
error messages
DBCORE errors
file system error
general
IMAGE/SQL
preprocessor
warning messages
example of
connecting to a DBEnvironment
deleting IMAGE/SQL users
detaching a TurboIMAGE/XL database
displaying TurboIMAGE/XL database information
issuing MPE/iX 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
fileset
IMAGESQL
file size
DBEFile
log file
file system error messages
forward migration
G
general errors
getting started with IMAGE/SQL
attaching a TurboIMAGE/XL database
configuring a DBEnvironment
GRANT
syntax
H
HELP
I
ID
DBEUserID
IMAGE/SQL
and database utilities
at run time
data access, controlling
data type mapping, about
DBOPEN modes for
environment, maintaining
environment, setting up
error messages
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
adding to fileset
IMAGESQL command
IMAGESQL fileset
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 TURBODB
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/iX commands from the IMAGE/SQL utility
J
JCW
MIGERR
MIGWARN
joining mapped tables
example of
performance considerations when
L
locking
lock assignment
LOCK TABLE
LOG
log file
adding
logging IMAGE/SQL utility commands
example of
reference information for
log pages
default size
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
defined
naming conventions for
mapping
mapping data types
table of defaults and alternatives
maximum pages
MAXIMUM TIMEOUT
messages See error messages
migrating a DBEnvironment
migrating databases
migration
backwards
MPE/iX
commands issued from the IMAGE/SQL utility
security rules enforced
N
naming conventions
SQL
NLS
native language support
NOT NULL
null values
O
OPEN
overview
administering IMAGE/SQL
getting started with IMAGE/SQL
IMAGE/SQL concepts
using IMAGE/SQL utility
P
pages
log
maximum
new tables
performance considerations
programming guidelines
use of search items in queries
preprocessor errors
prerequisites for issuing IMAGE/SQL utility commands
programming guidelines
PUBLIC tables
purging an attached database
Q
queries
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
search items in queries
security
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 BASE
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 TURBODB
space
adding
SPLIT
splitting mapped columns
example of
getting ready
reference information for
when to perform
SQLGEN
SQLMIG
SQLMigrate
SQL naming conventions
SQLUtil
enhancements for IMAGE/SQL
using to set DBEnvironment maintenance word
START DBE NEW
T
table
defined
task reference information
adding a log file
adding IMAGE/SQL users
attaching a TurboIMAGE/XL database
configuring a DBEnvironment
deleting IMAGE/SQL users
detaching a TurboIMAGE/XL database
displaying IMAGE/SQL utility information
issuing MPE/iX commands from the IMAGE/SQL utility
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 data type mapping
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
timeout
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
UserID
user timeout
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
W
warning messages
X
XEQ