Neoview SQL Reference Manual (R2.5)

Bulk replicator
REPLICATE command, 224
C
CALL statement
considerations for, 56
description for, 56
examples of, 57
required privileges, 56
syntax diagram of, 56
usage restrictions, 56
CASE expression
data type of, 355
examples of, 355
searched CASE form, 354
syntax diagram of, 354
CAST expression
data type conversion, 357
examples of, 357
syntax diagram of, 357
valid type combinations, 357
CEILING function
examples of, 359
syntax diagram of, 359
CHAR data type, 248, 249
CHAR function
examples of, 360
syntax diagram of, 360
CHAR VARYING data type, 248
CHAR_LENGTH function
examples of, 361
syntax diagram of, 361
Character sets, 234
setting default, 274
support standards, 529
Character string data types
CHAR and VARCHAR, differences, 249
maximum storage lengths, 249
Character string functions
summary of, 338
ASCII, 347
CHAR, 360
CHAR_LENGTH , 361
CODE_VALUE, 363
CONCAT, 364
INSERT, 407
LCASE, 411
LEFT, 412
LOCATE, 413
LOWER, 416
LPAD, 417
LTRIM, 418
OCTET_LENGTH, 437
POSITION, 440
REPEAT, 447
REPLACE, 448
RIGHT, 449
RPAD, 454
RTRIM, 455
SPACE, 467
SUBSTRING/SUBSTR, 471
TRANSLATE, 479
TRIM, 480
UCASE, 481
UPPER, 482
UPSHIFT, 483
Character string literals, 274
Character value expression
examples of, 256
syntax diagram of, 255
CHECK constraint, 47, 77, 237
Clauses
DEFAULT, 314
FORMAT, 316
SAMPLE, 318
SEQUENCE BY, 326
TRANSPOSE, 329
Cluster sampling, 320
Clustering key
description of, 272
limits, 523
COALESCE function
example of, 362
syntax diagram of, 362
CODE_VALUE function
example of, 363
syntax diagram of, 363
Column-list, general rules, 303
Columns
column reference, 235
default values, 236
description of, 235
qualified name, 235
COMMIT WORK statement
considerations for, 59
example of, 59
syntax diagram of, 59
Comparable data types, 145, 245
Comparison predicates
comparison operators, 287
data conversions, 289
examples of, 289
operand requirements, 288
syntax diagram of, 287
Compatible data types, 145, 245
CONCAT function
examples of, 364
syntax diagram of, 364
Concatenation operator (||)
description of, 364
examples of, 361, 364
Concurrency
DELETE statement, 110
description of, 29
INSERT statement, 145
SELECT statement, 172, 173
SET TRANSACTION statement, 191
UPDATE statement, 200
536 Index