SQL Reference

40
H
HAVING (SQL clause) 11
HOUR function 32
I
IN operator 26
INNER JOIN 10
INSERT (SQL statement) 17
INT function 32
IS NOT NULL operator 26
IS NULL operator 26
J
JDBC client driver
portals 7
Unicode support 7
join 10
K
keywords, reserved SQL 36
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 31
ModCount 34
, 35
MONTH function 32
MONTHNAME function 30
N
NOT IN operator 26
NOT LIKE operator 26
NOT NULL (SQL clause) 20
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
online documentation 5
operator precedence in SQL expressions 28
OR operator 27
ORDER BY (SQL clause) 12
OUTER JOIN 10
P
PDFs 5
peer rows 13
, 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 36
RIGHT function 30
RIGHT OUTER JOIN 10
ROUND function 32
ROWID system column 35
ROWMODID system column 35
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 32
SIN function 32
sort order 12
SPACE function 30
SQL aggregate functions 29
SQL expressions 23
character operators 25
constants 24
date operators 25
exponential or scientific notation 25
field names 23
functions 29
logical operators 27
numeric operators 25
operator precedence 28
relational operators 26