HPlogo ALLBASE/SQL C Application Programming Guide: HP 3000 MPE/iX Computer Systems

Index
» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

spacerspacerspacer
spacer
spacer
  		   

Symbols

[BULK] SELECT command
used with LONG columns, Retrieving LONG Column Data with a [BULK] SELECT, FETCH, or REFETCH Command

A

active set
re-access, CLOSE
ADD_MONTHS function
example with BULK SELECT, Example ADD_MONTHS Function
syntax, Using the Date/Time ADD_MONTHS Function
aggregate function
simple data manipulation, SELECT
ALTER TABLE command
syntax for LONG columns, Defining LONG Columns with a CREATE TABLE or ALTER TABLE Command
ANSI SQL1 level 2
specifying a default value, Using Default Data Values
ANSI SQL86 level 2
floating point data, FLOAT Data
ANSI standards
sqlcode, Using the sqlca
arrays
BULK SELECT, Bulk Processing Variables
character data, CHAR Data
declarations of, Declaring Variables for Program Elements
in sqlda declaration, Setting up a Buffer for Query Results of Unknown Format
referencing, Variables Used in BULK Processing
atomic operation
defined, Maintaining Data Consistency
authorization
changing, Updating Application Programs
dynamic preprocessing, Differences between Dynamic and Non-Dynamic Preprocessing
granting, Granting Module Owner Authorizations
program development, Authorizations
program maintenance, Updating Application Programs
automatic rollback, sqlwarn[6]

B

basic SQL statements, Creating Source Files
BEGIN DECLARE SECTION
declaring host variables, Creating Declaration Sections
delimiting the declare section, Source File
BEGIN WORK
in transaction management, Transaction Management for Simple Operations
binary data
compatibility, Binary Data Compatibility
host variable definition, Binary Data Compatibility
using the LONG phrase with, Using the LONG Phrase with Binary Data Types
BULK FETCH
basic uses of, BULK FETCH
BULK FETCH command
used in example program, Example Program cex9a
with TO_INTEGER function, Example TO_INTEGER Function
BULK INSERT
basic uses of, BULK INSERT
BULK INSERT command
used in example program, Example Program cex9a
used with LONG columns, Putting Data into a LONG Column with a [BULK] INSERT Command
using host variables for LONG column I/O strings, Bulk Insert Using Host Variables for LONG Column I/O Strings
with LONG columns
example data file, Example Data File
example program, Example
BULK option
not used for dynamic FETCH, Preprocessing of Dynamic Queries
bulk processing
INTO clause, Bulk Processing Variables
bulk processing variables, Bulk Processing Variables
BULK SELECT
basic uses, BULK SELECT
BULK SELECT command
used with LONG columns, Using LONG Columns with a BULK SELECT Command
with ADD_MONTHS function, Example ADD_MONTHS Function
BULK table processing
BULK FETCH, BULK FETCH
BULK INSERT, BULK INSERT
BULK SELECT, BULK SELECT
commands, SQL Bulk Commands
sample program, Sample Program Using BULK Processing
techniques, BULK Table Processing

C

cex10a, cex10a: Program for Dynamic Commands of Unknown Format
cex10b, cex10b: Program Using Dynamic Commands of Known Format
cex2, Sample Modified Source File
source code, Looking at an Embedded SQL Source Program
cex2.c
preprocessor modified source code, Sample Modified Source File
cex5, Program Illustrating Implicit and Explicit Status Checking
cex7, Sample Program Using Simple DML Commands
cex8, Sample Program Using Cursor Operations
cex9, Sample Program Using BULK Processing
CHAR data declaration, CHAR Data
CLOSE
after BULK FETCH, BULK FETCH
before ending a transaction, CLOSE, Transaction Management for Cursor Operations
freeing buffer space with, CLOSE
to re-access the active set, CLOSE
with COMMIT WORK, OPEN Command Using KEEP CURSOR WITH LOCKS and CS Isolation Level
with KEEP CURSOR, OPEN Command Using KEEP CURSOR WITH LOCKS and CS Isolation Level
coding considerations
for date/time functions, Coding Considerations
for LONG columns, Coding Considerations, File Naming Conventions, Considering Multiple Users, Deciding How Much Space to Allocate and Where
column specifications for floating point data, FLOAT Data
comments in SQL commands, Skeleton Program
COMMIT WORK
and revalidation of sections, Stored Module Containing Sections
in transaction management, Transaction Management for Simple Operations
issued by preprocessor, DBEnvironment Access
with CLOSE, OPEN Command Using KEEP CURSOR WITH LOCKS and CS Isolation Level
with KEEP CURSOR, OPEN Command Using KEEP CURSOR WITH LOCKS and CS Isolation Level
compatibility of variables, Declaring Variables for Compatibility
concurrency, Transaction Management for Simple Operations
CONNECT
in application programs, Granting Program User Authorization
to start a DBE session, Authorizations
CONNECT authority
and preprocessing, Authorizations
constant
as default data value, Using Default Data Values
constraint test matrix for integrity constraints, Using Unique and Referential Integrity Constraints
conversion
numeric, Numeric Data Conversion
string data, String Data Conversion
CREATE TABLE command
syntax for LONG columns, Defining LONG Columns with a CREATE TABLE or ALTER TABLE Command
current language, Native Language Support
current row
DELETE WHERE CURRENT, DELETE WHERE CURRENT
CURRENT_DATE function result
used as default data value, Using Default Data Values
CURRENT_DATETIME function result
used as default data value, Using Default Data Values
CURRENT_TIME function result
used as default data value, Using Default Data Values
cursor
and BULK FETCH, BULK FETCH
and dynamic queries, Using the Dynamic Query Data Structures
and sections, Stored Module Containing Sections
cursor processing
CLOSE, CLOSE
commands, Processing with Cursors, SQL Cursor Commands
DECLARE CURSOR, DECLARE CURSOR
definition, SQL Cursor Commands
DELETE WHERE CURRENT, DELETE WHERE CURRENT
FETCH, FETCH
OPEN, OPEN
sample program, Sample Program Using Cursor Operations
techniques, Processing with Cursors
transaction management, Transaction Management for Cursor Operations
UPDATE and FETCH, UPDATE WHERE CURRENT
UPDATE WHERE CURRENT, UPDATE WHERE CURRENT

D

data buffer
declaration, Dynamic Processing Arrays
layout, Setting Up the Data Buffer
null indicator suffix, Setting up a Buffer for Query Results of Unknown Format
parsing, Parsing the Data Buffer
rows to retrieve, Setting up a Buffer for Query Results of Unknown Format
varchar prefix, Setting up a Buffer for Query Results of Unknown Format
data compatibility
binary, Binary Data Compatibility
floating point, Floating Point Data Compatibility
for date/time function parameters, Defining and Using Host Variables with Date/Time Functions
for default data values, Coding Considerations
LONG binary, Using the LONG Phrase with Binary Data Types
LONG varbinary, Using the LONG Phrase with Binary Data Types
data consistency, Maintaining Data Consistency
in sample database, Maintaining Data Consistency
data input using date/time functions, Using Date/Time Input Functions
data integrity
changes to error checking , Comparing Statement Level and Row Level Integrity
introduction to, Programming with Constraints
number of rows processed , Comparing Statement Level and Row Level Integrity
row level versus statement level, Comparing Statement Level and Row Level Integrity
using sqlerrd[2], Comparing Statement Level and Row Level Integrity
data retrieval using date/time functions, Using Date/Time Output Functions
data structures
for dynamic query, Preprocessing of Dynamic Queries
data type
compatibility, Declaring Variables for Compatibility
conversion, String Data Conversion, Numeric Data Conversion
declarations, Declaring Variables for Data Types
equivalency, Declaring Variables for Compatibility
data types
floating point, FLOAT Data
used with LONG columns, General Concepts
date/time ADD_MONTHS function
overview, Using the Date/Time ADD_MONTHS Function
where to use, Using the Date/Time ADD_MONTHS Function
date/time data conversion
example program, Example Program cex9a
date/time functions
coding considerations, Coding Considerations
data compatibility, Defining and Using Host Variables with Date/Time Functions
example programs, Program Example for Date/Time Data
example using default format specifications, Example Using the INSERT Command
examples using ManufDB database, Examples of TO_DATETIME, TO_DATE, TO_TIME, and TO_INTERVAL Functions, Using Date/Time Output Functions, Example ADD_MONTHS Function
how used, Defining and Using Host Variables with Date/Time Functions
introduction to, Programming with ALLBASE/SQL Functions
leading zeros required for input functions, Coding Considerations
parameters for, Defining and Using Host Variables with Date/Time Functions
unspecified format elements default filled, Coding Considerations
used to add a number of months, Using the Date/Time ADD_MONTHS Function
used when inputting data, Using Date/Time Input Functions
used when retrieving data, Using Date/Time Output Functions
using host variables for format specifications, Defining and Using Host Variables with Date/Time Functions
using host variables for input and output data, Defining and Using Host Variables with Date/Time Functions
using host variables with, Defining and Using Host Variables with Date/Time Functions
where to use ADD_MONTHS, Using the Date/Time ADD_MONTHS Function
where to use input functions, Using Date/Time Input Functions
where to use output functions, Using Date/Time Output Functions
where to use TO_CHAR, Using Date/Time Output Functions
where to use TO_DATE, Using Date/Time Input Functions
where to use TO_DATETIME, Using Date/Time Input Functions
where to use TO_INTEGER, Using Date/Time Output Functions
where to use TO_INTERVAL, Using Date/Time Input Functions
where to use TO_TIME, Using Date/Time Input Functions
where used, Where Date/Time Functions Can Be Used
date/time input functions
examples, Examples of TO_DATETIME, TO_DATE, TO_TIME, and TO_INTERVAL Functions
not intended for use in select list, Using Date/Time Input Functions
overview, Using Date/Time Input Functions
where to use, Using Date/Time Input Functions
date/time output functions
examples, Example TO_CHAR Function, Example TO_INTEGER Function
overview, Using Date/Time Output Functions
where to use, Using Date/Time Output Functions, Using the Date/Time ADD_MONTHS Function
DBA authority
and preprocessing, Authorizations
and START DBE, Authorizations
DBAAuthority, Authorization
DCL defined, Understanding ALLBASE/SQL Operations
DDL defined, Understanding ALLBASE/SQL Operations
DDL operations
used with integrity constraints, Using Unique and Referential Integrity Constraints
used with LONG columns, Programming with LONG Columns
deadlock
and error recovery, Handling Runtime Errors and Warnings
status checking, Handling Deadlock and Shared Memory Problems
DECIMAL data declaration, DECIMAL Data
decimal type compatibility, Numeric Data Conversion
declaration of data
CHAR, CHAR Data
DATE, DATE, TIME, DATETIME, and INTERVAL Data
DATETIME, DATE, TIME, DATETIME, and INTERVAL Data
DECIMAL, DECIMAL Data
FLOAT, FLOAT Data
INTEGER, INTEGER Data
INTERVAL, DATE, TIME, DATETIME, and INTERVAL Data
SMALLINT, SMALLINT Data
TIME, DATE, TIME, DATETIME, and INTERVAL Data
VARCHAR, VARCHAR Data
declaration part
host variable, Declaring Host Variables
DECLARE CURSOR
FOR UPDATE OF, DECLARE CURSOR
preprocessor directive, DECLARE CURSOR
SELECT, DECLARE CURSOR
syntax, DECLARE CURSOR
used with BULK FETCH, BULK FETCH
declare section
BEGIN and END DECLARE SECTION commands, Source File
defined, Creating Declaration Sections
default data values
constant, Using Default Data Values
data compatibility, Coding Considerations
for columns allowing nulls, Using Default Data Values
in addition to null, Using Default Data Values
not used with LONG BINARY data, When the DEFAULT Clause Cannot be Used
not used with LONG columns, When the DEFAULT Clause Cannot be Used
not used with LONG VARBINARY data, When the DEFAULT Clause Cannot be Used
NULL, Using Default Data Values
result of CURRENT_DATE function, Using Default Data Values
result of CURRENT_DATETIME function, Using Default Data Values
result of CURRENT_TIME function, Using Default Data Values
USER, Using Default Data Values
default format specification example
date/time functions, Example Using the INSERT Command
defining integrity constraints, Using Unique and Referential Integrity Constraints
defining LONG columns
in a table, Defining LONG Columns with a CREATE TABLE or ALTER TABLE Command
input and output specification, Defining Input and Output with the LONG Column I/O String
with the LONG column I/O string, Defining Input and Output with the LONG Column I/O String
definitions
input device specification, Defining Input and Output with the LONG Column I/O String
LONG column I/O string, Defining Input and Output with the LONG Column I/O String
output device specification, Defining Input and Output with the LONG Column I/O String
row level integrity, Comparing Statement Level and Row Level Integrity
DELETE, DELETE
DELETE command
used with LONG columns, Removing LONG Column Data with a DELETE [WHERE CURRENT] Command
with TO_DATETIME function, Example Using the DELETE Command
DELETE WHERE CURRENT
current row, DELETE WHERE CURRENT
restrictions, DELETE WHERE CURRENT
syntax, DELETE WHERE CURRENT
DELETE WHERE CURRENT command
used with LONG columns, Removing LONG Column Data with a DELETE [WHERE CURRENT] Command
delimiting SQL commands, Skeleton Program
DESCRIBE
dynamic non-query, Preprocessing of Commands That May or May Not Be Queries
dynamic query, Preprocessing of Commands That May or May Not Be Queries
designing an application using statement level integrity, Designing an Application Using Statement Level Integrity Checks
detecting end of scan, Detecting End of Scan
DML defined, Understanding ALLBASE/SQL Operations
DML operations
used with date/time functions, Where Date/Time Functions Can Be Used
used with integrity constraints, Using Unique and Referential Integrity Constraints
used with LONG columns, Programming with LONG Columns
DROP MODULE, Updating Application Programs, Dropping Obsolete Modules, Parameters
DROP option
full preprocessing mode, Full Preprocessing Mode
dynamic command, Using Dynamic Operations
passing to ALLBASE/SQL, Passing Dynamic Commands to ALLBASE/SQL
query with known query result format, cex10b: Program Using Dynamic Commands of Known Format
query with unknown query result format, cex10a: Program for Dynamic Commands of Unknown Format
dynamic commands
and authorization, Native Language Support
dynamic FETCH
BULK option not used, Preprocessing of Dynamic Queries
dynamic FETCH command
used with LONG columns, Using LONG Columns with a Dynamic FETCH Command
dynamic operations
dynamic commands, Review of Preprocessing Events
handling non-queries, Using EXECUTE IMMEDIATE
queries vs. non-queries, Preprocessing of Commands That May or May Not Be Queries
sample programs, cex10a: Program for Dynamic Commands of Unknown Format, cex10b: Program Using Dynamic Commands of Known Format
techniques, Using Dynamic Operations
dynamic preprocessing, Review of Preprocessing Events
authorization for, Differences between Dynamic and Non-Dynamic Preprocessing
dynamic query data structures, Preprocessing of Dynamic Queries
dynamically deleting data
DELETE WHERE CURRENT command cannot be prepared, Dynamically Updating and Deleting Data
error checking strategy, Dynamically Updating and Deleting Data
dynamically updating data
error checking strategy, Dynamically Updating and Deleting Data
UPDATE WHERE CURRENT command cannot be prepared, Dynamically Updating and Deleting Data
using SELECT command with FOR UPDATE OF clause, Dynamically Updating and Deleting Data

E

END DECLARE SECTION
declaring host variables, Creating Declaration Sections
delimiting the declare section, Source File
error checking
changes for this release, Comparing Statement Level and Row Level Integrity
using sqlerrd[2], Comparing Statement Level and Row Level Integrity
when dynamically deleting data, Dynamically Updating and Deleting Data
when dynamically updating data, Dynamically Updating and Deleting Data
with row level integrity, Comparing Statement Level and Row Level Integrity
with statement level integrity, Comparing Statement Level and Row Level Integrity
example
BULK FETCH command with TO_INTEGER function, Example TO_INTEGER Function
BULK SELECT command with ADD_MONTHS function, Example ADD_MONTHS Function
DELETE command with TO_DATETIME function, Example Using the DELETE Command
INSERT command with TO_DATE function , Example Using the INSERT Command
INSERT command with TO_DATETIME function, Example Using the INSERT Command
INSERT command with TO_INTERVAL function, Example Using the INSERT Command
INSERT command with TO_TIME function, Example Using the INSERT Command
SELECT command with TO_CHAR function, Example TO_CHAR Function
SELECT command with TO_DATETIME function, Example Using the SELECT Command, Example TO_CHAR Function
SELECT command with TO_INTERVAL function, Example Using the SELECT Command
UPDATE command with TO_DATE function, Example Using the UPDATE Command
UPDATE command with TO_DATETIME function, Example Using the UPDATE Command
example application design
using integrity constraints, Designing an Application Using Statement Level Integrity Checks
example data file
BULK INSERT command with LONG columns, Example Data File
example program
BULK INSERT command with LONG columns, Example
date/time data conversion, Example Program cex9a
LONG column descriptor declaration, Example LONG Column Descriptor Declaration
examples of date/time input functions, Examples of TO_DATETIME, TO_DATE, TO_TIME, and TO_INTERVAL Functions
examples of date/time output functions, Example TO_CHAR Function, Example TO_INTEGER Function
EXECUTE
non-dynamic queries, Using PREPARE and EXECUTE
executing programs, Granting Program User Authorization
explicit status checking
defined, Runtime Status Checking and the sqlca
introduction, Approaches to Status Checking
uses of, Explicit Status Checking Techniques
externals include file
sample, Sample Preprocessor Generated Include Files

F

FETCH, FETCH
current row, FETCH
FETCH command
used dynamically with LONG columns, Using LONG Columns with a Dynamic FETCH Command
used with LONG columns, Retrieving LONG Column Data with a [BULK] SELECT, FETCH, or REFETCH Command
file IO
KEEP CURSOR, Writing Keep Cursor Applications
FLOAT data declaration, FLOAT Data
floating point data
4-byte, FLOAT Data
8-byte, FLOAT Data
column specifications, FLOAT Data
compatibility, Floating Point Data Compatibility
REAL keyword, FLOAT Data
FOR UPDATE OF
UPDATE WHERE CURRENT, DECLARE CURSOR, UPDATE WHERE CURRENT
format array
declaration, Dynamic Processing Arrays
fields, Setting Up the Format Array
manditory declaration for dynamic query, Using the Dynamic Query Data Structures
full preprocessing mode
preprocessor command, Full Preprocessing Mode

G

general rules
skeleton program, Skeleton Program
GOTO vs. GO TO, Implicit Status Checking Techniques
GRANT
for required authorities, Granting Module Owner Authorizations

H

heap space input and output, Insert Using Host Variables for LONG Column I/O Strings
host variable
bulk processing, Bulk Processing Variables
declaration, Declaring Host Variables
declaration part, Declaring Host Variables
declaration summary, VARCHAR Data
declaring for ALLBASE/SQL messages, Messages from the Message Catalog
declaring for DBEnvironment names, DBEnvironment Name
declaring for savepoints, Savepoint Numbers
indicator, Indicator Variables
initialization, Input and Output Host Variables
input, Input and Output Host Variables
names, Host Variable Names
output, Input and Output Host Variables
purpose, Using Host Variables
scope, Declaring Host Variables
uses, Host Variables
host variable scope
at preprocessing time, Declaring Host Variables
at run time, Declaring Host Variables
host variables
used for binary data, Binary Data Compatibility
used for LONG column I/O strings, Insert Using Host Variables for LONG Column I/O Strings
used with date/time functions, Defining and Using Host Variables with Date/Time Functions

I

implicit status checking
defined, Runtime Status Checking and the sqlca
usage, Approaches to Status Checking
include files
as input files, Include Files
contents, Sample Preprocessor Generated Include Files
created by preprocessor, Creating the Modified Source File
samples, Sample Preprocessor Generated Include Files
user specified, Identifying Preprocessor Input
indicator variables, Indicator Variables, Indicator Variables
location of, Indicator Variables
null, Indicator Variables
null values, FETCH
truncation, Indicator Variables
INFO command
and null indicator variables, Declaring Variables for Compatibility
and null values, Declaring Variables for Compatibility
and type compatibility, Declaring Variables for Compatibility
input device specification
definition, Defining Input and Output with the LONG Column I/O String
INSERT
and simple data manipulation, INSERT
INSERT command
used with LONG columns, Putting Data into a LONG Column with a [BULK] INSERT Command
using host variables for LONG column I/O strings, Insert Using Host Variables for LONG Column I/O Strings
with TO_DATE function, Example Using the INSERT Command
with TO_DATETIME function, Example Using the INSERT Command
with TO_INTERVAL function, Example Using the INSERT Command
with TO_TIME function, Example Using the INSERT Command
INSTALL, Updating Application Programs, Running the Program
installable module file, Installable Module File
INTEGER data declaration, INTEGER Data
integrity constraint definition, Using Unique and Referential Integrity Constraints
integrity constraints
and statement level integrity, Using Unique and Referential Integrity Constraints
commands used with, Using Unique and Referential Integrity Constraints
constraint test matrix, Using Unique and Referential Integrity Constraints
designing an application, Designing an Application Using Statement Level Integrity Checks
example application using RecDB database, Designing an Application Using Statement Level Integrity Checks
in RecDB database, Designing an Application Using Statement Level Integrity Checks
introduction to, Programming with Constraints
restrictions, Using Unique and Referential Integrity Constraints
unique and referential, Using Unique and Referential Integrity Constraints

K

KEEP CURSOR
file IO, Writing Keep Cursor Applications
terminal IO, Writing Keep Cursor Applications
KEEP CURSOR WITH NOLOCKS command
use with OPEN command , OPEN

L

language
current language, Native Language Support
native language support, Native Language Support
logging, Description
LONG binary data
compatibility, Using the LONG Phrase with Binary Data Types
definition, Using the LONG Phrase with Binary Data Types
how stored, Using the LONG Phrase with Binary Data Types
LONG binary versus LONG varbinary data usage, Using the LONG Phrase with Binary Data Types
LONG column definition
in a table, Defining LONG Columns with a CREATE TABLE or ALTER TABLE Command
input and output specification , Defining Input and Output with the LONG Column I/O String
with the LONG column I/O string, Defining Input and Output with the LONG Column I/O String
LONG column descriptor
contents of, Using the LONG Column Descriptor
example declaration, Example LONG Column Descriptor Declaration
general concept, General Concepts
how used, Using the LONG Column Descriptor
introduction to, Defining Input and Output with the LONG Column I/O String
LONG column I/O string
general concept, General Concepts
heap space input and output, Insert Using Host Variables for LONG Column I/O Strings
how used , Defining Input and Output with the LONG Column I/O String
input device specification, Defining Input and Output with the LONG Column I/O String
output device specification, Defining Input and Output with the LONG Column I/O String
used with [BULK] INSERT command, Bulk Insert Using Host Variables for LONG Column I/O Strings
used with host variable, Insert Using Host Variables for LONG Column I/O Strings
used with INSERT command, Insert Using Host Variables for LONG Column I/O Strings
LONG columns
changing data, Changing a LONG Column with an UPDATE [WHERE CURRENT] Command
coding considerations, Coding Considerations
commands used with, Programming with LONG Columns
considering multiple users, Considering Multiple Users
data types used with, General Concepts
deciding on space allocation, Deciding How Much Space to Allocate and Where
deleting data, Removing LONG Column Data with a DELETE [WHERE CURRENT] Command
file usage from an application, Defining Input and Output with the LONG Column I/O String
general concepts, General Concepts
input options, Defining Input and Output with the LONG Column I/O String
introduction to, Programming with LONG Columns
maximum per table definition, Defining LONG Columns with a CREATE TABLE or ALTER TABLE Command
output options, Defining Input and Output with the LONG Column I/O String
performance, Defining LONG Columns with a CREATE TABLE or ALTER TABLE Command
putting data in, Putting Data into a LONG Column with a [BULK] INSERT Command
restrictions, Restrictions
retrieving data from, Retrieving LONG Column Data with a [BULK] SELECT, FETCH, or REFETCH Command
size maximum, General Concepts
specifying a DBEFileSet, Defining LONG Columns with a CREATE TABLE or ALTER TABLE Command
storage, Defining LONG Columns with a CREATE TABLE or ALTER TABLE Command
storing and retrieving data, General Concepts
used with [BULK] INSERT command, Putting Data into a LONG Column with a [BULK] INSERT Command
used with [BULK] SELECT command, Retrieving LONG Column Data with a [BULK] SELECT, FETCH, or REFETCH Command
used with DELETE [WHERE CURRENT] command, Removing LONG Column Data with a DELETE [WHERE CURRENT] Command
used with dynamic FETCH command, Using LONG Columns with a Dynamic FETCH Command
used with FETCH or REFETCH commands, Retrieving LONG Column Data with a [BULK] SELECT, FETCH, or REFETCH Command
used with UPDATE [WHERE CURRENT] command, Changing a LONG Column with an UPDATE [WHERE CURRENT] Command
using file naming conventions, File Naming Conventions
using file versus heap space, File versus Random Heap Space
using the LONG column descriptor, Using the LONG Column Descriptor
LONG phrase
used with binary data, Using the LONG Phrase with Binary Data Types
used with varbinary data, Using the LONG Phrase with Binary Data Types
LONG varbinary data
compatibility, Using the LONG Phrase with Binary Data Types
definition, Using the LONG Phrase with Binary Data Types
how stored, Using the LONG Phrase with Binary Data Types

M

maintaining ALLBASE/SQL programs, Maintaining ALLBASE/SQL Applications
ManufDB database
examples using date/time functions, Examples of TO_DATETIME, TO_DATE, TO_TIME, and TO_INTERVAL Functions, Using Date/Time Output Functions, Example ADD_MONTHS Function
message catalog, ALLBASE/SQL Message File
default, Running the Program, Source File
native language, Running the Program, Source File
preprocessor input, Source File
message catalog number
related to sqlcode, sqlcode
message file, ALLBASE/SQL Message File
messages from SQLEXPLAIN
when produced, sqlcode
modified source file
contents, Modified Source File
created by preprocessor, Creating the Modified Source File
creation, Modified Source File
inserted constructs, ALLBASE/SQL Message Catalog
module
definition, Creating Stored Sections
installable, Installable Module File
installation, Running the Program
name, Parameters, DBEnvironment Access, Source File, Stored Module Containing Sections
owner, Parameters, Stored Module Containing Sections
OWNER authority for, Authorizations
ownership, Granting Module Owner Authorizations
storage, Stored Module Containing Sections, Permanently Stored vs. Temporary Sections
updating, Updating Application Programs
validation, Runtime Revalidation of Sections
MODULE option
full preprocessing mode, Full Preprocessing Mode
multiple rows
not allowed in simple data manipulation, SELECT
multiple rows qualify
runtime error, SELECT
multiple users of LONG columns, Considering Multiple Users
multiple warnings
SQLEXPLAIN, sqlwarn[0]

N

naming conventions for LONG column files, File Naming Conventions
native language
current language, Native Language Support
defaults, Native Language Support
message catalog, Running the Program
native language data
verifying column definition, String Data Truncation
native language support
overview, Native Language Support
NATIVE-3000
defined, Native Language Support
non-dynamic commands, Using Dynamic Operations
NULL
as default data value, Using Default Data Values
null indicator suffix
data buffer, Setting up a Buffer for Query Results of Unknown Format
null indicator variable
in dynamic command, Setting up a Buffer for Query Results of Known Format
null indicator variables
and the INFO command, Declaring Variables for Compatibility
NULL result of a dynamic fetch of a LONG column, Using LONG Columns with a Dynamic FETCH Command
null value
in key column of unique index, SELECT
null values, Setting up a Buffer for Query Results of Known Format
and the INFO command, Declaring Variables for Compatibility
and unnamed columns in an INSERT, INSERT
in a structure declaration, Setting up a Buffer for Query Results of Known Format
indicator variables mandatory, FETCH
properties of, Indicator Variables
runtime errors, Indicator Variables
using indicator variables with, UPDATE
with FETCH, Indicator Variables, FETCH
with SELECT, Indicator Variables
number of rows processed
data integrity, Comparing Statement Level and Row Level Integrity
number of rows variable, Variables Used in BULK Processing

O

OLTP defined, Using DML to Manipulate Data
OPEN
before BULK FETCH, BULK FETCH
cursor processing, OPEN
OPEN command
use with KEEP CURSOR WITH NOLOCKS command, OPEN
optimization, Optimized Access Instructions
output device specification
definition, Defining Input and Output with the LONG Column I/O String
overflow
of numeric values, Numeric Data Conversion
OWNER authority
and program development, Authorizations
granting, Granting Module Owner Authorizations
OWNER option
full preprocessing mode, Full Preprocessing Mode

P

performance
integrity constraints, Programming with Constraints
LONG columns, Defining LONG Columns with a CREATE TABLE or ALTER TABLE Command
permanent section
and DBEnvironment, Differences between Dynamic and Non-Dynamic Preprocessing
PREPARE
non-dynamic queries, Using PREPARE and EXECUTE
preprocessor
authorization, Authorizations
DBE sessions, DBEnvironment Access
effect of mode on modified source, Modified Source File
effect on source code, ALLBASE/SQL Message Catalog
errors, Handling Preprocessor Errors
events, Preprocessing the Source File
identifying input, Identifying Preprocessor Input
include files, Sample Preprocessor Generated Include Files
invocation, Invoking the C Preprocessor
job mode, Using the Preprocessor in Job Mode
logging, Description
messages, ALLBASE/SQL Message File
modes, Invoking the C Preprocessor
modes and invocation, Syntax Checking Mode
options, Full Preprocessing Mode, Syntax Checking Mode
parsing, ALLBASE/SQL Message Catalog
UDC's, Using the Preprocessor UDCs
preprocessor banner
900 series, ALLBASE/SQL Message File
preprocessor directive
DECLARE CURSOR, DECLARE CURSOR
program
execution, Granting Program User Authorization, Running the Program
maintenance, Maintaining ALLBASE/SQL Applications
methods of linking, Compiling and Linking the Program, Running the Program
name, Source File
obsolescence, Changing Program-Related Authorization
steps in compiling, Compiling and Linking the Program, Running the Program
steps in creating, Developing ALLBASE/SQL Applications
user authorization, Granting Module Owner Authorizations
program example
date/time data conversion, Example Program cex9a
program structure
example, Skeleton Program

Q

query
dynamic data structures, Preprocessing of Dynamic Queries

R

REAL keyword
floating point data, FLOAT Data
RecDB database application design
example maintenance menu, Designing an Application Using Statement Level Integrity Checks
example of deleting data, Delete a Club in the Recreation Database, Delete an Event in the Recreation Database
example of error checking, Designing an Application Using Statement Level Integrity Checks
example of inserting data, Insert a Member in the Recreation Database
example of updating data, Update an Event in the Recreation Database
integrity constraints defined, Designing an Application Using Statement Level Integrity Checks
REFETCH command
used with LONG columns, Retrieving LONG Column Data with a [BULK] SELECT, FETCH, or REFETCH Command
restrictions
integrity constraints, Using Unique and Referential Integrity Constraints
LONG columns, Restrictions
retrieving LONG column data
with [BULK] SELECT, FETCH, or REFETCH commands, Retrieving LONG Column Data with a [BULK] SELECT, FETCH, or REFETCH Command
REVOKE, Changing Program-Related Authorization
REVOKE option
full preprocessing mode, Full Preprocessing Mode
robust program
defined, Handling Runtime Errors and Warnings
ROLLBACK WORK
to ensure data consistency, Transaction Management for Simple Operations
row level integrity
definition, Comparing Statement Level and Row Level Integrity
rows to retrieve
data buffer, Setting up a Buffer for Query Results of Unknown Format
RUN authority
and program development, Authorizations
runtime authorization, Granting Program User Authorization
runtime errors, Handling Runtime Errors and Warnings
bulk processing, Bulk Processing Variables
multiple rows qualify, SELECT
null values, Indicator Variables
runtime events, Running the Program
runtime status checking
possible errors, Runtime Status Checking and the sqlca
status codes, Runtime Status Checking and the sqlca
runtime warnings, Handling Runtime Errors and Warnings

S

sample database
authorities, Authorization
data consistency, Maintaining Data Consistency
views, Stored Module Containing Sections
sample program
bulk processing, Sample Program Using BULK Processing
cex10a, cex10a: Program for Dynamic Commands of Unknown Format
cex10b, cex10b: Program Using Dynamic Commands of Known Format
cex2, Looking at an Embedded SQL Source Program
cex5, Program Illustrating Implicit and Explicit Status Checking
cex7, Sample Program Using Simple DML Commands
cex8, Sample Program Using Cursor Operations
cex9, Sample Program Using BULK Processing
cursor processing, Sample Program Using Cursor Operations
dynamic queries, known format, cex10b: Program Using Dynamic Commands of Known Format
dynamic queries, unknown format, cex10a: Program for Dynamic Commands of Unknown Format
modified source file, Sample Modified Source File
simple data manipulation, Sample Program Using Simple DML Commands
status checking, Program Illustrating Implicit and Explicit Status Checking
section
and system catalog, Stored Module Containing Sections
creation, Optimized Access Instructions
definition, Creating Stored Sections, Stored Module Containing Sections
dynamic vs. non-dynamic, Differences between Dynamic and Non-Dynamic Preprocessing
permanently stored, Permanently Stored vs. Temporary Sections
purpose, Optimized Access Instructions
temorarily stored, Differences between Dynamic and Non-Dynamic Preprocessing
temporary, Using PREPARE and EXECUTE
types, Stored Module Containing Sections
validity, Optimized Access Instructions, Stored Module Containing Sections
SELECT
and simple data manipulation, SELECT
DECLARE CURSOR, DECLARE CURSOR
use of COMMIT WORK with, Stored Module Containing Sections
SELECT command
used with LONG columns, Retrieving LONG Column Data with a [BULK] SELECT, FETCH, or REFETCH Command
with TO_CHAR function, Example TO_CHAR Function
with TO_DATETIME function, Example Using the SELECT Command, Example TO_CHAR Function
with TO_INTERVAL function, Example Using the SELECT Command
SELECT with CURSOR
input host variables only, DECLARE CURSOR
shared memory problem
status checking, Handling Deadlock and Shared Memory Problems
simple data manipulation
commands, Simple Data Manipulation
DELETE, DELETE
INSERT, INSERT
multiple rows not allowed, SELECT
sample program, Sample Program Using Simple DML Commands
SELECT, SELECT
techniques, Simple Data Manipulation
transaction management, Transaction Management for Simple Operations
UPDATE, UPDATE
size maximum
LONG columns, General Concepts
skeleton program, Skeleton Program
SMALLINT data declaration, SMALLINT Data
source file, ALLBASE/SQL Message Catalog
source file;, Source File
space allocation for LONG column data, Deciding How Much Space to Allocate and Where
SQL
basic statements, Creating Source Files
SQL commands
comments within, Skeleton Program
delimiters for, Skeleton Program
location in the code, Skeleton Program
syntax, Skeleton Program
sqlca
elements of, Using the sqlca
purpose, Using the sqlca
sqlca.sqlcode
introduction, Using the sqlca
usage, sqlcode
sqlca.sqlerrd[2]
introduction, Using the sqlca
usage, sqlerrd[2]
sqlca.sqlwarn[0]
introduction, Using the sqlca
usage, sqlwarn[0]
sqlca.sqlwarn[1]
introduction, Using the sqlca
usage, sqlwarn[1]
sqlca.sqlwarn[2]
introduction, Using the sqlca
usage, sqlwarn[2]
sqlca.sqlwarn[3]
introduction, Using the sqlca
usage, sqlwarn[3]
sqlca.sqlwarn[6]
introduction, Using the sqlca
usage, sqlwarn[6]
sqlcode
a negative number, sqlcode
and sqlwarn[6], sqlcode
ANSI standards, Using the sqlca
deadlock detected, Handling Deadlock and Shared Memory Problems
detecting end of scan, Detecting End of Scan
multiple messages, sqlcode
multiple sqlcodes, sqlcode
of -10002, Determining When More Than One Row Qualifies
of -14024, sqlwarn[6], Handling Deadlock and Shared Memory Problems
of -4008, sqlwarn[6]
of 0, sqlcode
of 100, sqlcode, Detecting End of Scan
related to message catalog number, sqlcode
SQLEXPLAIN, sqlcode
usage, sqlcode
used with sqlerrd[2], BULK SELECT
sqlcode of 100, BULK FETCH
sqlda
declaring, Declaring Variables for Program Elements
fields, Setting Up the SQLDA
when fields are set, Dynamically Updating and Deleting Data, Setting Up the SQLDA
sqlerrd[2]
as counter in display routine, BULK SELECT
error checking, Comparing Statement Level and Row Level Integrity
usage, sqlerrd[2]
used with sqlcode, BULK SELECT
uses for, Determining Number of Rows Processed
SQLEXPLAIN
and message catalogs, Running the Program
introduction, Runtime Status Checking and the sqlca
multiple messages, Runtime Status Checking and the sqlca
multiple warnings, sqlwarn[0]
no message for sqlcode=100, sqlcode
simultaneous warning and error, sqlwarn[0]
sqlcode, sqlcode
sqlwarn[0], sqlwarn[0]
using, sqlcode
when messages are available, Approaches to Status Checking
sqlmsg, ALLBASE/SQL Message File
sqlwarn[0]
SQLEXPLAIN, sqlwarn[0]
usage, sqlwarn[0]
sqlwarn[1]
string truncation, String Data Truncation
usage, sqlwarn[1]
sqlwarn[2]
usage, sqlwarn[2]
sqlwarn[3]
usage, sqlwarn[3]
sqlwarn[6], sqlwarn[6]
transaction rollback, sqlwarn[6]
usage, sqlwarn[6]
start a DBE session
CONNECT, Authorizations
START DBE, Authorizations
START DBE
and DBA authority, Authorizations
to start a DBE session, Authorizations
StartIndex variable
defined, Variables Used in BULK Processing
statement level integrity
and integrity constraints, Using Unique and Referential Integrity Constraints
status checking
deadlock, Handling Deadlock and Shared Memory Problems
elements available, Using the sqlca
explicit, Explicit Status Checking Techniques
explicit defined, Runtime Status Checking and the sqlca
implicit, Implicit Status Checking Techniques
implicit defined, Runtime Status Checking and the sqlca
information available, Runtime Status Checking and the sqlca
introduction to explicit, Approaches to Status Checking
kinds of, Approaches to Status Checking
procedures, Program Illustrating Implicit and Explicit Status Checking, Explicit Status Checking Techniques
purposes of, Purposes of Status Checking
runtime techniques, Handling Runtime Errors and Warnings
shared memory problem, Handling Deadlock and Shared Memory Problems
status codes
runtime status checking, Runtime Status Checking and the sqlca
storage
LONG columns, Defining LONG Columns with a CREATE TABLE or ALTER TABLE Command
syntax checking mode, Syntax Checking Mode
syntax for date/time functions
ADD_MONTHS, Using the Date/Time ADD_MONTHS Function
input functions, Using Date/Time Input Functions
output functions, Using Date/Time Output Functions
TO_CHAR, Using Date/Time Output Functions
TO_DATE, Using Date/Time Input Functions
TO_DATETIME, Using Date/Time Input Functions
TO_INTEGER, Using Date/Time Output Functions
TO_INTERVAL, Using Date/Time Input Functions
TO_TIME, Using Date/Time Input Functions
syntax for LONG columns
ALTER TABLE command, Defining LONG Columns with a CREATE TABLE or ALTER TABLE Command
CREATE TABLE command, Defining LONG Columns with a CREATE TABLE or ALTER TABLE Command
select list, Retrieving LONG Column Data with a [BULK] SELECT, FETCH, or REFETCH Command
syntax within embedded SQL, Skeleton Program
system catalog, Optimized Access Instructions

T

temporary section, Using PREPARE and EXECUTE
terminal IO
KEEP CURSOR, Writing Keep Cursor Applications
TO_CHAR function
example with SELECT command, Example TO_CHAR Function
syntax, Using Date/Time Output Functions
TO_DATE function
example with INSERT command, Example Using the INSERT Command
example with UPDATE command, Example Using the UPDATE Command
syntax, Using Date/Time Input Functions
TO_DATETIME function
example with DELETE command, Example Using the DELETE Command
example with INSERT command, Example Using the INSERT Command
example with SELECT command, Example Using the SELECT Command, Example TO_CHAR Function
example with UPDATE command, Example Using the UPDATE Command
syntax, Using Date/Time Input Functions
TO_INTEGER function
example with BULK FETCH command, Example TO_INTEGER Function
syntax, Using Date/Time Output Functions
TO_INTERVAL function
example with INSERT command, Example Using the INSERT Command
example with SELECT command, Example Using the SELECT Command
syntax, Using Date/Time Input Functions
TO_TIME function
example with INSERT command, Example Using the INSERT Command
syntax, Using Date/Time Input Functions
transaction management, sqlwarn[6]
cursor processing, Transaction Management for Cursor Operations
simple data manipulation, Transaction Management for Simple Operations
truncation
detecting in strings, Indicator Variables
in string operations, String Data Truncation
of numeric values, Numeric Data Conversion
of UPDATE or DELETE strings, String Data Truncation
type compatibility, Declaring Variables for Compatibility
and the INFO command, Declaring Variables for Compatibility
decimal, Numeric Data Conversion
type conversion, Declaring Variables for Compatibility
type include file
sample, Sample Preprocessor Generated Include Files
type precedence
in numeric conversion, Numeric Data Conversion

U

UDC's
PC, Using the Preprocessor UDCs
PPC, Using the Preprocessor UDCs
preprocess, Using the Preprocessor UDCs
preprocess, compile, link, Using the Preprocessor UDCs
unique index
WHERE clause, SELECT
UPDATE
and simple data manipulation, UPDATE
UPDATE and FETCH
cursor processing, UPDATE WHERE CURRENT
UPDATE command
used with LONG columns , Changing a LONG Column with an UPDATE [WHERE CURRENT] Command
used with TO_DATE function, Example Using the UPDATE Command
used with TO_DATETIME function, Example Using the UPDATE Command
UPDATE STATISTICS
invalidating sections, Stored Module Containing Sections
UPDATE WHERE CURRENT
FOR UPDATE OF, DECLARE CURSOR, UPDATE WHERE CURRENT
restrictions, UPDATE WHERE CURRENT
syntax, UPDATE WHERE CURRENT
UPDATE WHERE CURRENT command
used with LONG columns, Changing a LONG Column with an UPDATE [WHERE CURRENT] Command
updating application programs, Managing Source Code
USER
as default data value, Using Default Data Values
using default data values
introduction to, Using Default Data Values
using indicator variables
assigning null values, UPDATE

W

warning message
and sqlcode, sqlwarn[0]
and sqlwarn[0], sqlwarn[0]
warnings
runtime handling, Handling Runtime Errors and Warnings
WHENEVER
components of, Implicit Status Checking Techniques
duration of command, sqlcode
for different conditions, Implicit Status Checking Techniques
transaction roll back, Implicit Status Checking Techniques


Transaction Management with TID Access
  		 
Feedback to webmaster