 |
» |
|
|
|
A- aborted transaction, IMAGE/SQL Aborted Transaction
- accessing mapped tables, Accessing Mapped Tables
- accounts
- attaching from different, Task 1: Configuring a DBEnvironment
- ADD USER, ADD USER
- adding a log file, Task 8: Adding a Log File
- adding IMAGE/SQL users, Task 3: Adding IMAGE/SQL Users
- example of, Task 3: Adding IMAGE/SQL Users
- getting ready, Task 3: Adding IMAGE/SQL Users
- reference information for, Task 3: Adding IMAGE/SQL Users
- related events, About IMAGE/SQL Security
- administering IMAGE/SQL, Administering IMAGE/SQL:An Overview
- ALLBASE/Turbo CONNECT, Basic Terms for Getting Started
- ALTER TABLE, ALTER TABLE
- ATC, Basic Terms for Getting Started
- ATCINFO file
- characteristics of, IMAGE/SQL Files
- DBEnvironmentNameCR, Task 16: Maintaining the ATCINFO File
- reference information for, ATCINFO Reference
- setting a file equation for, Setting a File Equation for ATCINFO
- when purged, Task 9: Detaching a TurboIMAGE/XL Database
- ATCLOG file
- reference information for, ATCLOG Reference
- setting a file equation for, Setting a File Equation for ATCLOG
- ATCUtil, Basic Terms for Getting Started
- ATTACH, ATTACH
- attached database, Basic Terms for Getting Started
- attaching a TurboIMAGE/XL database, Task 2: Attaching a TurboIMAGE/XL Database
- example of, Attaching to a DBEnvironment, Task 2: Attaching a TurboIMAGE/XL Database
- getting ready, Task 2: Attaching a TurboIMAGE/XL Database
- related events, What Takes Place During an Attach?
- three commands required for, Attaching to a DBEnvironment, Task 2: Attaching a TurboIMAGE/XL Database
- when DBEnvironment is in different account, Task 2: Attaching a TurboIMAGE/XL Database
- with same name as one already attached, Task 2: Attaching a TurboIMAGE/XL Database
- authorization group
- naming convention for, Controlling IMAGE/SQL User Access
- status when deleting IMAGE/SQL users, Task 7: Deleting IMAGE/SQL Users
- when created, Controlling IMAGE/SQL User Access
C- CATALOG.IMAGEKEY, SYSTEM.IMAGEKEY and CATALOG.IMAGEKEY
- CATALOG.INDEX, SYSTEM.INDEX and CATALOG.INDEX
- CATALOG.TPINDEX , SYSTEM.TPINDEX and CATALOG.TPINDEX
- checklist
- for setting up the IMAGE/SQL environment, Maintaining the IMAGE/SQL Environment
- CHECKPOINT, CHECKPOINT
- COMMIT ARCHIVE, COMMIT ARCHIVE
- COMMIT WORK, Lock Assignment, Definition, COMMIT WORK
- configuring a DBEnvironment, Task 1: Configuring a DBEnvironment
- DBEFile size considerations, Task 1: Configuring a DBEnvironment
- example of, Task 1: Configuring a DBEnvironment
- getting ready, Task 1: Configuring a DBEnvironment
- reference information for, Task 1: Configuring a DBEnvironment
- when TurboIMAGE/XL database is in different account, Task 1: Configuring a DBEnvironment
- CONNECT
- using to connect to a DBEnvironment, Selecting TurboIMAGE/XL Data from Mapped Tables
- CREATE INDEX, CREATE INDEX
- CREATE SCHEMA, CREATE SCHEMA
- CREATE TABLE, CREATE TABLE
D- data type mapping, Updating K8 Data Types
- about, IMAGE/SQL Data Type Mapping
- example of updating, Task 4: Updating IMAGE/SQL Utility Data Type Mapping Information
- reference information for, Task 4: Updating IMAGE/SQL Utility Data Type Mapping Information
- table of defaults and alternatives, Task 4: Updating IMAGE/SQL Utility Data Type Mapping Information
- database
- administrator , Basic Terms for Getting Started
- creator, Basic Terms for Getting Started
- restrictions, Basic Terms for Getting Started
- schema sample, SALES Database Schema
- database security, What Takes Place During a Detach?
- database utilities, enhancements for IMAGE/SQL, IMAGE/SQL and Database Utilities
- DATE, Task 4: Updating IMAGE/SQL Utility Data Type Mapping Information
- Date/Time API, Date/Time API
- DATETIME, Task 4: Updating IMAGE/SQL Utility Data Type Mapping Information
- DBA
- defined, Basic Terms for Getting Started
- when to grant authority, Task 1: Configuring a DBEnvironment
- DBaseNameTC file
- when purged, Task 9: Detaching a TurboIMAGE/XL Database
- DBC
- defined , Basic Terms for Getting Started
- DBCORE Errors, DBCORE Errors
- DBEConFile, Task 2: Attaching a TurboIMAGE/XL Database
- defined, Basic Terms for Getting Started
- DBECreator
- defined, Basic Terms for Getting Started
- DBEFile
- maximum size, Task 1: Configuring a DBEnvironment
- DBEFILE0 size considerations, Task 1: Configuring a DBEnvironment
- DBELOG1 size considerations, Task 1: Configuring a DBEnvironment
- DBEnvironment
- configuring, Task 1: Configuring a DBEnvironment
- defined, Basic Terms for Getting Started
- setting a maintenance word, Task 1: Configuring a DBEnvironment
- DBEnvironmentNameCR file, Task 16: Maintaining the ATCINFO File
- characteristics of, IMAGE/SQL Files
- DBEnvironmentNameTC file
- characteristics of, IMAGE/SQL Files
- DBEUserID, Task 3: Adding IMAGE/SQL Users
- DBNameTC, IMAGE/SQL Files
- DBOPEN mode, Task 6: Updating Information about IMAGE/SQL Users, Lock Assignment
- DBTOCHAR, DBTOCHAR
- DBTODATE, DBTODATE
- DBTODTTM, DBTODTTM
- DBTOINT, DBTOINT
- DBTOITVL, DBTOITVL
- DBTOTIME, DBTOTIME
- DBUTIL
- enhancements for IMAGE/SQL, DBUTIL
- deadlocks, IMAGE/SQL Deadlocks
- avoiding, Task 1: Configuring a DBEnvironment
- DECLARE CURSOR, DECLARE CURSOR
- DEFAULT TIMEOUT, Task 1: Configuring a DBEnvironment
- default values, INSERT
- DELETE, DELETE
- DELETE USER, Syntax
- DELETE WHERE CURRENT, DELETE WHERE CURRENT
- deleting IMAGE/SQL users, Task 7: Deleting IMAGE/SQL Users
- example of, Task 7: Deleting IMAGE/SQL Users
- getting ready, Task 7: Deleting IMAGE/SQL Users
- reference information for, Task 7: Deleting IMAGE/SQL Users
- DETACH, DETACH
- detached database , Basic Terms for Getting Started
- detaching a TurboIMAGE/XL database, Task 9: Detaching a TurboIMAGE/XL Database
- events that take place during, What Takes Place During a Detach?
- example of, Task 9: Detaching a TurboIMAGE/XL Database
- getting ready, Task 9: Detaching a TurboIMAGE/XL Database
- reasons for, Task 9: Detaching a TurboIMAGE/XL Database, What Takes Place During a Detach?
- reference information for, Task 9: Detaching a TurboIMAGE/XL Database
- using DETACH command, DETACH
- DISPLAY BASE, Description
- DISPLAY commands
- two options, Task 10: Displaying IMAGE/SQL Utility Information
- DISPLAY MAP, DISPLAY MAP
- DISPLAY OPTIONS, DISPLAY OPTIONS
- DISPLAY SQLDBES, DISPLAY SQLDBES
- DISPLAY TURBODBS, DISPLAY TURBODBS
- DISPLAY USERS, DISPLAY USERS
- displaying IMAGE/SQL utility information, Task 10: Displaying IMAGE/SQL Utility Information, Example 2: Displaying Database Mapping Information
- displaying TurboIMAGE/XL database information, Task 10: Displaying IMAGE/SQL Utility Information
- displaying TurboIMAGE/XL database mapping, Example 2: Displaying Database Mapping Information
- getting ready, Task 10: Displaying IMAGE/SQL Utility Information
- DROP DBEFILE, DROP DBEFILE
- DROP TABLE, DROP TABLE
- DROP VIEW, DROP VIEW
E- ECHO, ECHO
- error messages
- DBCORE errors, DBCORE Errors
- file system errors, File System Error Messages
- general, General Errors
- IMAGE/SQL, IMAGE/SQL Error Messages
- preprocessor, Preprocessor Errors
- warning messages, IMAGE/SQL Warning Messages
- example of
- connecting to a DBEnvironment , Selecting TurboIMAGE/XL Data from Mapped Tables
- deleting IMAGE/SQL users, Task 7: Deleting IMAGE/SQL Users
- detaching a TurboIMAGE/XL database, Task 9: Detaching a TurboIMAGE/XL Database
- displaying TurboIMAGE/XL database information, Task 10: Displaying IMAGE/SQL Utility Information
- issuing MPE/iX commands from the IMAGE/SQL utility, Task 11: Issuing MPE/iX Commands from the IMAGE/SQL Utility
- logging IMAGE/SQL utility commands, Task 13: Logging IMAGE/SQL Utility Commands
- maintaining the ATCINFO file, Task 16: Maintaining the ATCINFO File
- selecting TurboIMAGE/XL data with ALLBASE/SQL, Task 15: Selecting TurboIMAGE/XL Data with SQL
- setting file equations, Setting a File Equation for ATCLOG
- splitting mapped columns, Task 5: Splitting Mapped Columns
- updating data type mapping, Task 4: Updating IMAGE/SQL Utility Data Type Mapping Information
- updating IMAGE/SQL user information, Task 6: Updating Information about IMAGE/SQL Users
- exceptions, SQL Exceptions
- EXIT, EXIT
I- ID
- DBEUserID, Task 3: Adding IMAGE/SQL Users
- IMAGE/SQL
- and database utilities, IMAGE/SQL and Database Utilities
- at run time, At Run Time
- data access, controlling, Controlling IMAGE/SQL User Access
- data type mapping, about, IMAGE/SQL Data Type Mapping
- DBOPEN modes for, Task 6: Updating Information about IMAGE/SQL Users
- environment, maintaining, Maintaining the IMAGE/SQL Environment
- environment, setting up, Setting Up the IMAGE/SQL Environment
- error messages, IMAGE/SQL Error Messages
- introduction to, Basic Terms for Getting Started
- performance considerations, Up-to-Date Information
- security, about, About IMAGE/SQL Security, Controlling IMAGE/SQL User Access
- security, to control IMAGE/SQL user access, Controlling IMAGE/SQL User Access
- terms, introduction to basic , Basic Terms for Getting Started
- users, adding, Task 3: Adding IMAGE/SQL Users
- users, reason for explicitly adding, About IMAGE/SQL Security
- users, related events when adding, About IMAGE/SQL Security
- views, naming convention for, Controlling IMAGE/SQL User Access
- views, when created, Controlling IMAGE/SQL User Access
- views, when dropped, Controlling IMAGE/SQL User Access
- IMAGE/SQL utility
- displaying information about, Task 10: Displaying IMAGE/SQL Utility Information
- introduction to, Basic Terms for Getting Started
- IMAGE/SQL utility commands
- ADD USER , ADD USER
- ATTACH , ATTACH
- DELETE USER , Syntax
- DETACH , DETACH
- DISPLAY MAP , DISPLAY MAP
- DISPLAY OPTIONS , DISPLAY OPTIONS
- DISPLAY SQLDBES , DISPLAY SQLDBES
- DISPLAY TURBODBS , DISPLAY TURBODBS
- DISPLAY USERS , DISPLAY USERS
- ECHO , ECHO
- EXIT , EXIT
- HELP , HELP
- listed for each task, Tasks Covered in this Chapter
- LOG , LOG
- prerequisites for issuing, About the Tasks
- QUIT , QUIT
- RECOVER , RECOVER
- REDO , REDO
- SET SQLDBE , SET SQLDBE
- SET TURBODB , SET TURBODB
- SPLIT , SPLIT
- UPDATE TYPE , UPDATE TYPE, Updating K8 Data Types
- UPDATE USER , UPDATE USER
- XEQ , XEQ
- IMAGE/SQL utility tasks, About the Tasks
- checklists of, Maintaining the IMAGE/SQL Environment
- numbered list of, Tasks Covered in this Chapter
- summary of commands needed to perform, Tasks Covered in this Chapter
- IMAGESQL command , Invoking the IMAGE/SQL Utility, Task 14: Using IMAGE/SQL Utility Command Files
- IMAGESQL fileset, Task 1: Configuring a DBEnvironment
- In data type mapping, Task 4: Updating IMAGE/SQL Utility Data Type Mapping Information
- indices
- B-Tree views, Executing SQLINSTL and ODBCVIEW
- third-party, DBUTIL Enhancements for TPI
- views for third-party, SQL Views for Indices
- INSERT, INSERT
- installing ALLBASE/SQL, Migrating a DBEnvironment
- INTERVAL, Task 4: Updating IMAGE/SQL Utility Data Type Mapping Information
- invoking the IMAGE/SQL utility , Getting Acquainted with the IMAGE/SQL Utility
- isolation level, Lock Assignment
- ISQL, Basic Terms for Getting Started
- example, Selecting TurboIMAGE/XL Data from Mapped Tables, Task 1: Configuring a DBEnvironment, Task 15: Selecting TurboIMAGE/XL Data with SQL
- issuing IMAGE/SQL utility commands
- prerequisites for, About the Tasks
- issuing MPE/iX commands from the IMAGE/SQL utility, Task 11: Issuing MPE/iX Commands from the IMAGE/SQL Utility
M- mainsetting IMAGE/SQL utility file equations, Task 12: Setting IMAGE/SQL File Equations
- maintaining the ATCINFO file, Task 16: Maintaining the ATCINFO File
- example of, Task 16: Maintaining the ATCINFO File
- getting ready, Task 16: Maintaining the ATCINFO File
- reference information for, Task 16: Maintaining the ATCINFO File
- maintaining the IMAGE/SQL environment, Maintaining the IMAGE/SQL Environment
- checklist for, Maintaining the IMAGE/SQL Environment
- maintenance words
- setting a DBEnvironment, Task 1: Configuring a DBEnvironment
- when needed, Task 1: Configuring a DBEnvironment
- mapped columns
- splitting of, Task 5: Splitting Mapped Columns
- mapped tables
- access to, Accessing Mapped Tables
- controlling access to, About IMAGE/SQL Security
- defined, Basic Terms for Getting Started
- naming conventions for, What Takes Place During an Attach?
- mapping , Basic Terms for Getting Started
- mapping data types
- table of defaults and alternatives, Task 4: Updating IMAGE/SQL Utility Data Type Mapping Information
- maximum pages, Task 1: Configuring a DBEnvironment
- MAXIMUM TIMEOUT, Task 1: Configuring a DBEnvironment
- migrating a DBEnvironment, Migrating a DBEnvironment, SQL Views for Indices
- MPE/iX
- commands issued from the IMAGE/SQL utility, Task 11: Issuing MPE/iX Commands from the IMAGE/SQL Utility
- security rules enforced, Task 1: Configuring a DBEnvironment
P- pages
- log, Task 1: Configuring a DBEnvironment
- maximum, Task 1: Configuring a DBEnvironment
- new tables, Task 1: Configuring a DBEnvironment
- performance considerations
- programming guidelines, Up-to-Date Information
- use of search items in queries, Up-to-Date Information
- Pn data type mapping, Task 4: Updating IMAGE/SQL Utility Data Type Mapping Information
- preprocessor errors, Preprocessor Errors
- prerequisites for issuing IMAGE/SQL utility commands, About the Tasks
- programming guidelines, Up-to-Date Information
- PUBLIC tables, Lock Assignment
- purging an attached database, Purging an Attached Database
R- RECOVER, RECOVER
- REDO, REDO
- reference information, DBUTIL
- ATCINFO, ATCINFO Reference
- ATCLOG, ATCLOG Reference
- repeatable read, Definition
- resetting ATCLOG file equations from within the IMAGE/SQL utility, Setting a File Equation for ATCLOG
- restrictions on transactions, Restrictions
- restructuring in the IMAGE/SQL environment
- checklist for, Maintaining the IMAGE/SQL Environment
- REVOKE, REVOKE
- Rn data type mapping, Task 4: Updating IMAGE/SQL Utility Data Type Mapping Information
- ROLLBACK WORK, Lock Assignment, Definition, ROLLBACK WORK
- run time
- IMAGE/SQL at, At Run Time
S- SALES database schema, SALES Database Schema
- sample database schema, SALES Database Schema
- SAVEPOINTS, SAVEPOINTS
- search items in queries, Items in Queries
- security, Task 1: Configuring a DBEnvironment, About IMAGE/SQL Security
- SELECT, SELECT
- using to query TurboIMAGE/XL data, Selecting TurboIMAGE/XL Data from Mapped Tables
- selecting TurboIMAGE/XL data with ALLBASE/SQL, Task 15: Selecting TurboIMAGE/XL Data with SQL
- example of, Task 15: Selecting TurboIMAGE/XL Data with SQL
- getting ready, Task 15: Selecting TurboIMAGE/XL Data with SQL
- reference information for, Task 15: Selecting TurboIMAGE/XL Data with SQL
- SET BASE, Description
- SET commands
- used before displaying IMAGE/SQL utility information, Task 10: Displaying IMAGE/SQL Utility Information
- SET CONSTRAINTS, SET CONSTRAINTS
- SET DML ATOMICITY, SET DML ATOMICITY
- SET SQLDBE, SET SQLDBE
- SET TURBODB, SET TURBODB
- setting IMAGE/SQL utility file equations
- examples of, Setting a File Equation for ATCLOG
- for ATCINFO, Setting a File Equation for ATCINFO
- for ATCLOG, Setting a File Equation for ATCLOG
- reference information for, ATCINFO Reference
- setting up the IMAGE/SQL environment, Setting Up the IMAGE/SQL Environment
- adding IMAGE/SQL users, Task 3: Adding IMAGE/SQL Users
- attaching a TurboIMAGE/XL database, Task 2: Attaching a TurboIMAGE/XL Database
- checklist for, Maintaining the IMAGE/SQL Environment
- configuring a DBEnvironment, Task 1: Configuring a DBEnvironment
- splitting mapped columns, Task 5: Splitting Mapped Columns
- updating data type mapping, Task 4: Updating IMAGE/SQL Utility Data Type Mapping Information
- SPLIT, SPLIT
- splitting mapped columns, Task 5: Splitting Mapped Columns
- example of, Task 5: Splitting Mapped Columns
- getting ready, Task 5: Splitting Mapped Columns
- reference information for, Task 5: Splitting Mapped Columns
- when to perform, Task 5: Splitting Mapped Columns
- SQL naming conventions, Task 5: Splitting Mapped Columns
- SQL views
- for indices, SQL Views for Indices
- SQLGEN, SQLGEN
- SQLINSTL, Migrating a DBEnvironment, Executing SQLINSTL and ODBCVIEW
- SQLMigrate, Migrating a DBEnvironment
- SQLUtil, Basic Terms for Getting Started
- enhancements for IMAGE/SQL, SQLUtil
- using to set DBEnvironment maintenance word, Task 1: Configuring a DBEnvironment
- START DBE NEW, Task 1: Configuring a DBEnvironment, START DBE NEW
- SYSTEM.IMAGEKEY, SYSTEM.IMAGEKEY and CATALOG.IMAGEKEY
- SYSTEM.INDEX, SYSTEM.INDEX and CATALOG.INDEX
- SYSTEM.TPINDEX, SYSTEM.TPINDEX and CATALOG.TPINDEX
T- table
- defined , Basic Terms for Getting Started
- task reference information
- adding a log file, Task 8: Adding a Log File
- adding IMAGE/SQL users, Task 3: Adding IMAGE/SQL Users
- attaching a TurboIMAGE/XL database, Task 2: Attaching a TurboIMAGE/XL Database
- checklist for tasks, Maintaining the IMAGE/SQL Environment
- configuring a DBEnvironment, Task 1: Configuring a DBEnvironment
- deleting IMAGE/SQL users, Task 7: Deleting IMAGE/SQL Users
- detaching a TurboIMAGE/XL database, Task 9: Detaching a TurboIMAGE/XL Database
- displaying IMAGE/SQL utility information, Task 10: Displaying IMAGE/SQL Utility Information
- issuing MPE/iX commands from the IMAGE/SQL utility, Task 11: Issuing MPE/iX Commands from the IMAGE/SQL Utility
- logging IMAGE/SQL utility commands, Task 13: Logging IMAGE/SQL Utility Commands
- maintaining the ATCINFO file, Task 16: Maintaining the ATCINFO File
- selecting TurboIMAGE/XL data with ALLBASE/SQL, Task 15: Selecting TurboIMAGE/XL Data with SQL
- setting IMAGE/SQL utility file equations, ATCINFO Reference
- splitting mapped columns, Task 5: Splitting Mapped Columns
- updating IMAGE/SQL data type mapping, Task 4: Updating IMAGE/SQL Utility Data Type Mapping Information
- updating IMAGE/SQL user information, Task 6: Updating Information about IMAGE/SQL Users
- using IMAGE/SQL utility command files in batch, Task 14: Using IMAGE/SQL Utility Command Files
- using IMAGE/SQL utility command files interactively, Task 14: Using IMAGE/SQL Utility Command Files
- third-party indices
- DBUTIL enhancements for, DBUTIL Enhancements for TPI
- views for, SQL Views for Indices
- with ATTACH, Description
- TIME, Task 4: Updating IMAGE/SQL Utility Data Type Mapping Information
- timeout, Task 1: Configuring a DBEnvironment
- TO_CHAR, Date/Time API Description
- TO_DATE, Date/Time API Description
- TO_DATETIME, Date/Time API Description
- TO_INTEGER, Date/Time API Description
- TO_INTERVAL, Date/Time API Description
- TO_TIME, Date/Time API Description
- TPI,third-party indices, DBUTIL Enhancements for TPI
- transactions
- aborted, IMAGE/SQL Aborted Transaction
- definition, Definition
- restrictions, Restrictions
- TRANSFER OWNERSHIP, TRANSFER OWNERSHIP
- TurboIMAGE/XL database
- passwords, protecting, What Takes Place During a Detach?
- purging an attached, Purging an Attached Database
- security, protecting passwords, What Takes Place During a Detach?
U- Un data type mapping, Task 4: Updating IMAGE/SQL Utility Data Type Mapping Information
- UPDATE, UPDATE
- UPDATE TYPE, UPDATE TYPE, Updating K8 Data Types
- UPDATE USER, UPDATE USER
- UPDATE WHERE CURRENT, UPDATE WHERE CURRENT
- updating IMAGE/SQL data type mapping, Task 4: Updating IMAGE/SQL Utility Data Type Mapping Information
- example of, Task 4: Updating IMAGE/SQL Utility Data Type Mapping Information
- getting ready, Task 4: Updating IMAGE/SQL Utility Data Type Mapping Information
- reference information for, Task 4: Updating IMAGE/SQL Utility Data Type Mapping Information
- updating IMAGE/SQL user information, Task 6: Updating Information about IMAGE/SQL Users
- example of, Task 6: Updating Information about IMAGE/SQL Users
- getting ready, Task 6: Updating Information about IMAGE/SQL Users
- reference information, Task 6: Updating Information about IMAGE/SQL Users
- user timeout, Task 1: Configuring a DBEnvironment
- user-created views
- when dropped, Controlling IMAGE/SQL User Access, IMAGE/SQL Data Type Mapping
- UserID, Task 3: Adding IMAGE/SQL Users
- using IMAGE/SQL utility command files, Task 14: Using IMAGE/SQL Utility Command Files
- example of using in batch mode, Task 14: Using IMAGE/SQL Utility Command Files
- example of using interactively, Task 14: Using IMAGE/SQL Utility Command Files
- getting ready, Task 14: Using IMAGE/SQL Utility Command Files
- reference information for, Task 14: Using IMAGE/SQL Utility Command Files
|