Nonstop Database, HiRDB Version 9 SQL Reference

[Contents][Index][Back][Next]

Index

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

(Symbols)
? parameter
assigning value to
*
(A)
abbreviations for products
abstract data
abstract data type
abstract data type
abstract data type
notes on using
access privilege
granting
revoking
ADD OPTIMIZE LEVEL
ADD OPTIMIZE LEVEL
ADD OPTIMIZE LEVEL
ADD OPTIMIZE LEVEL
ADD OPTIMIZE LEVEL
AFTER trigger
alias
list, old or new values
old or new values
ALL
ALL
ALL
ALL set function
ALLOCATE CONNECTION HANDLE
ALLOCATE CURSOR statement Format 1
ALLOCATE CURSOR statement Format 2
ALTER PROCEDURE
ALTER ROUTINE
ALTER TABLE
ALTER TRIGGER
ANY
arithmetic operation
ASC
ASC
ASC
ASC
ASC
ASSIGN LIST statement
ASSIGN LIST statement
assignment rules
for fixed-length target data
for variable-length target data
assignment statement
assignment statement
assignment types
retrieval assignment
storage assignment
attribute
definition
name
AUTHORIZATION
AUTHORIZATION
AVG
AVG
(B)
BEFORE trigger
BEGIN
BEGIN DECLARE SECTION
BINARY
binary data
binary data
BINARY LARGE OBJECT
BINARY type, notes on using
BLOB
BLOB
BOOLEAN
boundary value
list
list
list, first dimension
list, second dimension
by-row (ROW specification) interface
by-row (ROW specification) interface
(C)
CALL statement
CASE abbreviation
CASE expression
CASE expression
searched
simple
CAST specification
CHAR[ACTER]
character code
character data
character data
character data
character data
mixed
mixed
mixed
mixed
national
national
national
national
character length, maximum
character length, maximum
character length, maximum
character length, maximum
character length, maximum
character length, maximum
character string output to file
check constraint
multicolumn
single column
CLOSE statement
CLUSTER KEY
cluster key
cluster key
CLUSTER KEY UNIQUE
COALESCE
column attribute, updatable
column data suppression specification
column definition
column name
first dimension
second dimension
column recovery restriction
column recovery restriction
column recovery restriction 2
column restriction
column specification
column specification
COMMAND EXECUTE
COMMENT
comment
comment
COMMIT statement
comparison operators
comparison predicate
comparison predicate
component specification
compound statement
concatenation operation
condition details name
conditional branching, executing by
CONNECT privilege
granting
revoking
CONNECT statement
connected user, changing
connection handle
connection handle
connection handle
connection handle
allocating
getting
releasing
to be used, declaring
to be used, resetting all
connection PDHOST variable
connection PDNAMEPORT variable
connection security facility
defining
deleting
constraint name definition
control SQL
conventions
abbreviations for products
fonts and symbols
KB, MB, GB and TB
version numbers
COPY
correlation name
correlation name
new values
old values
scope for
scope for
COUNT
COUNT(*)
CREATE AUDIT
CREATE CONNECTION SECURITY
CREATE INDEX
CREATE INDEX
CREATE PUBLIC VIEW
CREATE SCHEMA
CREATE TABLE
CREATE TRIGGER
CREATE TYPE
CREATE VIEW
CURRENT DATE
CURRENT TIME
CURRENT_DATE
CURRENT_DATE value function
CURRENT_TIME
CURRENT_TIME value function
CURRENT_TIMESTAMP value function
cursor
cursor
cursor
cursor
closing
declaring
declaring
name
name, extended
opening
opening
retrieval information, receiving
specification
(D)
data
fetching
fetching
fetching
retrieving dynamically
updating
updating
data guarantee level
data guarantee level
data guarantee level
data guarantee level
data guarantee level
data manipulation SQL
data type
predefined
that can be assigned
that can be compared
that can be converted
user-defined
DATE
date data
date data
date data
predefined character string representation of
date interval data
date interval data
date interval data
decimal representation of
date operation
datetime format
elements of
specifying
datetime interval data, decimal representation of
DAY[S]
DBA privilege
granting
revoking
DEALLOCATE PREPARE statement
DEC[IMAL]
decimal type, notes on using
DECLARE CONNECTION HANDLE SET
DECLARE CONNECTION HANDLE UNSET
DECLARE CURSOR
DECLARE CURSOR
DEFAULT clause
DEFAULT clause
DEFAULT clause
default constructor option
default value (WITH DEFAULT)
definition SQL
definition SQL
DELETE statement
DELETE statement
DELETE statement
delimiter
inserting
insertion location of
location where delimiter is allowed
location where delimiter is not allowed
derived query expression
in WITH clause
derived table
in FROM clause, rules on
DESC
DESC
DESC
DESC
DESC
DESCRIBE CURSOR statement
DESCRIBE statement
DESCRIBE statement
DESCRIBE TYPE statement
diagnostic information, retrieving
DISCONNECT statement
DISTINCT
DISTINCT set function
DOUBLE PRECISION
double-byte character
DROP AUDIT
DROP CONNECTION SECURITY
DROP DATA TYPE
DROP DEFAULT
DROP INDEX
DROP LIST statement
DROP PUBLIC VIEW
DROP SCHEMA
DROP TABLE
DROP TRIGGER
duplicates exclusion
(E)
embedded exception, declaring
embedded language
embedded SQL
declare section
declare section
declaring beginning of
declaring end of
embedded variable
embedded variable
array
array
array
array
assigning value to
qualifying
relationship between embedded variable and SQL data type
embedded variable, function of
altering embedded variable
altering literal value
receipt of column value as retrieval result
specifying authorization identifier and password
specifying SQL character string
specifying value for ? parameter
EMPTY
EMPTY
encapsulation level
END DECLARE SECTION
environment variable group name variable
error
resignaling
signaling
ESCAPE
ESCAPE
ESCAPE
escape character
escape character
escape character
EXCEPT
EXCEPT VALUES
exception value specification
exclusive mode
exclusive mode
EXECUTE IMMEDIATE statement
EXECUTE statement
EXECUTE statement
extended cursor name
external routine specification
(F)
FETCH statement
FETCH statement
FETCH statement
FIX
FIX hash partitioning
FLAT specification
flexible hash partitioning
FLOAT
font conventions
FOR statement
FOREIGN KEY
free area, percentage of
free area, percentage of
FREE CONNECTION HANDLE
FREE LOCATOR statement
free pages in segment, percentage of
FROM clause, rules on derived tables in
function
function
function
body
body
system-defined
to be called, rules for determining
user-defined
function call
function return value, returning
(G)
GB, meaning of
GET CONNECTION HANDLE
GET DIAGNOSTICS
GET_JAVA_STORED_ROUTINE_SOURCE specification
GRANT
GRANT
GRANT access privilege
GRANT CONNECT
GRANT DBA
GRANT RDAREA
GRANT SCHEMA
GROUP BY clause
GROUP BY clause
rules for
grouping column
grouping column
grouping condition
grouping operation
grouping operation
(H)
hash function
hash function
hash function
HASH0
HASH1
HASH2
HASH3
HASH4
HASH5
HASH6
HASHA
HASHB
HASHC
HASHD
HASHE
HASHF
HAVING clause
rules for
HAVING search condition
HAVING search condition
HiRDB Control Manager - Agent
holdable cursor
holdable cursor
holdable cursor
HOUR[S]
(I)
I/O information, receiving
I/O information, receiving
identifier
data type
host
index
index type
routine
SQL statement
SQL statement
SQL statement
SQL statement
SQL statement
SQL statement
table
table
trigger
IF Statement
index
defining
defining
deleting
name
option
option
option
index type name
INDEX USING
indicator variable
indicator variable
array
array
qualifying
indicator variable, function of
altering literal value
receipt of column value as retrieval result
specifying value for ? parameter
inner derived table
INNER JOIN
inner join
inner replica facility, restrictions on use of
inner table
INSERT ONLY
INSERT statement
INSERT statement
INSERT statement
insertion value
insertion value
row
INSTALL JAR
INT[EGER]
interface, row-by-row basis (ROW specification)
INTERVAL HOUR TO SECOND
INTERVAL YEAR TO DAY
INTO
INTO
INTO
INTO
INTO
INTO
INTO
INTO
INTO
INTO
ISOLATION
ISOLATION
ISOLATION
ISOLATION
ISOLATION
item specification
(J)
JAR file
re-registering
registering
removing
join
condition
rules for
joined column
joined table
rules on
(K)
KB, meaning of
keyword specification
(L)
labeled duration
labeled duration
large object data
large object data
large object data
notes on using
LEAVE statement
LEFT [OUTER] JOIN
library text, including
LIMIT clause
limit row count
list
creating
creating
deleting
literals
character string
character string
decimal
floating-point numeric
hexadecimal character string literal
integer
mixed character string
mixed character string
national character string
national character string
numeric
LOB column storage RDAREA
locator
invalidating
lock control
on table
lock option
lock option
lock option
lock option
lock option
lock option
lock option
LOCK PAGE
LOCK PAGE
lock resource, minimum unit of
lock resource, minimum unit of
LOCK ROW
LOCK ROW
LOCK statement
logical data
notes on using
logical operation
(M)
matrix partitioned LOB attribute storage RDAREA
matrix-partitioned tables
MAX
MAX
MB, meaning of
MCHAR
MIN
MIN
MINUTE[S]
MONTH[S]
multi-connection facility
multi-connection function
multiple statements, executing
MVARCHAR
(N)
name
qualifying
specifying
NATIONAL CHAR[ACTER]
NATIONAL CHAR[ACTER] VARYING
NCHAR
NCHAR VARYING
NO SPLIT
NO SPLIT
NO SPLIT
NO SPLIT
NO WAIT
NO WAIT
non-partitioning key indexes
NOT FOUND
NOT NULL
NOT NULL
NOT NULL constraint
specification
NULL
null value
default-setting function
NULLIF
NUMERIC
numeric data
numeric data
numeric data
numeric literals
decimal
floating-point numeric
integer
restriction on use of
numeric value
other than numeric literals
specifying
NVARCHAR
(O)
offset of first row to return
ON search condition
OPEN statement
OPEN statement
operand, order of specifying
OPTIMIZE LEVEL
OPTIMIZE LEVEL
OPTIMIZE LEVEL
OPTIMIZE LEVEL
OPTIMIZE LEVEL
ORDER BY clause
outer join
outer reference
outer table
overflow
in search condition, example of
in update value, example of
overflow error suppression feature
(P)
partitioning key index
password, changing auditor's
pattern character string
pattern character string
pattern character string
PCTFREE
PCTFREE
PCTFREE
PDCNCTHDL type variable
PDCNCTHDL type variable
PDCNCTHDL type variable
declaration
plug-in
option
option
option
specification
specification
POSITION
predicate
BETWEEN
Boolean
comparison
EXISTS
IN
LIKE
NULL
quantified
results of
structured repetition
XLIKE
PREPARE statement
PRIMARY
PRIMARY
primary
primary key
primary key
PRIVATE
privilege
granting
revoking
procedures
body
calling
defined in CREATE PROCEDURE procedure
defined in CREATE TYPE procedure
PROTECTED
PUBLIC
PUBLIC
PUBLIC
PUBLIC
public view
defining
deleting
PURGE TABLE statement
(Q)
query expression
query expression body
query expression body
rule for
query name
scope for
scope for
query retrieval item information
query specification
(R)
RDAREA list, matrix partitioning
RDAREA list, matrix partitioning
RDAREA list, matrix partitioning
RDAREA list, matrix partitioning
RDAREA list, matrix partitioning
RDAREA name
index storage
index storage
index storage
index storage
LOB attribute storage
LOB attribute storage
LOB attribute storage
LOB column storage
table storage
table storage
RDAREA specification
abstract data type definition LOB storage
abstract data type LOB column storage
abstract date type definition LOB column storage
index storage
LOB column storage
LOB column storage
matrix partitioned index storage
matrix partitioned index storage
matrix partitioned index storage
matrix partitioned index storage
matrix partitioned LOB attribute storage
matrix partitioned LOB column storage
matrix partitioned LOB column storage
matrix partitioned table storage
two dimensional storage
two dimensional storage
two dimensional storage
two dimensional storage
two dimensional storage
RDAREA usage privilege
granting
revoking
READ ONLY
READ ONLY
READ ONLY
REAL
RECOVERY
reference specification
referential constraint
multicolumn
single column
regular expression specification, meaning of
RELEASE
RELEASE
REMOVE JAR
REPLACE JAR
RESIGNAL statement
result set cursor, allocating
results-set return facility
retrieval information, receiving
retrieval information, receiving
retrieval item information
return code receiving variable
return code receiving variable
RETURN statement
REVOKE
REVOKE access privilege
REVOKE CONNECT
REVOKE DBA
REVOKE RDAREA
REVOKE SCHEMA
ROLLBACK statement
routine
name
routine control SQL
row
deleting
deleting
deleting all
in table by column, updating
in table multiple times by column, updating
in table on column-by-column basis, updating
in table with FIX specification multiple times by row, updating
inserting
inserting
retrieving one
update value
update value
update value
updating by row
updating on row-by-row basis
using array, deleting
using array, inserting
using array, updating
row value constructors
row-partitioning
among servers
within a server
(S)
scalar function
list of
schema
defining
deleting
path
schema definition privilege
granting
revoking
search condition
search condition
search condition
search condition
SECOND[S]
SEGMENT REUSE
SEGMENT REUSE
SELECT
SELECT statement
dynamic
dynamic
single-row
selection expression
SET
SET
SET
SET
SET clause
SET clause
SET clause
SET DEFAULT clause
set function
set operation, results of
producing data length
producing data type
SET SESSION AUTHORIZATION statement
shared mode
shared mode
SIGNAL statement
SIMILAR predicate
single-byte character
SMALLFLT
SMALLINT
SOME
sort item specification number
space percentage, unused
special character in pattern character string
meaning of (XLIKE predicate)
special name
SPLIT
SQL
character set of
coding format of
executing
executing
nullifying preprocessing of
preprocessing
preprocessing
SQL compile option
SQL compile option
SQL compile option
SQL compile option
SQL compile option
SQL extension optimizing option
SQL extension optimizing option
SQL extension optimizing option
SQL extension optimizing option
SQL extension optimizing option
SQL object
recreating for functions
recreating for procedures
recreating for procedures
recreating for triggers
SQL optimization option
SQL optimization option
SQL optimization option
SQL optimization option
SQL optimization option
applying key conditions including scalar operations
applying key conditions including scalar operations
applying key conditions including scalar operations
applying key conditions including scalar operations
applying key conditions including scalar operations
deriving rapid search conditions
deriving rapid search conditions
deriving rapid search conditions
deriving rapid search conditions
deriving rapid search conditions
facility for batch acquisition from functions provided by plug-ins
facility for batch acquisition from functions provided by plug-ins
facility for batch acquisition from functions provided by plug-ins
facility for batch acquisition from functions provided by plug-ins
facility for batch acquisition from functions provided by plug-ins
forced nest-loop-join
forced nest-loop-join
forced nest-loop-join
forced nest-loop-join
forced nest-loop-join
forcing use of multiple indexes
forcing use of multiple indexes
forcing use of multiple indexes
forcing use of multiple indexes
forcing use of multiple indexes
group processing, ORDER BY processing, and DISTINCT set function processing at local back-end server
group processing, ORDER BY processing, and DISTINCT set function processing at local back-end server
group processing, ORDER BY processing, and DISTINCT set function processing at local back-end server
group processing, ORDER BY processing, and DISTINCT set function processing at local back-end server
group processing, ORDER BY processing, and DISTINCT set function processing at local back-end server
increasing number of floatable server candidates
increasing number of floatable server candidates
increasing number of floatable server candidates
increasing number of floatable server candidates
increasing number of floatable server candidates
increasing target floatable servers (back-end servers for fetching data)
increasing target floatable servers (back-end servers for fetching data)
increasing target floatable servers (back-end servers for fetching data)
increasing target floatable servers (back-end servers for fetching data)
increasing target floatable servers (back-end servers for fetching data)
limiting target floatable servers (back-end servers for fetching data)
limiting target floatable servers (back-end servers for fetching data)
limiting target floatable servers (back-end servers for fetching data)
limiting target floatable servers (back-end servers for fetching data)
limiting target floatable servers (back-end servers for fetching data)
making multiple SQL objects
making multiple SQL objects
making multiple SQL objects
making multiple SQL objects
making multiple SQL objects
prioritized nest-loop-join
prioritized nest-loop-join
prioritized nest-loop-join
prioritized nest-loop-join
prioritized nest-loop-join
priority of OR multiple index use
priority of OR multiple index use
priority of OR multiple index use
priority of OR multiple index use
priority of OR multiple index use
rapid grouping facility
rapid grouping facility
rapid grouping facility
rapid grouping facility
rapid grouping facility
separating data collecting servers
separating data collecting servers
separating data collecting servers
separating data collecting servers
separating data collecting servers
suppressing creation of update-SQL work tables
suppressing creation of update-SQL work tables
suppressing creation of update-SQL work tables
suppressing creation of update-SQL work tables
suppressing creation of update-SQL work tables
suppressing index use (forced table scan)
suppressing index use (forced table scan)
suppressing index use (forced table scan)
suppressing index use (forced table scan)
suppressing index use (forced table scan)
suppressing use of AND multiple indexes
suppressing use of AND multiple indexes
suppressing use of AND multiple indexes
suppressing use of AND multiple indexes
suppressing use of AND multiple indexes
SQL optimization specification
for used index
join method
subquery execution method
SQL parameter
assigning value to
name
name
SQL prefix
SQL procedure statement
SQL procedure statement
SQL procedure statement
SQL reserved word deletion facility
SQL statement
control SQL
data manipulation SQL
definition SQL
embedded language
maximum length of
routine control SQL
using array, executing
SQL terminator
SQL variable
assigning value to
SQLCODE variable
SQLERROR
SQLSTATE variable
SQLWARNING
statement
exiting
on rows, repeating
repeating
statement cursor, allocating
statement information item name
storage condition
storage condition
subquery
subscript
SUBSTR LENGTH
SUBSTR LENGTH
SUBSTR LENGTH
SUBSTR LENGTH
SUBSTR LENGTH
SUBSTR LENGTH
subtype clause
SUM
SUM
SUPPRESS
SUPPRESS
symbol conventions
system built-in scalar function
ABS
BIT_AND_TEST
CHARACTER
DATE
DAY
DAYS
DECIMAL
DIGITS
FLOAT
HEX
HOUR
INTEGER
LENGTH
LOWER
MINUTE
MOD
MONTH
POSITION
SECOND
SUBSTR
TIME
TIMESTAMP
TIMESTAMP_FORMAT
UPPER
VALUE
VARCHAR_FORMA
YEAR
SYSTEM GENERATED
system-defined scalar function
ACOS
ADD_INTERVAL
ASCII
ASIN
ATAN
ATAN2
CEIL
CENTURY
CHR
COS
COSH
DATE_TIME
DAYNAME
DAYOFWEEK
DAYOFYEAR
DEGREES
EXP
FLOOR
GREATEST
HALF
INSERTSTR
INSERTSTR_LONG
INTERVAL_DATETIMES
IS_DBLBYTES
IS_SNGLBYTES
ISDIGITS
LAST_DAY
LEAST
LEFTSTR
LN
LOG10
LTRIM
LTRIMSTR
MIDNIGHTSECONDS
MONTHNAME
MONTHS_BETWEEN
NEXT_DAY
NUMEDIT
PI
POSSTR
POWER
QUARTER
RADIANS
REPLACE
REPLACE_LONG
REVERSESTR
RIGHTSTR
ROUND
ROUNDMONTH
RTRIM
RTRIMSTR
SIGN
SIN
SINH
SQRT
STRTONUM
TAN
TANH
TRANSL
TRANSL_LONG
TRUNC
TRUNCYEAR
WEEK
WEEKOFMONTH
YEARS_BETWEEN
(T)
table
defining
deleting
option
reference
reference
reference
restriction definition
retrieving dynamically
specification of
table definition, altering
table expression
table expression
table expression
table name
table name
scope for
scope for
table primary
target audit event
defining
deleting
TB, meaning of
TIME
time data
time data
time data
predefined character string representation of
time interval data
time interval data
time interval data
decimal representation of
time operation
time stamp data
time stamp data
time stamp data
predefined character string representation of
TIMESTAMP
transaction
canceling
terminating normally
trigger
action
action time
defining
deleting
event
name
SQL statement
SQL statement
trigger SQL object, recreating
type
defining
mapping
(U)
UAP
connecting to HiRDB
disconnecting from HiRDB
executing command from
UNBALANCED SPLIT
UNBALANCED SPLIT
UNION
UNIQUE
UNIQUE
UNIQUE
uniqueness constraint, multicolumn
UNTIL DISCONNECT
UNTIL DISCONNECT
UNTIL DISCONNECT
UPDATE
UPDATE statement
UPDATE statement
UPDATE statement
preparable dynamic
preparable dynamic
update value
update value
update value
USER
user-defined data type
deleting
name
receiving definition information on
(V)
value
expression
predefined
specification
version number conventions
VIEW
VIEW
view table
read-only
writable
view, defining
(W)
WHENEVER
WHERE
WHERE
WHERE
WHERE
WHERE
WHERE
WHERE
WHERE
WHERE
WHERE search condition
WHERE search condition
WHILE statement
window function
window function
window specification
WITH DEFAULT
WITH DEFAULT
WITH DEFAULT
WITH EXCLUSIVE LOCK
WITH HOLD
WITH PROGRAM
WITH PROGRAM
WITH PROGRAM
WITH PROGRAM
WITH PROGRAM
WITH PROGRAM
WITH PROGRAM
WITH PROGRAM
WITH PROGRAM
WITH PROGRAM
WITH PROGRAM
WITH query name
WITH ROLLBACK
WITH ROLLBACK
WITH ROLLBACK
WITH ROLLBACK
WITH ROLLBACK
WITH ROLLBACK
WITH ROLLBACK
WITH ROLLBACK
WITH ROLLBACK
WITH ROLLBACK
WITH ROLLBACK
WITH ROLLBACK
WITH ROLLBACK
WITH ROLLBACK
WITH ROLLBACK
WITH ROLLBACK
WITH SHARE LOCK
WITHOUT LOCK [WAIT]
WITHOUT LOCK NOWAIT
WITHOUT PURGE
WITHOUT ROLLBACK
WRITE LINE statement
WRITE specification
(Y)
YEAR[S]