HP 3000 Manuals HP 3000 Manuals
Index
A
aborted transaction
accessing mapped tables
accounts
attaching from different
adding a log file
adding IMAGE/SQL users
example of
getting ready
reference information for
related events
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
example of
getting ready
related events
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
B-Tree indices
viewing
with ATTACH
C
CATALOG.IMAGEKEY
CATALOG.INDEX
CATALOG.TPINDEX
checklist
for setting up the IMAGE/SQL environment
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 INDEX
CREATE SCHEMA
CREATE TABLE
D
database See TurboIMAGE/XL database
administrator
creator
restrictions
schema sample
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
Date/Time API
DBA
defined
when to grant authority
DBaseNameTC file
when purged
DBC
defined
DBCORE Errors
DBEConFile
defined
DBECreator
defined
DBEFile
maximum size
DBEFILE0 size considerations
DBELOG1 size considerations
DBEnvironment
configuring
defined
setting a maintenance word
DBEnvironmentNameCR file
characteristics of
DBEnvironmentNameTC file
characteristics of
DBEUserID
DBNameTC
DBOPEN mode
DBTOCHAR
DBTODATE
DBTODTTM
DBTOINT
DBTOITVL
DBTOTIME
DBUTIL
enhancements for IMAGE/SQL
deadlocks
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
using DETACH command
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 errors
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
G
general errors
getting started with IMAGE/SQL
attaching a TurboIMAGE/XL database
configuring a DBEnvironment
GRANT
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, reason for explicitly adding
users, related events when adding
views, naming convention for
views, when created
views, when dropped
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 TYPE
UPDATE USER
XEQ
IMAGE/SQL utility tasks
checklists of
numbered list of
summary of commands needed to perform
In data type mapping
indices
B-Tree views
third-party
views for third-party
INSERT
installing ALLBASE/SQL
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
Jn data type mapping
joining mapped tables
example of
performance considerations when
K
K8 data types
Kn data type mapping
L
locking
lock assignment
LOCK TABLE
LOG
log file
adding
maximum pages
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
defined
naming conventions for
mapping
mapping data types
table of defaults and alternatives
maximum pages
MAXIMUM TIMEOUT
messages See error messages
migrating a DBEnvironment
MPE/iX
commands issued from the IMAGE/SQL utility
security rules enforced
N
naming conventions
SQL
new views
NLS
native language support
NOT NULL
null values
O
ODBCVIEW
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
Pn data type mapping
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
Rn data type mapping
ROLLBACK WORK
run time
IMAGE/SQL at
S
SALES database schema
sample database schema
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
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
SPLIT
splitting mapped columns
example of
getting ready
reference information for
when to perform
SQLGEN
SQLINSTL
SQLMigrate
SQL naming conventions
SQLUtil
enhancements for IMAGE/SQL
using to set DBEnvironment maintenance word
SQL views
for indices
START DBE NEW
SYSTEM.IMAGEKEY
SYSTEM.INDEX
SYSTEM.TPINDEX
T
table
defined
task reference information
adding a log file
adding IMAGE/SQL users
attaching a TurboIMAGE/XL database
checklist for tasks
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
third-party indices
DBUTIL enhancements for
views for
with ATTACH
TIME
timeout
TO_CHAR
TO_DATE
TO_DATETIME
TO_INTEGER
TO_INTERVAL
TO_TIME
TPI,third-party indices
transactions
aborted
definition
restrictions
TRANSFER OWNERSHIP
TurboIMAGE/XL database
passwords, protecting
purging an attached
security, protecting passwords
U
Un data type mapping
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
for B-Tree indices
for indices
IMAGE/SQL
user-created
W
warning messages
X
XEQ
Xn data type mapping
Z
Zn data type mapping