Index
Special characters
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
Special characters
- || (concatenation operator)
- ** (exponentiation)
- + (addition)
- ' (apostrophe) (1), (2), (3)
- * (asterisk) (1), (2)
- / (divide)
- * (multiply)
- % (percent) in LIKE predicate
- ? (question mark)
- - (subtraction)
- _ (underscore) in LIKE predicate
- *ALL (read stability) precompiler option
- *APOST precompiler option
- *CHG (uncommitted read) precompiler option
- *CNULRQD precompiler option (1), (2), (3), (4)
- *CS (cursor stability) precompiler option
- *DMY date and time format
- *EUR date and time format (1), (2)
- *HMS date and time format
- *ISO date and time format (1), (2)
- *JIS date and time format (1), (2)
- *JUL date and time format
- *MDY date and time format
- *NC (no commit) precompiler option
- .NET
- *NOCNULRQD precompiler option (1), (2), (3), (4)
- *NONE (no commit) precompiler option
- " (quotation mark)
- *QUOTE precompiler option
- *RR (repeatable read) precompiler option
- *RS (read stability) precompiler option
- *UR (uncommitted read) precompiler option
- *USA date and time format (1), (2)
- *YMD date and time format
A
B
C
D
- DATA
- data access classification
- DATA DICTIONARY clause
- data representation
- data type
- data-type (1), (2), (3), (4), (5), (6), (7)
- data type for CREATE FUNCTION (SQL Scalar)
- data type for CREATE FUNCTION (SQL Table)
- DATABASE
- database manager limits
- DataLink
- DATALINK (1), (2)
- datalink-options
- DATAPARTITIONNAME function
- DATAPARTITIONNUM function
- date
- DATE
- date and time
- datetime
- DATETIME_INTERVAL_CODE
- DATFMT clause
- DATSEP clause
- DAY function
- DAYNAME function
- DAYOFMONTH function
- DAYOFWEEK function
- DAYOFWEEK_ISO function
- DAYOFYEAR function
- DAYS function
- DB2_AUTHENTICATION_TYPE
- DB2_AUTHORIZATION_ID
- DB2_BASE_CATALOG_NAME
- DB2_BASE_COLUMN_NAME
- DB2_BASE_SCHEMA_NAME
- DB2_BASE_TABLE_NAME
- DB2_CCSID
- DB2_COLUMN_CATALOG_NAME
- DB2_COLUMN_GENERATED
- DB2_COLUMN_GENERATION_TYPE
- DB2_COLUMN_HIDDEN
- DB2_COLUMN_NAME
- DB2_COLUMN_ROW_CHANGE
- DB2_COLUMN_SCHEMA_NAME
- DB2_COLUMN_TABLE_NAME
- DB2_COLUMN_UPDATABILITY
- DB2_CONNECTION_METHOD
- DB2_CONNECTION_NUMBER
- DB2_CONNECTION_STATE
- DB2_CONNECTION_STATUS
- DB2_CONNECTION_TYPE
- DB2_CORRELATION_NAME
- DB2_CURSOR_HOLDABILITY
- DB2_CURSOR_NAME
- DB2_CURSOR_RETURNABILITY
- DB2_CURSOR_SCROLLABILITY
- DB2_CURSOR_SENSITIVITY
- DB2_CURSOR_UPDATABILITY
- DB2_DIAGNOSTIC_ CONVERSION_ERROR
- DB2_DYN_QUERY_MGMT
- DB2_ENCRYPTION_TYPE
- DB2_ERROR_CODE1
- DB2_ERROR_CODE2
- DB2_ERROR_CODE3
- DB2_ERROR_CODE4
- DB2_GET_DIAGNOSTICS _DIAGNOSTICS
- DB2_INTERNAL_ERROR _POINTER
- DB2_LABEL
- DB2_LAST_ROW
- DB2_LINE_NUMBER
- DB2_MAX_ITEMS
- DB2_MESSAGE_ID
- DB2_MESSAGE_ID1
- DB2_MESSAGE_ID2
- DB2_MESSAGE_KEY
- DB2_MODULE_DETECTING _ERROR
- DB2_NUMBER_CONNECTIONS
- DB2_NUMBER_FAILING_ STATEMENTS
- DB2_NUMBER_PARAMETER _MARKERS
- DB2_NUMBER_RESULT_SETS
- DB2_NUMBER_ROWS
- DB2_NUMBER_SUCCESSFUL_
- DB2_OFFSET
- DB2_ORDINAL_TOKEN_n
- DB2_PARAMETER_NAME
- DB2_PARTITION_NUMBER
- DB2_PRODUCT_ID
- DB2_REASON_CODE
- DB2_RELATIVE_COST_ ESTIMATE
- DB2_RESULT_SET_LOCATOR
- DB2_RESULT_SET_ROWS
- DB2_RESULT_SETS_COUNT
- DB2_RETURN_STATUS
- DB2_RETURNED_SQLCODE
- DB2_ROW_COUNT_SECONDARY
- DB2_ROW_LENGTH
- DB2_ROW_NUMBER
- DB2_SERVER_CLASS_NAME
- DB2_SERVER_NAME
- DB2_SQL_ATTR_CONCURRENCY
- DB2_SQL_ATTR_CURSOR _CAPABILITY
- DB2_SQL_ATTR_CURSOR _HOLD
- DB2_SQL_ATTR_CURSOR _ROWSET
- DB2_SQL_ATTR_CURSOR _SCROLLABLE
- DB2_SQL_ATTR_CURSOR _SENSITIVITY
- DB2_SQL_ATTR_CURSOR_TYPE
- DB2_SQLERRD_SET
- DB2_SQLERRD1
- DB2_SQLERRD2
- DB2_SQLERRD3
- DB2_SQLERRD4
- DB2_SQLERRD5
- DB2_SQLERRD6
- DB2_SYSTEM_COLUMN_NAME
- DB2_TOKEN_COUNT
- DB2_TOKEN_STRING
- DB2GENERAL clause
- DB2SQL clause
- DBCLOB (1), (2)
- DBCS (double-byte character set)
- DBGVIEW clause
- DBINFO clause
- DBPARTITIONNAME function
- DBPARTITIONNUM function
- DEALLOCATE DESCRIPTOR statement
- DEBUG MODE clause
- DECFLOAT
- DECFLOAT function
- DECFLOAT_SORTKEY function
- DECFLTRND clause
- decimal
- DECIMAL (1), (2)
- decimal data
- decimal floating-point
- DECIMAL function
- decimal point
- declaration
- DECLARE CURSOR statement
- DECLARE GLOBAL TEMPORARY TABLE statement
- DECLARE PROCEDURE statement
- DECLARE STATEMENT statement
- DECLARE statements
- DECLARE VARIABLE statement
- DECMPT clause
- DECRESULT clause
- DECRYPT_BINARY function
- DECRYPT_BIT function
- DECRYPT_CHAR function
- DECRYPT_DB function
- DEFAULT
- DEFAULT clause
- default date format (1), (2)
- default decimal point
- default decimal separator character
- default schema
- default time format (1), (2)
- degree
- DEGREES function
- DELETE
- DELETE clause
- delete-connected table
- DELETE ROWS
- delete rules
- DELETE statement
- deleting SQL objects
- delimited identifier
- DENSE_RANK
- dependent row
- dependent table
- derived table
- DESC clause
- descendent row
- descendent table
- DESCRIBE CURSOR statement
- DESCRIBE INPUT statement
- DESCRIBE PROCEDURE statement
- DESCRIBE statement
- DESCRIBE TABLE statement
- descriptor-name
- designator
- detecting and processing error and warning conditions
- DETERMINISTIC clause
- DFTRDBCOL clause
- DIFFERENCE function
- DIGITS function
- dirty read
- DISALLOW PARALLEL clause
- DISCONNECT statement
- disconnecting SQL objects
- DISTINCT
- DISTINCT clause
- DISTINCT predicate
- distinct type
- distinct-type (1), (2)
- DISTINCT TYPE clause
- distinct-type-name
- distinct types
- distributed data
- distributed relational database
- distributed relational database architecture (DRDA)
- distributed tables
- distributed unit of work
- division by zero
- division operator
- DLCOMMENT function
- DLLINKTYPE function
- DLURLCOMPLETE function
- DLURLPATH function
- DLURLPATHONLY function
- DLURLSCHEME function
- DLURLSERVER function
- DLVALUE function
- DLYPRP clause
- dormant connection state
- DOUBLE
- double-byte character
- double-byte character set (DBCS)
- DOUBLE PRECISION (1), (2)
- double-precision floating point
- DOUBLE_PRECISION function
- DRDA (Distributed Relational Database Architecture)
- DROP CHECK clause
- DROP COLUMN clause
- DROP CONSTRAINT clause
- DROP DEFAULT clause
- DROP FIELDPROC clause
- DROP FOREIGN KEY clause
- DROP IDENTITY clause
- DROP materialized query clause
- DROP NOT NULL clause
- DROP PARTITION
- DROP PARTITIONING
- DROP PRIMARY KEY clause
- DROP ROW CHANGE TIMESTAMP clause
- DROP statement
- DROP UNIQUE clause
- duplicate rows with UNION
- duration
- DYNAMIC_FUNCTION
- DYNAMIC_FUNCTION_CODE
- dynamic select
- dynamic SQL
- DYNDFTCOL clause
- DYNUSRPRF clause
E
F
- FENCED clause
- fetch-first-clause
- FETCH FIRST clause
- FETCH statement
- FIELDPROC
- file reference
- FINAL CALL clause
- FINAL TABLE clause
- FIRST clause
- FLOAT (1), (2)
- FLOAT function
- floating point
- FLOOR function
- FOR BIT DATA clause (1), (2)
- FOR clause
- FOR COLUMN clause
- FOR FETCH ONLY clause
- FOR MIXED DATA clause (1), (2)
- FOR READ ONLY clause
- FOR ROWS clause
- FOR SBCS DATA clause (1), (2)
- FOR statement
- FOR UPDATE OF clause
- foreign key
- FOREIGN KEY clause
- FORTRAN
- FREE LOCATOR statement
- FROM clause
- FULL JOIN clause
- FULL OUTER JOIN clause
- fullselect
- function (1), (2)
- aggregate (1), (2)
- best fit
- built-in
- column (1), (2)
- commenting
- creating (1), (2), (3), (4), (5), (6)
- dropping
- extending a built-in function
- external (1), (2), (3)
- granting
- input parameters
- invocation
- labeling
- locators
- name restrictions
- nesting
- overriding a built-in function
- resolution
- revoking
- scalar (1), (2)
- sourced (1), (2)
- specific name
- SQL (1), (2), (3)
- table (1), (2)
- types
- user-defined
- FUNCTION clause
- function invocation
- function-name
- function reference
- function resolution
- functions
G
H
I
J
K
L
M
N
O
P
Q
R
S
- savepoint
- SAVEPOINT LEVEL clause
- savepoint–name
- SAVEPOINT statement
- SBCS data
- scalar-fullselect
- scalar function (1), (2)
- scalar-subselect
- SCALE
- scale of data
- schema
- SCHEMA clause
- schema-name
- SCHEMA_NAME
- schema name generation
- SCHEMATA view
- SCORE function
- SCRATCHPAD clause
- SCROLL clause
- SEARCH BREADTH FIRST clause
- search condition
- search-condition
- SEARCH DEPTH FIRST clause
- searched-when-clause
- SECOND function
- SELECT clause
- SELECT INTO statement
- select list
- select-statement
- SELECT statement
- self-referencing row
- self-referencing table
- SENSITIVE clause
- sequence
- SEQUENCE clause
- sequence-name
- sequence reference
- sequences
- SERIALIZABLE clause
- server-name
- SERVER_NAME
- SESSION_USER special register
- SET clause
- SET CONNECTION statement
- SET CURRENT DEBUG MODE statement
- SET CURRENT DECFLOAT ROUNDING MODE statement
- SET CURRENT DEGREE statement
- SET CURRENT IMPLICIT XMLPARSE OPTION statement
- SET DATA TYPE clause
- SET default-clause
- SET DEFAULT delete rule
- SET DEFAULT update rule
- SET DESCRIPTOR statement
- SET DESCRIPTOR statement
- SET ENCRYPTION PASSWORD statement
- set function
- SET GENERATED ALWAYS clause
- SET GENERATED BY DEFAULT clause
- SET IMPLICITLY HIDDEN clause
- SET NOT HIDDEN clause
- SET NOT NULL clause
- SET NULL delete rule
- SET NULL update rule
- set operation
- SET OPTION statement
- SET PATH statement
- SET RESULT SETS statement
- SET SCHEMA statement
- SET SESSION AUTHORIZATION statement
- SET TRANSACTION statement
- SET transition-variable statement
- SET variable statement
- SHARE
- share locks
- SHARE MODE clause
- shift-in character
- SIGN function
- SIGNAL statement (1), (2)
- simple-when-clause
- SIN function
- single-byte character
- single-precision floating-point
- single row select
- SINH function
- SKIP LOCKED DATA
- small integers
- SMALLINT (1), (2)
- SMALLINT data type
- SMALLINT function
- SOME quantified predicate
- sort-key-expression
- sort sequence
- SOUNDEX function
- sourced
- SPACE function
- special register
- SPECIFIC clause
- specific-name
- SPECIFIC_NAME
- SQL
- SQL (structured query language)
- SQL (Structured Query language)
- SQL (Structured Query Language) (1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15)
- SQL clause
- SQL conditions
- SQL control statements
- SQL cursors
- SQL-descriptor-name
- SQL_FEATURES table
- SQL-label
- SQL labels
- SQL_LANGUAGES table
- SQL-parameter-name
- SQL parameters
- SQL path
- SQL-procedure-statement
- SQL server mode
- SQL_SIZING table
- SQL statement
- SQL statements
- SQL-variable-name
- SQLCA (SQL communication area)
- SQLCA (SQL communication area) clause
- SQLCA clause
- SQLCODE
- SQLCOLPRIVILEGES view
- SQLCOLUMNS view
- SQLCURRULE clause
- SQLD field of SQLDA (1), (2), (3), (4), (5), (6)
- SQLDA (SQL descriptor area)
- SQLDA (SQL descriptor area) clause
- SQLDABC field of SQLDA (1), (2), (3), (4), (5), (6)
- SQLDAID field of SQLDA (1), (2), (3), (4), (5), (6)
- SQLDATA field of SQLDA
- SQLDATALEN field of SQLDA
- SQLERRMC field of SQLCA
- SQLERROR clause
- SQLFOREIGNKEYS view
- SQLFUNCTIONCOLS view
- SQLFUNCTIONS view
- SQLIND field of SQLDA
- SQLLEN field of SQLDA (1), (2)
- SQLLONGLEN field of SQLDA
- SQLN field of SQLDA (1), (2), (3), (4), (5), (6)
- SQLNAME field of SQLDA (1), (2)
- SQLPATH clause
- SQLPRIMARYKEYS view
- SQLPROCEDURECOLUMNS view
- SQLPROCEDURES view
- SQLSCHEMAS view
- SQLSPECIALCOLUMNS view
- SQLSTATE
- SQLSTATISTICS view
- SQLTABLEPRIVILEGES view
- SQLTABLES view
- SQLTYPE
- SQLTYPE field of SQLDA (1), (2)
- SQLTYPEINFO table
- SQLUDTS view
- SQLVAR field of SQLDA (1), (2), (3), (4), (5), (6)
- SQLvariables
- SQLWARNING clause
- SQRT function
- SRTSEQ clause
- STACKED
- standards option
- START WITH clause
- statement-name
- statement string
- states
- STATIC DISPATCH clause
- static select
- static SQL (1), (2)
- STDDEV function
- STDDEV_POP function
- STDDEV_SAMP function
- string
- string delimiter (1), (2), (3)
- string-expression
- STRIP function
- SUBCLASS_ORIGIN
- subnormal numbers
- subquery
- subquery in a basic predicate
- subselect
- substitution character
- SUBSTMTS
- SUBSTR function
- SUBSTRING function
- subtraction operator
- SUM function
- super groups
- surrogates
- synonym for qualifying a column name
- SYSCATALOGS view
- SYSCHKCST view
- SYSCOLUMNS view
- SYSCOLUMNSTAT view
- SYSCST view
- SYSCSTCOL view
- SYSCSTDEP view
- SYSFIELDS view
- SYSFUNCS view
- SYSINDEXES view
- SYSINDEXSTAT view
- SYSJARCONTENTS view
- SYSJAROBJECTS view
- SYSKEYCST view
- SYSKEYS view
- SYSMQTSTAT view
- SYSPACKAGE view
- SYSPACKAGESTAT view
- SYSPARMS table
- SYSPARTITIONINDEXES view
- SYSPARTITIONINDEXSTAT view
- SYSPARTITIONMQTS view
- SYSPARTITIONSTAT view
- SYSPROCS view
- SYSPROGRAMSTAT view
- SYSREFCST view
- SYSROUTINEDEP view
- SYSROUTINES table
- SYSSCHEMAS view
- SYSSEQUENCES view
- SYSTABLEDEP view
- SYSTABLEINDEXSTAT view
- SYSTABLES view
- SYSTABLESTAT view
- system column name (1), (2), (3), (4), (5), (6), (7), (8)
- system-column-name
- system identifier
- SYSTEM NAME clause
- system name generation
- SYSTEM NAMES
- system-object-name
- system path
- system schema name
- system-schema-name
- system table name
- SYSTEM_USER special register
- SYSTRIGCOL view
- SYSTRIGDEP view
- SYSTRIGGERS view
- SYSTRIGUPD view
- SYSTYPES table
- SYSVARIABLEDEP view
- SYSVARIABLES table
- SYSVIEWDEP view
- SYSVIEWS view
T
U
V
W
- WAIT FOR OUTCOME
- WEEK function
- WEEK_ISO function
- WHENEVER statement
- WHERE clause
- WHERE CURRENT OF clause
- WHERE NOT NULL clause
- WHILE statement
- WITH CASCADED CHECK OPTION clause
- WITH CHECK OPTION clause
- WITH CHECK OPTION clause of CREATE VIEW statement
- WITH clause
- WITH COMPARISONS
- WITH DATA DICTIONARY clause
- WITH DEFAULT clause
- WITH DISTINCT VALUES clause
- WITH EMPTY TABLE
- WITH EXTENDED INDICATORS clause
- WITH GRANT OPTION clause
- WITH HOLD clause
- WITH LOCAL CHECK OPTION clause
- WITH NO HOLD clause
- WITH REPLACE clause
- WITH RETURN clause
- WITHOUT EXTENDED INDICATORS clause
- WITHOUT RETURN clause
- words
- WORK clause
- WRITE clause
X
Y
Z