 |
» |
|
|
|
A- accessing a database
- explained, How Do I Access a Database?
- ad hoc query
- defined, Ad Hoc Query
- adding
- DBEFiles to DBEFileSets, Adding DBEFiles to DBEFileSets
- ALLBASE/4GL
- component of ALLBASE/SQL, ALLBASE/4GL
- ALLBASE/Net
- component of ALLBASE/SQL, ALLBASE/Net
- ALLBASE/Query
- component of ALLBASE/SQL, ALLBASE/Query
- ALLBASE/SQL
- components, SQLCore and DBCore
- document set, Where Can I Get Help with ALLBASE/SQL?
- sample DBEnvironment PartsDBE, Practice with ALLBASE/SQL Using PartsDBE
- tasks, Where Can I Get Help with ALLBASE/SQL?
- ALLBASE/Turbo CONNECT
- component of ALLBASE/SQL, ALLBASE/Turbo CONNECT
- selecting TurboIMAGE data from ALLBASE/SQL, Using ALLBASE/Turbo CONNECT
- application program
- relationship to database design, Designing Applications
- archive logging
- defined, Archive Logging
- attribute
- defined, Attribute
- explained, Listing Attributes
- authorities
- granting, Granting Authorities
- in the sample DBEnvironment PartsDBE, Examining the Authority Structure
- in the security design, Designing Database Security Schemes
- authority
- defined, Authority
- authority in ALLBASE/SQL
- explained, How Do I Control Database Access?
- authorization group
- defined, Authorization Group
- in the sample DBEnvironment PartsDBE, Groups
- automatic master
- differences from ALLBASE/SQL index, Automatic Masters versus Indexes
C- C
- coding a cursor SELECT statement, Adding a Multiple Row SELECT Statement
- coding a display statement, Coding Statements to Display Data
- coding a FETCH and display loop, Adding a FETCH and Display Loop
- coding an error checking routine, Adding an Explicit Error Checking Routine
- coding the CONNECT and RELEASE statement, Coding the CONNECT and RELEASE Statements
- coding the cursor declarations, Adding the Cursor Declaration
- coding the host variable declarations, Coding the Host Variable Declarations, Adding Additional Host Variable Declarations
- coding the INCLUDE statement, Coding the INCLUDE Statement
- coding the SELECT statement, Coding the SELECT Statement
- compiling and linking, Compiling and Linking the Program
- correcting errors in the source program, Debugging the Program
- displaying preprocessor output files, Using the Preprocessor
- running the preprocessor, Using the Preprocessor
- summary of steps in embedded SQL programming, Summary of Steps
- testing the indicator variable, Coding the SELECT Statement
- C application program
- creating, Creating a C Application in HP-UX
- sample applications for PartsDBE, Sample Application Programs
- check constraint
- defined, Check Constraint
- class
- defined, Class
- clustering index
- defined, Clustering Index
- COBOL
- coding a cursor SELECT statement, Adding a Multiple Row SELECT Statement
- coding a DISPLAY statement, Coding Statements to Display Data
- coding a FETCH and display loop, Adding a FETCH and Display Loop
- coding an error checking routine, Adding an Explicit Error Checking Routine
- coding the CONNECT and RELEASE statement, Coding the CONNECT and RELEASE Statements
- coding the cursor declarations, Adding the Cursor Declaration
- coding the host variable declarations, Coding the Host Variable Declarations, Adding Additional Host Variable Declarations
- coding the INCLUDE statement, Coding the INCLUDE Statement
- coding the SELECT statement, Coding the SELECT Statement
- compiling and linking, Compiling and Linking the Program
- correcting errors in the source program, Debugging the Program
- displaying preprocessor output files, Using the Preprocessor
- running the preprocessor, Using the Preprocessor
- summary of steps in embedded SQL programming, Summary of Steps
- testing the indicator variable, Coding Statements to Display Data
- COBOL application program
- creating, Creating an Embedded SQL COBOL Application
- sample applications for PartsDBE, Sample Application Programs
- coding in C
- CONNECT statement, Coding the CONNECT and RELEASE Statements
- cursor declaration, Adding the Cursor Declaration
- cursor SELECT statement, Adding a Multiple Row SELECT Statement
- display statement, Coding Statements to Display Data
- error checking routine, Adding an Explicit Error Checking Routine
- FETCH and display loop, Adding a FETCH and Display Loop
- host variable declarations, Coding the Host Variable Declarations, Adding Additional Host Variable Declarations
- INCLUDE statement, Coding the INCLUDE Statement
- RELEASE statement, Coding the CONNECT and RELEASE Statements
- SELECT statement, Coding the SELECT Statement
- testing the indicator variable, Coding the SELECT Statement
- coding in COBOL
- CONNECT statement, Coding the CONNECT and RELEASE Statements
- cursor declaration, Adding the Cursor Declaration
- cursor SELECT statement, Adding a Multiple Row SELECT Statement
- DISPLAY statement, Coding Statements to Display Data
- error checking routine, Adding an Explicit Error Checking Routine
- FETCH and display loop, Adding a FETCH and Display Loop
- host variable declarations, Coding the Host Variable Declarations, Adding Additional Host Variable Declarations
- INCLUDE statement, Coding the INCLUDE Statement
- RELEASE statement, Coding the CONNECT and RELEASE Statements
- SELECT statement, Coding the SELECT Statement
- testing the indicator variable, Coding Statements to Display Data
- column
- and key, From Entities to Tables
- defined, Column
- in a relational database table, Rows and Columns
- index on, Defining Indexes
- column authorization
- defined, Column Authorization
- in the sample DBEnvironment PartsDBE, Column Authorizations
- column list
- defined, Column List
- using in a query, Performing Queries
- COMMIT WORK statement (SQL)
- why necessary, Committing Work
- compiler
- running the C, Compiling and Linking the Program
- running the COBOL, Compiling and Linking the Program
- components of ALLBASE/SQL
- listed, SQLCore and DBCore
- concurrency
- defined, Concurrency
- concurrency control
- in ALLBASE/SQL and TurboIMAGE, Differences in Concurrency Control
- CONNECT authorization
- in the security design, Designing Database Security Schemes
- CONNECT statement (SQL)
- coding in C, Coding the CONNECT and RELEASE Statements
- coding in COBOL, Coding the CONNECT and RELEASE Statements
- constraint
- defined, Constraint
- correcting errors
- in the C source program, Debugging the Program
- in the COBOL source program, Debugging the Program
- creating
- C application program, Creating a C Application in HP-UX
- COBOL application program, Creating an Embedded SQL COBOL Application
- DBEFile, Creating DBEFiles for Table and Index Data
- DBEFileSet, Creating DBEFileSets
- DBEnvironment, Creating a DBEnvironment
- group, Granting Authorities
- index, Creating an Index
- table, Creating Tables
- view, Creating Views
- creating a database
- basic explanation, How Do I Create a Database?
- statements used in, Statements to Create Databases
- creating a DBEnvironment
- basic explanation, How Do I Create a DBEnvironment?
- cursor declaration
- coding in C, Adding the Cursor Declaration
- coding in COBOL, Adding the Cursor Declaration
- cursor SELECT statement
- coding in C, Adding a Multiple Row SELECT Statement
- coding in COBOL, Adding a Multiple Row SELECT Statement
- cursor stability (CS)
- defined, Cursor Stability (CS)
D- data analysis
- basic explanation, Using Several Tables
- defined, Data Analysis
- full explanation, Looking at Data
- data control language
- defined, Data Control Language
- explained, How Do I Control Database Access?
- data definition
- defined, Data Definition
- language defined, Data Definition Language
- process explained, How Do I Create a Database?
- data file
- differences from ALLBASE/SQL DBEFile, Data Files for Data sets versus DBEFiles for Tables
- data manipulation
- defined, Data Manipulation
- data manipulation language
- defined, Data Manipulation Language
- explained, Queries and Other Data Manipulation
- data set
- differences from ALLBASE/SQL table, Tables and Indexes versus Data Sets
- data size
- in relational table, Data Types and Sizes
- data type
- character data, Character Data
- defined, Data Type
- in ALLBASE/SQL and TurboIMAGE, Mapping of Data Types
- in relational table, Data Types and Sizes
- database
- defined, Database
- explained, What Is a Database?, Databases
- in ALLBASE/SQL and TurboIMAGE, Procedures for Starting Up
- database access
- in ALLBASE/SQL and TurboIMAGE, Differences in Accessing Databases
- database administrator (DBA)
- defined, Database Administrator (DBA)
- explained, SQLUtil
- database design
- basic explanation, Using Several Tables
- defined, Database Design
- full explanation, Looking at Data
- DBA authority
- defined, DBA Authority
- explained, How Do I Control Database Access?
- DBCore
- component of ALLBASE/SQL, SQLCore and DBCore
- defined, DBCore
- DBECon file
- defined, DBECon File
- differences from TurboIMAGE root file, Root File versus DBECon File and System Catalog
- explained, The DBECon File
- name and content, DBECon File
- DBECreator
- defined, DBECreator
- explained, How Do I Control Database Access?
- DBEFile
- adding to DBEFileSets, Adding DBEFiles to DBEFileSets
- creating, Creating DBEFiles for Table and Index Data
- defined, DBEFile
- differences from TurboIMAGE data file, Data Files for Data sets versus DBEFiles for Tables
- explained, DBEFiles
- DBEFile0
- DBEFile containing system catalog, System Catalog
- name and content, DBEFile0
- DBEFileSet
- adding DBEFiles to, Adding DBEFiles to DBEFileSets
- creating, Creating DBEFileSets
- defined, DBEFileSet
- explained, DBEFileSets
- same for table and its indexes, Location of Tables and Indexes
- DBEnvironment
- creating, Creating a DBEnvironment
- default files in, Creating a DBEnvironment
- defined, DBEnvironment
- differences from TurboIMAGE, Procedures for Starting Up
- explained, What Is a DBEnvironment?
- DBEUserid
- defined, DBEUserID
- design
- character data, Character Data
- data type and size in tables, Data Type and Size
- NULL values, NULL Values
- display statement
- coding in C, Coding Statements to Display Data
- coding in COBOL, Coding Statements to Display Data
- displaying
- output files from C preprocessor, Using the Preprocessor
- output files from COBOL preprocessor, Using the Preprocessor
E- embedded SQL C programming
- explained, How ALLBASE/SQL Programming Works
- embedded SQL COBOL programming
- explained, How ALLBASE/SQL Programming Works
- embedded SQL program
- defined, Embedded SQL Program
- entity
- and index definition, Defining Indexes
- and table definition, From Entities to Tables
- defined, Entity
- explained, Listing Entities
- error checking routine
- coding in C, Adding an Explicit Error Checking Routine
- coding in COBOL, Adding an Explicit Error Checking Routine
- errors
- displaying messages, Coding the Routine, Coding the Routine
- testing for, Creating an Error Condition for the Application, Coding the Routine
- examining
- system catalog, Examining the System Catalog
- explicit locking
- defined, Explicit Locking
- expression
- defined, Expression
- external
- LOAD command (ISQL), LOADing from an EXTERNAL File
F- FETCH and display loop
- coding in C, Adding a FETCH and Display Loop
- coding in COBOL, Adding a FETCH and Display Loop
- file space
- estimating, Estimating Table and Index Size
- files
- DBECon file, DBECon File
- DBEFile0, DBEFile0
- default in a DBEnvironment, Creating a DBEnvironment
- in the sample DBEnvironment PartsDBE, Looking at the Files Created for PartsDBE
- log file, Log File
- output from C preprocessor, Using the Preprocessor
- output from COBOL preprocessor, Using the Preprocessor
- foreign key
- defined, Foreign Key
- FORTRAN application program
- sample applications for PartsDBE, Sample Application Programs
I- implicit locking
- defined, Implicit Locking
- INCLUDE statement (SQL)
- coding in C, Coding the INCLUDE Statement
- coding in COBOL, Coding the INCLUDE Statement
- index
- and entity in design, Defining Indexes
- as database object, Tables and Indexes
- creating, Creating an Index
- defined, Index
- differences from TurboIMAGE automatic master, Automatic Masters versus Indexes
- estimating space for, Estimating Table and Index Size
- examining in the sample DBEnvironment PartsDBE, Examining Indexes
- in same DBEFileSet as table, Location of Tables and Indexes
- to support a join, Defining Indexes
- type of DBEFile, Creating DBEFiles for Table and Index Data
- index scan
- defined, Index Scan
- indicator variable
- explained, Coding the Host Variable Declarations, Coding the Host Variable Declarations
- testing in C, Coding the SELECT Statement
- testing in COBOL, Coding Statements to Display Data
- INFO command (ISQL)
- using to obtain column information, Using the INFO Command
- INSERT statement (SQL)
- entering data with, Entering Data with the SQL INSERT Statement
- integrity constraint
- defined, Integrity Constraint
- interactive access to data
- in ALLBASE/SQL and TurboIMAGE, Interactive Access
- internal
- LOAD command (ISQL), LOADing from an INTERNAL File
- isolation level
- defined, Isolation Level
- ISQL
- component of ALLBASE/SQL, ISQL
- defined, ISQL
- how to run, Running ISQL
P- Pascal application program
- sample applications for PartsDBE, Sample Application Programs
- PC API
- component of ALLBASE/SQL, PC API
- permissions in ALLBASE/SQL
- explained, How Do I Control Database Access?
- predicate
- defined, Predicate
- using in a query, Performing Queries
- preprocessor
- and the sample applications for PartsDBE, Sample Application Programs
- and the sample DBEnvironment PartsDBE, Using the Preprocessors
- component of ALLBASE/SQL, Preprocessors
- defined, Preprocessor
- running the C, Using the Preprocessor
- running the COBOL, Using the Preprocessor
- primary key
- defined, Primary Key
- procedure
- defined, Procedure
- programmatic access to data
- in ALLBASE/SQL and TurboIMAGE, Programmatic Access
- programming in C
- embedded SQL, explained, How ALLBASE/SQL Programming Works
- programming in COBOL
- embedded SQL, explained, How ALLBASE/SQL Programming Works
- projection
- defined, Projection
- purging
- sample DBEnvironment PartsDBE, Purging PartsDBE
Q- query
- defined, Query
- explained, What Is a Relational Database?
- performing, Performing Queries
- performing on system tables, Examining the System Catalog
- relational operations in, What Is a Relational Database?
- specifying a join, Performing Queries
- using a column list in, Performing Queries
- using a predicate in, Performing Queries
- query language
- defined, Query Language
- explained, What Is SQL?
- query result
- defined, Query Result
- explained, Queries and Other Data Manipulation
R- read committed (RC)
- defined, Read Committed (RC)
- read uncommitted (RU)
- defined, Read Uncommitted (RU)
- referential constraint
- defined, Referential Constraint
- referential integrity
- in ALLBASE/SQL and TurboIMAGE, Master/Detail versus Referential Integrity
- relation (table)
- defined, Relation
- in a relational database, What Is a Relational Database?
- relational database
- explained, What Is a Relational Database?
- relational operations
- defined, Relational Operations
- joining, What Is a Relational Database?
- projection, What Is a Relational Database?
- selection, What Is a Relational Database?
- relationship
- defined, Relationship
- explained, Identifying Relationships between Entities
- RELEASE statement (SQL)
- coding in C, Coding the CONNECT and RELEASE Statements
- coding in COBOL, Coding the CONNECT and RELEASE Statements
- repeatable read (RR)
- defined, Repeatable Read (RR)
- result table
- defined, Result Table
- explained, Queries and Other Data Manipulation
- rollback recovery
- defined, Rollback Recovery
- ROLLBACK WORK statement (SQL)
- ending transactions with, Committing Work
- rollforward recovery
- defined, Rollforward Recovery
- root file
- differences from ALLBASE/SQL DBECon file, Root File versus DBECon File and System Catalog
- row
- defined, Row
- in a relational database table, Rows and Columns
- rule
- defined, Rule
- run authority
- defined, Run Authority
- running
- the C compiler, Compiling and Linking the Program
- the C preprocessor, Using the Preprocessor
- the COBOL compiler, Compiling and Linking the Program
- the COBOL preprocessor, Using the Preprocessor
S- schema
- defined, Schema
- in ALLBASE/SQL and TurboIMAGE, Use of a Schema
- section
- defined, Section
- security
- in ALLBASE/SQL and TurboIMAGE, Differences in Security
- security scheme
- designing, Designing Database Security Schemes
- SELECT statement (SQL)
- coding in C, Coding the SELECT Statement
- coding in C for multiple rows, Adding a Multiple Row SELECT Statement
- coding in COBOL, Coding the SELECT Statement
- coding in COBOL for multiple rows, Adding a Multiple Row SELECT Statement
- coding with a cursor in C, Adding a Multiple Row SELECT Statement
- coding with a cursor in COBOL, Adding a Multiple Row SELECT Statement
- serial scan
- defined, Serial Scan
- setup scripts
- using to set up a sample DBEnvironment, Using Setup Scripts
- size
- of data, Data Types and Sizes
- of DBEFile pages, Creating DBEFiles for Table and Index Data
- sort items in TurboIMAGE
- differences from ALLBASE/SQL indexes , Sort Items versus Indexes
- special authority
- defined, Special Authority
- SQL
- defined, SQL
- SQL (structured query language)
- explained, Very Basic...
- SQL programming
- C, How ALLBASE/SQL Programming Works
- COBOL, How ALLBASE/SQL Programming Works
- SQLCODE
- checking after SQL statements, Adding an Explicit Error Checking Routine, Coding the Routine
- SQLCore
- component of ALLBASE/SQL, SQLCore and DBCore
- defined, SQLCore
- SQLGEN
- component of ALLBASE/SQL, SQLGEN
- creating a schema file with, Creating a Schema File with SQLGEN
- defined, SQLGEN
- SQLMigrate
- defined, SQLMigrate
- SQLSetup
- using to set up a sample DBEnvironment, Using SQLSetup
- SQLUtil
- component of ALLBASE/SQL, SQLUtil
- defined, SQLUtil
- examining startup parameters in PartsDBE, Examining Startup Parameters with SQLUtil
- standards
- ANSI and X/OPEN, Very Basic...
- starting a DBEnvironment
- basic explanation, How Do I Create a DBEnvironment?
- statistics
- updating, Updating Statistics in the System Catalog
- structured query language
- defined, Structured Query Language
- explained, Very Basic...
- types of statements, What Is SQL?
- subquery
- defined, Subquery
- SYSTEM
- DBEFileSet containing system catalog, System Catalog
- defined, SYSTEM
- system catalog
- defined, System Catalog
- examining, Examining the System Catalog
- explained, System Catalog
- updating statistics, Updating Statistics in the System Catalog
- SYSTEM DBEFileSet
- adding DBEFiles to, Adding a DBEFile to the SYSTEM DBEFileSet
- system table
- defined, System Table
- system view
- defined, System View
T- table
- and entity in design, From Entities to Tables
- as database object, Tables and Indexes
- creating, Creating Tables
- data type and size, Data Type and Size
- defined, Table
- designing, Creating the Table Design
- differences from TurboIMAGE data set, Tables and Indexes versus Data Sets
- entering data into, Entering Data into Tables
- estimating space for, Estimating Table and Index Size
- examining the list in the sample DBEnvironment PartsDBE, Examining the Tables and Views
- in a relational database, What Is a Relational Database?
- in same DBEFileSet as index, Location of Tables and Indexes
- PUBLIC, Creating the Albums Table
- rows and columns in, Rows and Columns
- sample in a relational database, Sample Database Table
- type of DBEFile, Creating DBEFiles for Table and Index Data
- using INFO to obtain column information, Using the INFO Command
- table authority
- defined, Table Authority
- in the sample DBEnvironment PartsDBE, Table Authorities
- in the security design, Designing Database Security Schemes
- tasks
- adding a DBEFile to the SYSTEM DBEFileSet, Adding a DBEFile to the SYSTEM DBEFileSet
- adding DBEFiles to DBEFileSets, Adding DBEFiles to DBEFileSets
- C compiling and linking, Compiling and Linking the Program
- COBOL compiling and linking, Compiling and Linking the Program
- commiting work, Committing Work
- creating a DBEFile, Creating DBEFiles for Table and Index Data
- creating a DBEFileSet, Creating DBEFileSets
- creating a DBEnvironment, Creating a DBEnvironment
- creating a table, Creating Tables
- creating a view , Creating Views
- creating an index , Creating an Index
- creating authorization groups, Granting Authorities
- entering data into a table, Entering Data into Tables
- examining the system catalog, Examining the System Catalog
- granting authorities, Granting Authorities
- in ALLBASE/SQL, Where Can I Get Help with ALLBASE/SQL?
- loading from an external file, LOADing from an EXTERNAL File
- loading from an internal file, LOADing from an INTERNAL File
- performing a query, Performing Queries
- purging the sample DBEnvironment PartsDBE, Purging PartsDBE
- rolling back work, Committing Work
- running ISQL, Running ISQL
- running the C preprocessor, Using the Preprocessor
- running the COBOL preprocessor, Using the Preprocessor
- setting up the sample DBEnvironment PartsDBE, Setting up PartsDBE
- updating statistics in the system catalog, Updating Statistics in the System Catalog
- using the INSERT statement for data entry, Entering Data with the SQL INSERT Statement
- using the ISQL LOAD command for data entry, Entering Data with the ISQL LOAD Command
- transaction
- defined, Transaction
- ended with COMMIT WORK, Committing Work
- TurboIMAGE
- compared with ALLBASE/SQL, Comparing ALLBASE/SQL with TurboIMAGE
- tutorials
- building a C application, Building an ALLBASE/SQL\C Application in HP-UX
- building a COBOL application, Building an ALLBASE/SQL\COBOL Application in MPE/iX
- setting up a database with ISQL, Setting Up a Database with ISQL
- using the sample DBEnvironment PartsDBE, Practice with ALLBASE/SQL Using PartsDBE
- type
- of data, Data Types and Sizes
|
