Neoview SQL Reference Manual (R2.4)

required privileges, 55
syntax diagram of, 55
usage restrictions, 55
CASE expression
data type of, 335
examples of, 335
searched CASE form, 334
syntax diagram of, 334
CAST expression
data type conversion, 337
examples of, 337
syntax diagram of, 337
valid type combinations, 337
CEILING function
examples of, 339
syntax diagram of, 339
CHAR data type, 233, 234
CHAR function
examples of, 340
syntax diagram of, 340
CHAR VARYING data type, 234
CHAR_LENGTH function
examples of, 341
syntax diagram of, 341
Character sets
setting default, 256
support standards, 511
character sets, 222
Character string data types
CHAR and VARCHAR, differences, 234
maximum storage lengths, 234
Character string functions
summary of, 318
ASCII, 327
CHAR, 340
CHAR_LENGTH , 341
CODE_VALUE, 343
CONCAT, 344
INSERT, 386
LCASE, 390
LEFT, 391
LOCATE, 392
LOWER, 395
LPAD, 400
LTRIM, 401
OCTET_LENGTH, 420
POSITION, 423
REPEAT, 430
REPLACE, 431
RIGHT, 432
RPAD, 437
RTRIM, 438
SPACE, 450
SUBSTRING/SUBSTR, 454
TRANSLATE, 462
TRIM, 463
UCASE, 464
UPPER, 472
UPSHIFT, 473
Character string literals, 256
Character value expression
examples of, 241
syntax diagram of, 240
CHECK constraint, 75, 225
Clauses
DEFAULT, 294
FORMAT, 296
SAMPLE, 298
SEQUENCE BY, 306
TRANSPOSE, 309
Cluster sampling, 300
Clustering key
description of, 255
limits, 505
COALESCE function
example of, 342
syntax diagram of, 342
CODE_VALUE function
example of, 343
syntax diagram of, 343
Column-list, general rules, 284
Columns
column reference, 223
default values, 223
description of, 223
qualified name, 223
COMMIT WORK statement
example of, 58
syntax diagram of, 58
Comparable data types, 144, 231
Comparison predicates
comparison operators, 268
data conversions, 270
examples of, 270
operand requirements, 269
syntax diagram of, 268
Compatible data types, 144, 231
CONCAT function
examples of, 344
syntax diagram of, 344
Concatenation operator (||)
description of, 344
examples of, 341, 344
Concurrency
DELETE statement, 107
description of, 31
INSERT statement, 143, 144
SELECT statement, 171, 172
SET TRANSACTION statement, 191
UPDATE statement, 198
Constraints
CHECK, 225
description of, 225
limits, 505
NOT NULL, 225
PRIMARY KEY, 225
CONVERTTIMESTAMP function
examples of, 347
516 Index