Index

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

$ (dollar sign)

currency displays

object names

% (percent sign) pattern matching

( ) (parentheses), precedence of arithmetic operations

* (asterisk)

count (function)

exponentiation

multiplication

. (period), decimal indicator

- - (double hyphen), comment delimiter

-numeric_overflow flag

-string_truncation flag

/ (slash)

comment indicator (with asterisk)

division

? (question mark) parameter indicator

Execute

Prepare

@ (at sign), object names

[ ] (square brackets) pattern matching

\\ (backslash) pattern matching

_ (underscore) pattern matching

_ (underscore)

object names

_date (function)

_date4 (function)

_time (function)

+ (plus sign), addition

= (equals sign)

comparison operator

a (terminal monitor command)

abort (statement)

aborting

distributed transactions

transactions

Connecting with Distributed Transactions

Effects of Aborted Transactions

Execute

with savepoint

abs (function)

absolute function

add disk pages

aggregate functions

data selection

described

expressions

aggregates, nulls

allocation option

alter (statement)

group

profile

sequence

user

and (logical operator)

ANSI date/time data types

ANSI/ISO standard

case handling of identifiers

connection flags

default mode for cursors

delimited identifiers

ESQL preprocessor flags

handling non-compliant SQL statements

query flattening

settings for compliance

settings for Configuration-By-Forms

any-or-all (predicate)

append (terminal monitor command)

arctangent function

arithmetic

dates

expressions

operations

operators

as (clause)

assignment operations

character string

date

described

logical keys

null

numeric

atan (function)

automatically recreate index

avg (function)

begin transaction (statement)

bell (terminal monitor command)

blanks

c data type

char data type

padding

trailing

Like Predicate

String Functions

btree (storage structure)

Modify

Result_Structure

buffer cache priority

byte (data type)

data type return code

byte (function)

byte varying (data type)

c (function)

c data type (Ingres)

C2 security

Remove Table

Security Log Files

C2security

case

character strings

Case Sensitivity of Identifiers

Regular and Delimited Identifiers

expressions

lowercase (function)

names

uppercase (function)

cast expressions

cbtree (storage structure)

cd (terminal monitor command)

changing

locations

profile

char (data type)

data type return code

char (function)

character data

assignment

comparing

SQL

Character Data Types

Character String Assignment

String Functions

charextract (function)

chash (storage structure)

chdir (terminal monitor command)

cheap (storage structure)

cheapsort (storage structure)

check uniqueness

check_eos flag

checkpoints, files

Alter Location

Create Location

cisam (storage structure)

clauses, escape

column constraint

columns (in tables)

aggregate functions

expressions

comments

SQL

tables

variable declaration section

comparison (predicate)

comparison operator

<> (angle brackets)

> < (greater/less than symbol)

comparison operators, predicates

comparisons, nulls

compression

indexes

computation, logarithms

concat (function)

constants

hex

list of SQL

now

null

today

constraints

adding/removing

column-level

column_constraint

described

integrity

permit

table-level

table_constraint

unique

conversion, character data

copy (statement)

constraints

logical keys

copying

error detection

correlation names

queries

subqueries

cos (function)

cosine function

count (aggregate function)

create (statement)

dbevent

permit

creating

database events

roles

Ctrl+C (key)

Aborting the Editor (VMS only)

Interrupt Handling

current value for operator

current_user constant

currval operator

cursor

capabilities

database

declare cursor (statement)

deleting rows

dynamic SQL

fetch (statement)

open cursor (statement)

positioning

prefetching and readonly cursors

select loops vs

Cursor Select

Cursors versus Select Loops

updating rows

data handlers

described

execute (statement)

execute immediate (statement)

fetch (statement)

insert (statement)

select (statement)

update (statement)

data types

byte

byte varying

c (Ingres)

char

Char Data Types

Character String Assignment

character

compatibility

conversion functions (list)

date

Date Data Type

Date Literals

decimal

Arithmetic Operations on Decimal Data Types

Decimal Data Types

Ifnull and Decimal Data

Numeric Functions

ESQL return codes (list)

floating point

host languages

ingresdate

integer

interval

Interval Data Types

Interval Literals

list of SQL

logical key

long byte

long varchar

Data Handlers for Large Objects

Execute

Execute Immediate

Fetch

Indicator Variables and Character Data Retrieval

Insert

Long Varchar Data Types

Retrieving Long Varchar and Long Byte Values

String Functions

Update

money

text

Character String Assignment

Text Data Types

time

Date/Time Input Formats

Time Data Types

Time Literals

timestamp

Timestamp Data Types

Timestamp Literals

Unicode

user-defined

Default Clause

Storage Format

varchar

Character String Assignment

Varchar Data Types

database events

described

obtaining status information

[No]Printdbevents Option

Inquiring About Database Events

Set_sql

Whenever

remove event (statement)

security logging

user-defined handlers

Other Types of Handlers

Process Database Events

Receive a Database Event

Set_sql

User-Defined Database Event Handlers

database objects

naming

database procedures

messages

Other Types of Handlers

Types of Inquiries

Whenever

parameters passed in

row producing

rules

Create Procedure

Raise Error Statement

security logging

databases

aborting transactions

connecting to programs

transactions

Begin Transaction Statement

End Transaction Statement

Transactions

updating

Begin Transaction Statement

End Transaction Statement

DataDefinitionLanguage(DDL)

DataManipulationLanguage(DML)

date (data type)

date (function)

Data Type Conversion Functions

Date Functions for Ingresdate Data Type

date_gmt (function)

dates

(terminal monitor command)

selecting current/system

DBMS

aborting transactions and statements

commit (statement)

control statements

error handling

rollback (statement)

savepoints

status information

transactions

two phase commit (described)

dbmsinfo (function)

described

list of request names

dclgen declaration generator (utility)

Dclgen Utility

Include

deadlock, handling

decimal (data type)

Arithmetic Operations on Decimal Data Types

data type return code

Decimal Data Types

Ifnull and Decimal Data

Numeric Functions

decimal (function)

declarations

declare cursor (statement)

declare global temporary table (statement)

defaults

storage structures

Fillfactor, Minpages, and Maxpages

Result_Structure

deferred mode, cursor updates

deleting

rows

table space recovery

delimited identifiers

delimiters, create schema (statement)

derived tables

Derived Table Syntax

Subqueries in the From Clause (Derived Tables)

describe (statement)

Describe Statement

Prepare and Describe Select Statements

describe input (statement)

destroying

permits

direct mode, cursor updates

Cursor Modes

Direct Mode for Update

display internal table data structure

distributed databases

transactions

distributed transactions, aborting

DMY format (dates)

dow (function)

drop (statement)

dbevent

permit

rule

dump files

Alter Location

Create Location

dynamic SQL long varchar (data type)

edit (terminal monitor command)

effective user

Embedded SQL

include (statement)

overview

preprocessor errors

sample program

SQLCA

variables

end transaction (statement)

endquery (statement)

error handling

aborting distributed transactions

copy (statement)

data handlers

database connections

database procedure

deadlock

errorno flag

errortext (constant)

generic errors

iierrornumber

iirowcount

numeric overflow/underflow

SQLCA

Error Information from SQLCA

Whenever

SQLCODE

SQLSTATE

Fetch Data From Cursor

SQLSTATE and Equivalent Generic Errors

SQLSTATE Variable

Whenever Dbevent Statement

string truncation

user-defined handlers

Define Error Handling Functions

Set_sql

whenever (statement)

errors, numeric

escape (clause), like (predicate)

exchange nodes

exec 4gl (statement)

exec sql (keyword)

execute (statement)

Prepare and Execute Statements

Preparing and Executing a Non-select Statement

execute immediate (statement)

described

execute database procedures

executing non-select statements

executing select statements

exists (predicate)

exp (function)

expiration date (tables)

exponential function

exponential notation

expressions

definition of

sequence

flags, connection

numeric_overflow

string_truncation

flags, ESQL preprocessor

blank_pad

check_eos

sqlcode

wsql

float (data type)

data type return code

float4 (function)

float8 (function)

floating point

conversion

data types

range

forms,applications

functions

abs

aggregate

Binary Aggregate Functions

Unary Aggregate Functions

atan

avg

binary

bit-wise

cos

date

exp

Hash

log

max

min

mod

numeric (list)

random number

scalar

sin

sqrt

string

substring

sum

unary

UUID

g (terminal monitor command)

generic errors

described

list

raise error (statement)

German format (dates)

get dbevent (statement)

Get Dbevent Statement

Receive a Database Event

go (terminal monitor command)

Terminal Monitor Commands

Terminal Monitor Query Buffering

grant (statement)

Grant (privilege)

Grant (role)

grant option

group by (clause)

Group By Clause with Aggregate Functions

Select (interactive)

group identifiers

assigning

Alter Profile

Create Profile

hash (storage structure)

Modify

Result_Structure

Hash

functions

having (clause)

Search Conditions in SQL Statements

Select (interactive)

heap (storage structure)

Modify

Result_Structure

heapsort (storage structure)

Modify

Result_Structure

hex (function)

host language

hostlanguage

i (terminal monitor command)

ifnull (function)

II_DATE_FORMAT

in (predicate)

include (statement)

described

SQLDA

include (terminal monitor command)

indexes

building parallel

compression

unique

indicator variables

character data retrieval

ESQL

ingresdate (data type)

arithmetic operations

assignment

data type return code

date_part (function)

date_trunc (function)

display formats

formats (list)

functions

input formats

interval (function)

intervals

now constant

initial_user constant

inquire_ingres (statement)

inquire_sql (statement)

database events

described

error checking

Error Information from Inquire Statements

Raise Error Statement

integer (data type)

data type return code

integer

data types

literals

range

integrity

constraints and nulls

constraints and rules

interrupts

interval (data type)

interval (function)

isam (storage structure)

Modify

Result_Structure

ISO format (dates)

ISO standard

keywords

ISQL

overview

journaling

enabling/disabling

[No]Journaling

With_Clause for Create Table

journals, files

Alter Location

Create Location

keyboard Ctrl key

Aborting the Editor (VMS only)

Interrupt Handling

keywords

ISO

single

KnowledgeManagementExtension

described

limits

ANSI identifiers

connection name length

cursor name length

data handlers

database event text length

database name length

float data type

integer data

length of connection name

length of long varchar columns

logical operators in queries

long varchar length

nested rules

number of columns in rules

number of columns in tables

number of columns in unique constraint

number of flags in connect statement

number of results columns

number of tables in a query

number of tables in queries

object name length

object names

prepared statement name length

row length

row width

literals

date

floating point

integer

interval

numeric

string

time

timestamp

local errors

Error Handling

Raise Error

locate (function)

locations

changing

security logging

locking

level

set lockmode (statement)

timeout

when granting privileges

log (function)

logarithmic function

logging

database events

file

logical key (data type)

assignment

inquiring about

restrictions

Default Clause

Insert

Restrictions and Considerations

logical operators, SQL

logically inconsistent table

long byte (data type)

data type return code

long varchar (data type)

data type return code

datahandler clause

Execute

Execute Immediate

Fetch

Insert

Retrieving Long Varchar and Long Byte Values

Update

datahandler routines

long_varchar (function)

restriction for predicates

restriction on keys

restrictions for string functions

string truncation

long_byte (function)

loops

host language

message (statement)

database procedures

inquire_sql(messagenumber)

whenever sqlmessage (statement)

messagenumber (constant)

messages, user-defined handlers

Other Types of Handlers

Set_sql

messagetext (constant)

data type return code

money (function)

move data

multi-statement transactions (MST)

Abort Statement

Begin Transaction Statement

Constraints

End Transaction Statement

How Commit and Rollback Process Works

Lockmode

Transactions

multinational format (dates)

multiple sessions

described

inquire_sql

sample program

naming

case

correlation names

database objects

nchar (function)

nesting

queries

rules

next value for operator

nextval operator

nobell (terminal monitor command)

not (logical operator)

not null column format

notrim (function)

now date constant

II_DATE_FORMAT for Ingresdate

SQL Constants

null constant

null indicators

Fetch

Indicator Variables

null values

SQL

nullability

ifnull (function)

is null (predicate)

table columns

nulls

aggregate functions

Nulls and Aggregate Functions

Unary Aggregate Functions

assignment

integrity constraints

null constant

SQL

numeric (data type)

assignment

errors

functions (list)

range and precision

truncation

numeric_overflow flag

nvarchar (function)

object names

restrictions and limits

object_key (function)

ObjectManagementExtension(OME)

online modification

Concurrent_updates

Modify

open cursor (statement)

operations

arithmetic

assignment

operators

arithmetic

current value for

currval

logical

next value for

nextval

or (logical operator)

Logical Operators

Search Conditions in SQL Statements

overflow, numeric

p (terminal monitor command)

pad (function)

parallel index

building

parallel query

partial transaction aborts

partitioning table

Modify

NopartitionPartition=

patterns, matching

permissions

database procedures

Drop Permit Statement

Permissions on Database Procedures

rules

permits

constraints

create permit (statement)

destroying

physically inconsistent table

precision

decimal (data type)

Arithmetic Operations on Decimal Data Types

Decimal Data Types

Ifnull and Decimal Data

floating point

predicates

any-or-all

comparison

exists

is null

prefetching

inquire_sql (statement)

readonly cursors

set_sql (statement)

prepare (statement)

Prepare and Execute Statements

Preparing and Executing a Non-select Statement

printing, print (terminal monitor command)

privileges

database events

database

database event

database procedure

database sequences

examples of

grant all option

granting

granting to another ID

subject privileges

Alter Profile

Create Profile

Create Role

Create User

programquit (constant)

How to Specify Program Termination When Errors Occur

Set_sql

Types of Inquiries

programs

suspending execution

How to Specify Program Termination When Errors Occur

Whenever

QUEL

keywords

queries

nested

optimizing

repeat

Drop Synonym

Embedded Usage

Prepare

Repeated Queries

subqueries

query optimizer

r (terminal monitor command)

raise dbevent (statement)

raise error (statement)

Raise Error Statement

Rules

random number

random number functions, list

random number

functions

read (terminal monitor command)

readonly table

reconstruct (storage structure)

recovery, journaling

relocate (statement)

relocate table

remove dbevent (statement)

Remove a Database Event Registration

Remove Dbevent

repeat queries

effect of drop synonym statement

insert (statement)

restriction for select statement

restrictions in dynamic statements

select (statement)

update (statement)

reserved words

single

reset (terminal monitor command)

resource

security logging

restrictions

aggregate functions in expressions

C2 security log

characters in delimited identifiers

check constraints

column default values

connection name length

copy (statement)

Locking

Restrictions and Considerations

copying logical keys

cursor deletes

cursor name length

cursor updates

data handlers

database events on VMS clusters

database procedure parameters

database procedures

delimiters in create schema (statement)

dynamic SQL statement name length

enable security_audit statement in transactions

Alter Security_Audit

Enable Security_Audit

execute immediate (statement)

get dbevent statement in database procedures

identifiers for database objects

into clause in ISQL

lockmode

logical key (data type)

Default Clause

Insert

Restrictions and Considerations

Restrictions on Logical Keys

Using Create Table...As Select

logical keys and nulls

logical operators in queries

long byte columns

long varchar and predicates

long varchar columns

Create Index

Restrictions on Long Varchar Columns

long varchar length

maximum length of a default value

nested rules

number of columns in an index

number of columns in rules

number of results columns

number of tables in a query

number of tables in queries

object names

prepared statement name length

referential constraints

repeat queries

Execute a Dynamic Select Statement

Repeated Queries

repeated queries in database procedures

revoking database privileges

row width

set autocommit (statement) in transactions

set logging (statement)

set session with on_error (statement) in transactions

statements in dynamic SQL

string functions and long varchar

switching sessions

temporary tables

two phase commit on VMS cluster

unions

unique indexes in queries

updating views

right (function)

role identifiers

creating

role

access to

rollback (statement)

rollforward table level

rounding, money (data type)

rows (in tables)

counting

deleting

retrieving

rowcount

security logging

updating

rules

database procedures

described

RULE_DEPTH

s (terminal monitor command)

scalar functions

scale, decimal (data type)

script (terminal monitor command)

search conditions, SQL

security

C2compliance

select (statement)

database procedures

datahandler clause

dynamic SQL

query evaluation

select loop

Cursors versus Select Loops

Endselect

Select Loops

Select(statement)

embedded

semicolon statement terminator

sequence defaults

sequence expressions

session role

session_user constant

set autocommit (statement)

set role option

changing

set_ingres (statement)

sh (terminal monitor command)

shell (terminal monitor command)

SQL

advanced techniques

data types

descriptor area (SQLDA)

dynamic

keywords

names

overview

run-time information

SQLVAR

statements/commands from earlier releases

SQLCA (SQL Communications Area)

database events

deleted rows

described

error handling

Error Handling

Raise Error

Retrieving Values into Host Language Variables

Types of Inquiries

include (statement)

multiple sessions

row determination

Cursor Updates

Embedded Usage

Endselect

Fetch

whenever (statement)

sqlcode (variable)

sqlcode flag

SQLDA (SQL Descriptor Area)

describe (statement)

described

execute (statement)

execute immediate (statement)

execute procedure (statement)

fetch (statement)

include (statement)

SQLSTATE error handling

sqrt (function)

square root function

squeeze (function)

statement terminators

status information

dbmsinfo (function)

inquire_sql (statement)

string_truncation flag

strings

functions (list)

c (function)

char (function)

concat (function)

functions

left (function)

length (function)

literals

locate (function)

lowercase (function)

notrim (function)

padding

right (function)

shift (function)

size (function)

soundex (function)

SQL

squeeze (function)

substring (function)

text (function)

trim (function)

truncation

uppercase (function)

varchar (function)

varying length

structure, variables

subject privileges

Alter Profile

Create Profile

Create Role

Create User

subqueries

Subqueries in the From Clause (Derived Tables)

Subqueries in the Where Clause

substring (function)

sum (function)

Sweden/Finland format (dates)

system_user constant

t (terminal monitor command)

table constraint

table partitioning

Modify

NopartitionPartition=

table_key (function)

tables

expiration

relocating

security logging

Terminal Monitor

described

text (data type)

text (function)

time (data type)

time

display format

functions

ime (terminal monitor command)

interval (function)

intervals

selecting current/system

timeout

timestamp (data type)

today date constant

II_DATE_FORMAT for Ingresdate

SQL Constants

transactions

aborting

Abort Statement

Session with On_error

begin transaction (statement)

commit (statement)

control statements

distributed

end transaction (statement)

management

multi-statement (MST)

Abort Statement

Begin Transaction Statement

End Transaction Statement

rolling back

savepoints

transaction (constant)

trim (function)

truncate table

truncation

character data

data conversion

dates

numeric assignment

string

truth functions

two phase commit

description

UDTs (user-defined data types)

Default Clause

Storage Format

unary functions

unary operators

unhex (function)

Unicode

data types

unique

clause

indexes

Universal Unique Identifier (UUID)

update (statement)

datahandler clause

uppercase (function)

US format (dates)

user

constant

effective user

security logging

UUID (function)

varbyte (function)

varchar (data type)

data type return code

varchar (function)

variable declarations

host languages

variables

host language

null indicator

structure

views

ownership

security logging

w (terminal monitor command)

warnings

role passwords

set nologging and performance

set norules and constraints

[No]Rules Option

Rules

whenever (statement)

database events

described

example

where (clause)

Search Conditions in SQL Statements

Select (interactive)

wild card characters

help (statement)

select (statement)

with (clause)

with null column format

with_clause options

allocation

work files

Alter Location

Create Location

write (terminal monitor command)

wsql flag

YMD format (dates)