SQL Reference

38
J
JDBC client driver
portals 7
Unicode support 7
join 10
K
keywords, reserved SQL 34
L
LEFT function 29
LEFT OUTER JOIN 10
LENGTH function 31
LIKE operator 25
LN function 31
LOG function 31
logical operators in SQL expressions 27
LOWER function 29
LTRIM function 29
M
MAX function 31
MIN function 31
MINUTE function 31
MOD function 30
MONTH function 31
MONTHNAME function 29
N
NOT IN operator 26
NOT LIKE operator 25
NOT NULL (SQL clause) 20
NOT operator 27
null value 18
NULLIF function 33
numeric operators in SQL expressions 24
NUMVAL function 31
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 27
OR operator 27
ORDER BY (SQL clause) 12
OUTER JOIN 10
P
PDFs 5
peer rows 13
, 14
PI function 31
portals 7
positioned updates and deletes 14
PREVENT INDEX CREATION 23
PutAs function 18
, 19
R
RADIANS function 31
relational operators in SQL expressions 25
reserved SQL keywords 34
RIGHT function 29
RIGHT OUTER JOIN 10
ROUND function 31
RTRIM function 29
S
scientific notation in SQL expressions 24
SECOND function 31
SELECT (SQL statement) 8
binary data 15
BLOB data type 15
empty string 15
SIGN function 31
SIN function 31
sort order 12
SPACE function 29
SQL aggregate functions 28
SQL expressions 23
character operators 25
constants 23
date operators 25
exponential or scientific notation 24
field names 23
functions 28
logical operators 27
numeric operators 24
operator precedence 27
relational operators 25
SQL standards compliance 7
SQL statements
ALTER TABLE 21
CREATE INDEX 22
CREATE TABLE 20
DELETE 17
DROP INDEX 22
INSERT 17
reserved keywords 34
SELECT 8
supported by client drivers 7
UPDATE 19
SQL_C_WCHAR data type 7
SQL-92 7
SQRT function 31
standards compliance 7
string functions 29
STRVAL function 29
subqueries 18