SQL Reference

Index 41
IS NOT NULL operator 26
IS NULL operator 26
J
JDBC client driver
portals 7
Unicode support 7
join 10
K
keywords, reserved SQL 37
L
LEFT function 30
LEFT OUTER JOIN 10
LENGTH function 32
LIKE operator 26
LN function 32
LOG function 32
logical operators in SQL expressions 27
LOWER function 30
LTRIM function 30
M
MAX function 32
MIN function 32
MINUTE function 32
MOD function 32
ModCount 35
MONTH function 32
MONTHNAME function 30
N
NOT IN operator 26
NOT LIKE operator 26
NOT NULL (SQL clause) 21
NOT operator 27
null value 18
NULLIF function 34
numeric operators in SQL expressions 25
NUMVAL function 32
O
ODBC client driver
portals 7
Unicode support 7
ODBC standards compliance 7
OFFSET (SQL clause) 13
operator precedence in SQL expressions 28
OR operator 27
ORDER BY (SQL clause) 13
OUTER JOIN 10
P
peer rows 14
PI function 32
portals 7
positioned updates and deletes 14
PREVENT INDEX CREATION 23
PutAs function 18
, 19
R
RADIANS function 32
relational operators in SQL expressions 26
reserved SQL keywords 37
RIGHT function 30
RIGHT OUTER JOIN 10
ROUND function 32
ROWID system column 36
ROWMODID system column 36
RTRIM function 30
S
scientific notation in SQL expressions 25
SECOND function 32
SELECT (SQL statement) 8
binary data 15
BLOB data type 15
empty string 15
SIGN function 33
SIN function 33
SPACE function 30
SQL aggregate functions 28
SQL expressions 23
character operators 25
constants 23
date operators 25
exponential or scientific notation 25
field names 23
functions 28
logical operators 27
numeric operators 25
operator precedence 28
relational operators 26
SQL standards compliance 7
SQL statements
ALTER TABLE 22
CREATE INDEX 22
CREATE TABLE 20
DELETE 17
DROP INDEX 23
INSERT 17
reserved keywords 37
SELECT 8
supported by client drivers 7
TRUNCATE TABLE 21
UPDATE 19
SQL_C_WCHAR data type 7
SQL-92 7