 |
» |
|
|
|
A- access
- interactive, Interactive Access
- programmatic, Programmatic Access
- to a database, How Do I Access a Database through SQL?
- accounts
- attaching from different, Configuring a DBEnvironment
- adding data to the sample database, Adding Data to the Database
- ALLBASE/NET
- component of IMAGE/SQL, ALLBASE/NET
- ALLBASE/SQL
- DBA authority, when to grant, Configuring a DBEnvironment
- DBEFILE0, size considerations, Configuring a DBEnvironment
- DBELOG1, size considerations, Configuring a DBEnvironment
- DBEnvironment, setting a maintenance word, Listing the Newly Created Files
- defined, ALLBASE/SQL
- ATC
- defined,
- ATCINFO file, Setting IMAGE/SQL File Equations
- maintaining, Maintaining the ATCINFO File
- reference information for, ATCINFO Reference
- setting a file equation for, Setting a File Equation for ATCINFO
- when purged, Detaching a TurboIMAGE/XL Database
- ATCLOG file, Setting IMAGE/SQL File Equations
- reference information for, ATCLOG Reference
- setting a file equation for, Setting a File Equation for ATCLOG
- attaching a TurboIMAGE/XL database
- example of, Attaching a TurboIMAGE/XL Database
- getting ready, Attaching a TurboIMAGE/XL Database
- three commands required for, Attaching a TurboIMAGE/XL Database
- when DBEnvironment is in different account, Attaching a TurboIMAGE/XL Database
- with same name as one already attached, Attaching a TurboIMAGE/XL Database
- attributes, The Example Application
- defined,
- authority, How Do I Create a DBEnvironment?, Granting and Revoking IMAGE/SQL Authorities
- defined,
- in IMAGE/SQL, How Do I Control Database Access?
- in the sample DBEnvironment, Examining the Authority Structure
- authorization group
- defined,
- in the sample DBEnvironment MusicDBE, Examining the Authority Structure
- automatic master set, Tables versus Data Sets
C- CHAR data types, Mapping of Data Types
- check constraint
- defined,
- class
- defined,
- column
- corresponding TurboIMAGE/XL term, Moving from TurboIMAGE/XL to IMAGE/SQL
- defined,
- in a relational database table, Rows and Columns
- column authorization
- defined,
- described, Examining the Authority Structure
- column list
- defined,
- command files, Using IMAGE/SQL Utility Command Files
- COMMIT WORK
- example, Using the INSERT Statement, The EXTERNAL Option, The INTERNAL Option
- why necessary, Using the INSERT Statement
- compound items, Compound Items
- concurrency
- defined,
- when accessing, Methods of Accessing Databases
- configuring a DBEnvironment
- DBE file size considerations, Configuring a DBEnvironment
- example of, Configuring a DBEnvironment
- getting ready, Configuring a DBEnvironment
- when TurboIMAGE/XL database is in different account, Configuring a DBEnvironment
- CONNECT, Examining The Database
- constraint
- defined,
- creating
- a database, How Do I Create a Database?, Creating Databases
- DBEnvironment, Creating a DBEnvironment
D- data
- adding to a database, Adding Data to the Database
- deleting, Deleting Data
- modifying, Modifying Data
- data analysis
- basic explanation, Using Several Tables
- defined,
- data control language
- defined,
- explained, How Do I Control Database Access?
- data entities, Logical Data Entities
- data item
- corresponding IMAGE/SQL term, Moving from TurboIMAGE/XL to IMAGE/SQL
- data manipulation
- defined,
- example, How Do I Access a Database through SQL?
- data manipulation language
- defined,
- data set
- corresponding IMAGE/SQL term, Moving from TurboIMAGE/XL to IMAGE/SQL
- defining, Defining the Data Sets
- differences from IMAGE/SQL table, Tables versus Data Sets
- data type
- defined,
- mapping, Mapping of Data Types
- database
- access in IMAGE/SQL and TurboIMAGE/XL, Methods of Accessing Databases
- accessing, How Do I Access a Database through SQL?
- adding data, Adding Data to the Database
- administrator, Granting and Revoking IMAGE/SQL Authorities
- administrator (DBA), defined,
- administrator (DBA), explained, SQLUtil
- controlling access, How Do I Control Database Access?
- creating, How Do I Create a Database?, Creating Databases
- creating a TurboIMAGE/XL, Creating the TurboIMAGE/XL Database
- creator, Granting and Revoking IMAGE/SQL Authorities
- defined,
- design, basic explanation, Using Several Tables
- design, defined,
- example, A Database Example
- explained, What Is a Database?, Databases
- in IMAGE/SQL and TurboIMAGE/XL, Creating Databases
- setting up with ISQL, Setting Up a Database with ISQL
- DB01 file
- corresponding IMAGE/SQL term, Moving from TurboIMAGE/XL to IMAGE/SQL
- DB02 file
- corresponding IMAGE/SQL term, Moving from TurboIMAGE/XL to IMAGE/SQL
- DB03 file
- corresponding IMAGE/SQL term, Moving from TurboIMAGE/XL to IMAGE/SQL
- DBA authority, Granting and Revoking IMAGE/SQL Authorities
- defined,
- explained, How Do I Control Database Access?
- DBaseNameTC file
- when purged, Detaching a TurboIMAGE/XL Database
- DBC
- database creator,
- DBC authority, Granting and Revoking IMAGE/SQL Authorities
- DBECon file
- corresponding TurboIMAGE/XL term, Moving from TurboIMAGE/XL to IMAGE/SQL
- defined,
- differences from TurboIMAGE/XL root file, Root File versus DBECon File and System Catalog
- explained, The DBECon file
- name and content, Listing the Newly Created Files
- DBECreator
- defined,
- explained, How Do I Control Database Access?
- DBEFile
- corresponding TurboIMAGE/XL term, Moving from TurboIMAGE/XL to IMAGE/SQL
- explained, DBEFiles
- DBEFile0
- DBEFile containing system catalog, System Catalog
- name and content, Listing the Newly Created Files
- DBEFileset
- explained, Examining The Database
- DBEFileSets
- defined,
- explained, DBEFileSets
- DBEnvironment
- basic explanation, How Do I Create a DBEnvironment?
- corresponding TurboIMAGE/XL term, Moving from TurboIMAGE/XL to IMAGE/SQL
- creating, How Do I Create a DBEnvironment?, Creating a DBEnvironment
- default files in, Listing the Newly Created Files
- defined,
- differences from TurboIMAGE/XL, Creating Databases
- explained, What Is a DBEnvironment?
- starting, How Do I Create a DBEnvironment?
- DBEnvironment-nameCR, ATCINFO Reference
- DBEUserID
- corresponding TurboIMAGE/XL term, Moving from TurboIMAGE/XL to IMAGE/SQL
- defined,
- DBLOCK intrinsic, Locking Mechanisms
- DBSCHEMA, Creating Databases, Root File versus DBECon File and System Catalog, Defining the TurboIMAGE/XL Database
- DBUTIL, Creating Databases, Creating the TurboIMAGE/XL Database, Setting Up MUSIC and MusicDBE
- DECIMAL data types, Mapping of Data Types
- default values, Default Values
- DELETE, How Do I Access a Database through SQL?, Deleting Data
- deleting
- data, Deleting Data
- detaching a TurboIMAGE/XL database
- example of, Detaching a TurboIMAGE/XL Database
- getting ready, Detaching a TurboIMAGE/XL Database
- reasons for, Detaching a TurboIMAGE/XL Database
- reference information for, Detaching a TurboIMAGE/XL Database
- detail data sets, Defining the Data Sets
- detail set, Tables versus Data Sets
- DISPLAY commands
- two options, Displaying IMAGE/SQL Utility Information
- DISPLAY MAP, Displaying IMAGE/SQL Utility Information
- DISPLAY OPTIONS, Displaying IMAGE/SQL Utility Information
- DISPLAY SQLDBE, Displaying IMAGE/SQL Utility Information
- DISPLAY TURBODB, Displaying IMAGE/SQL Utility Information
- DISPLAY USER, Displaying IMAGE/SQL Utility Information
- displaying IMAGE/SQL utility information
- displaying DBEnvironment information, Example 3: Displaying DBEnvironment Information
- displaying TurboIMAGE/XL database information, Displaying IMAGE/SQL Utility Information
- displaying TurboIMAGE/XL database mapping, Example 2: Displaying Database Mapping Information
- displaying user information, Example 4: Displaying User Information
- getting ready, Displaying IMAGE/SQL Utility Information
G- getting ready for
- detaching a TurboIMAGE/XL database, Detaching a TurboIMAGE/XL Database
- displaying IMAGE/SQL utility information, Displaying IMAGE/SQL Utility Information
- maintaining the ATCINFO file, Maintaining the ATCINFO File
- selecting TurboIMAGE/XL data with ALLBASE/SQL, Accessing TurboIMAGE/XL Data with ISQL
- using IMAGE/SQL utility command files, Using IMAGE/SQL Utility Command Files
- getting started with IMAGE/SQL
- configuring a DBEnvironment, Configuring a DBEnvironment
- GRANT
- authorities, Granting and Revoking IMAGE/SQL Authorities
- statement, How Do I Control Database Access?
- group
- defined,
- defining, Defining IMAGE/SQL Groups
- in the sample DBEnvironment MusicDBE, Examining the Authority Structure
I- IMAGE/SQL
- and ALLBASE/SQL, How Do IMAGE/SQL and ALLBASE/SQL Coexist?
- basic concepts, Basic Concepts
- basic structure, Basic Structures
- benefits, What Are The Benefits of Using IMAGE/SQL?
- command, Using IMAGE/SQL Utility Command Files
- compared with TurboIMAGE/XL, Moving from TurboIMAGE/XL to IMAGE/SQL
- components, What Are the Components of IMAGE/SQL?
- defining groups, Defining IMAGE/SQL Groups
- defining views, Defining Views in IMAGE/SQL
- environment, Understanding the Environment
- introduction, Introducing IMAGE/SQL
- locking, Locking Mechanisms
- permissions, How Do I Control Database Access?
- sample DBEnvironment, Practicing with IMAGE/SQL Using MusicDBE
- tasks, IMAGE/SQL Tasks
- tools, Tools For IMAGE/SQL
- IMAGE/SQL utility
- component of IMAGE/SQL, IMAGE/SQL Utility
- displaying information about, Displaying IMAGE/SQL Utility Information
- example of using in batch mode, Using IMAGE/SQL Utility Command Files
- example of using interactively, Using IMAGE/SQL Utility Command Files
- issuing commands, About the Tasks
- logging commands, Logging IMAGE/SQL Utility Commands
- prerequisites for issuing, About the Tasks
- setting up a database, Setting Up a Database with ISQL
- implicit locking
- defined,
- INFO, Examining Table Descriptions
- INSERT, How Do I Access a Database through SQL?, Using the INSERT Statement
- INTEGER data types, Mapping of Data Types
- integrity constraint
- defined,
- interactive access to data
- in IMAGE/SQL and TurboIMAGE/XL, Interactive Access
- isolation level
- defined,
- ISQL
- accessing TurboIMAGE/XL data, Accessing TurboIMAGE/XL Data with ISQL
- component of IMAGE/SQL, ISQL
- defined,
- how to run, Running ISQL
- setting up a database, Setting Up a Database with ISQL
- item part of TurboIMAGE/XL database, Defining the TurboIMAGE/XL Database
L- LOAD
- description, Using the LOAD Command
- EXTERNAL option, The EXTERNAL Option
- INTERNAL option, The INTERNAL Option
- locking
- defined,
- mechanisms in IMAGE/SQL and TurboIMAGE/XL, Locking Mechanisms
- log file
- defined, Log Files
- name and content, Listing the Newly Created Files
- logging
- defined,
- explained, Log Files
- logging IMAGE/SQL utility commands
- example of, Logging IMAGE/SQL Utility Commands
- reference information for, Logging IMAGE/SQL Utility Commands
- logical data entities, Logical Data Entities
M- maintaining the ATCINFO file
- example of, Maintaining the ATCINFO File
- getting ready, Maintaining the ATCINFO File
- reference information for, Maintaining the ATCINFO File
- maintenance word
- setting a DBEnvironment, Listing the Newly Created Files
- when needed, Configuring a DBEnvironment
- manual master set, Tables versus Data Sets
- mapping of data types, Mapping of Data Types
- master data sets, Defining the Data Sets
- master set, Tables versus Data Sets
- modifying data, Modifying Data
- MPE/iX
- commands issued from the IMAGE/SQL utility, Issuing MPE/iX Commands from the IMAGE/SQL Utility
- security rules enforced, Configuring a DBEnvironment
P- password
- corresponding IMAGE/SQL term, Moving from TurboIMAGE/XL to IMAGE/SQL
- part of TurboIMAGE/XL database, Defining the TurboIMAGE/XL Database
- PC API
- component of IMAGE/SQL, HP PC API for ALLBASE/SQL and IMAGE/SQL
- permissions in IMAGE/SQL
- explained, How Do I Control Database Access?
- predicate
- defined,
- preprocessor
- component of IMAGE/SQL, Preprocessors
- defined,
- prerequisites for issuing IMAGE/SQL utility commands, About the Tasks
- primary key
- defined,
- PRIV files, Setting Up MUSIC and MusicDBE
- procedure
- defined,
- programmatic access to data
- in IMAGE/SQL and TurboIMAGE/XL, Programmatic Access
- projection
- defined,
R- read committed (RC)
- defined,
- read uncommitted (RU)
- defined,
- record
- corresponding IMAGE/SQL term, Moving from TurboIMAGE/XL to IMAGE/SQL
- reference information
- ATCINFO, ATCINFO Reference
- ATCLOG, ATCLOG Reference
- referential integrity
- defined, Identifying Relationships Between Entities,
- example of, The INTERNAL Option
- maintaining, Adding Data to the Database
- relation (table)
- defined,
- in a relational database, What Is a Relational Database?
- relational database
- explained, What Is a Relational Database?
- relational operations
- defined,
- joining, What Is a Relational Database?
- projection, What Is a Relational Database?
- selection, What Is a Relational Database?
- relationship
- defined,
- repeatable read (RR)
- defined,
- resetting ATCLOG file equations from within IMAGE/SQL utility, Setting a File Equation for ATCLOG
- result table
- defined,
- REVOKE authorities, Granting and Revoking IMAGE/SQL Authorities
- ROLLBACK WORK, Using the INSERT Statement
- root file, Defining the TurboIMAGE/XL Database
- corresponding IMAGE/SQL term, Moving from TurboIMAGE/XL to IMAGE/SQL
- differences from IMAGE/SQL DBECon file, Root File versus DBECon File and System Catalog
- row
- corresponding TurboIMAGE/XL term, Moving from TurboIMAGE/XL to IMAGE/SQL
- defined,
- in a relational database table, Rows and Columns
- rule
- defined,
S- schema
- defined,
- in IMAGE/SQL and TurboIMAGE/XL, Creating Databases
- script for sample database, Setting Up MUSIC and MusicDBE
- security, How Do I Control Database Access?
- in IMAGE/SQL and TurboIMAGE/XL, Defining Security
- scheme, Defining the Security Scheme
- SELECT, What Is a Relational Database?, Examining The Database, Selecting Data
- selecting data, Selecting Data
- selecting TurboIMAGE/XL data with ALLBASE/SQL
- example of, Accessing TurboIMAGE/XL Data with ISQL
- getting ready, Accessing TurboIMAGE/XL Data with ISQL
- reference information for, Accessing TurboIMAGE/XL Data with ISQL
- selection
- defined,
- serial scan
- defined,
- SET commands
- used before displaying IMAGE/SQL utility information, Displaying IMAGE/SQL Utility Information
- set part of TurboIMAGE/XL database, Defining the TurboIMAGE/XL Database
- 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 a database with ISQL, Setting Up a Database with ISQL
- SMALLINT data types, Mapping of Data Types
- SQL
- CONNECT, How Do I Access a Database through SQL?
- defined,
- explained, What Is SQL?
- SQLGEN
- component of IMAGE/SQL, SQLGEN
- defined,
- SQLUtil, Setting Up MUSIC and MusicDBE
- component of IMAGE/SQL, SQLUtil
- defined,
- using to set DBEnvironment maintenance word, Listing the Newly Created Files
- standards
- ANSI and X/OPEN, What Is SQL?
- START DBE, How Do I Create a DBEnvironment?
- structured query language
- defined,
- explained, What Is SQL?
- types of statements, What Is SQL?
- subquery
- defined,
- SYSTEM
- DBEFileSet containing system catalog, System Catalog
- defined,
- system catalog
- corresponding TurboIMAGE/XL term, Moving from TurboIMAGE/XL to IMAGE/SQL
- defined,
- differences from TurboIMAGE/XL root file, Root File versus DBECon File and System Catalog
- explained, System Catalog
- system table
- defined,
- system view
- defined,
T- table
- as database object, Tables
- corresponding TurboIMAGE/XL term, Moving from TurboIMAGE/XL to IMAGE/SQL
- defined,
- differences from TurboIMAGE/XL data set, Tables versus Data Sets
- in a relational database, What Is a Relational Database?
- rows and columns in, Rows and Columns
- sample in a relational database, Sample Database Table
- using several, Using Several Tables
- table authority
- defined,
- task reference information
- configuring a DBEnvironment, Listing the Newly Created Files
- detaching a TurboIMAGE/XL database, Detaching a TurboIMAGE/XL Database
- logging IMAGE/SQL utility commands, Logging IMAGE/SQL Utility Commands
- maintaining the ATCINFO file, Maintaining the ATCINFO File
- selecting TurboIMAGE/XL data with ALLBASE/SQL, Accessing TurboIMAGE/XL Data with ISQL
- setting IMAGE/SQL utility file equations, ATCINFO Reference
- using IMAGE/SQL utility command files in batch, Using IMAGE/SQL Utility Command Files
- using IMAGE/SQL utility command files interactively, Using IMAGE/SQL Utility Command Files
- tasks
- accessing TurboIMAGE/XL data with ISQL, Accessing TurboIMAGE/XL Data with ISQL
- adding data to the sample database, Adding Data to the Database
- attaching a TurboIMAGE/XL database, Attaching a TurboIMAGE/XL Database
- committing work, Using the INSERT Statement
- configuring a DBEnvironment, Configuring a DBEnvironment
- creating a DBEnvironment, Creating a DBEnvironment
- deleting data, Deleting Data
- detaching a TurboIMAGE/XL database, Detaching a TurboIMAGE/XL Database
- displaying IMAGE/SQL utility information, Displaying IMAGE/SQL Utility Information
- displaying TurboIMAGE/XL database information, Displaying IMAGE/SQL Utility Information
- examining authority structure, Examining the Authority Structure
- examining table description, Examining Table Descriptions
- examining the database, Examining The Database
- issuing MPE/iX commands from IMAGE/SQL utility, Issuing MPE/iX Commands from the IMAGE/SQL Utility
- logging IMAGE/SQL utility commands, Logging IMAGE/SQL Utility Commands
- maintaining the ATCINFO file, Maintaining the ATCINFO File
- modifying data, Modifying Data
- rolling back work, Using the INSERT Statement, The EXTERNAL Option, The INTERNAL Option
- running ISQL, Running ISQL
- selecting data, Selecting Data
- selecting TurboIMAGE/XL data with ALLBASE/SQL, Accessing TurboIMAGE/XL Data with ISQL
- setting IMAGE/SQL file equations for ATCINFO, Setting a File Equation for ATCINFO
- setting IMAGE/SQL file equations for ATCLOG, Setting a File Equation for ATCLOG
- setting up a database, Setting Up a Database with ISQL
- setting up the sample MUSIC database, Setting Up MUSIC and MusicDBE
- setting up the sample MusicDBE DBEnvironment, Setting Up MUSIC and MusicDBE
- using IMAGE/SQL utility command files, Using IMAGE/SQL Utility Command Files
- using the sample DBEnvironment, Practicing with IMAGE/SQL Using MusicDBE
- third-party tools, Tools For IMAGE/SQL
- tools for IMAGE/SQL, Tools For IMAGE/SQL
- transaction
- defined,
- ended with COMMIT WORK, Using the INSERT Statement
- TurboIMAGE/XL
- basic structure, Basic Structures
- compared with IMAGE/SQL, Moving from TurboIMAGE/XL to IMAGE/SQL
- creating a database, Creating the TurboIMAGE/XL Database
- defined, TurboIMAGE/XL
- defining a database, Defining the TurboIMAGE/XL Database
- detaching a database, Detaching a TurboIMAGE/XL Database
- explained, What Is TurboIMAGE/XL?
- security, TurboIMAGE/XL Security
- transition to IMAGE/SQL, Moving from TurboIMAGE/XL to IMAGE/SQL
|