Neoview SQL Reference Manual (R2.4 SP2)
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, 343
examples of, 343
searched CASE form, 342
syntax diagram of, 342
CAST expression
data type conversion, 345
examples of, 345
syntax diagram of, 345
valid type combinations, 345
CEILING function
examples of, 347
syntax diagram of, 347
CHAR data type, 235, 236
CHAR function
examples of, 348
syntax diagram of, 348
CHAR VARYING data type, 236
CHAR_LENGTH function
examples of, 349
syntax diagram of, 349
Character sets, 224
setting default, 261
support standards, 517
Character string data types
CHAR and VARCHAR, differences, 236
maximum storage lengths, 236
Character string functions
summary of, 326
ASCII, 335
CHAR, 348
CHAR_LENGTH , 349
CODE_VALUE, 351
CONCAT, 352
INSERT, 395
LCASE, 399
LEFT, 400
LOCATE, 401
LOWER, 404
LPAD, 405
LTRIM, 406
OCTET_LENGTH, 425
POSITION, 428
REPEAT, 435
REPLACE, 436
RIGHT, 437
RPAD, 442
RTRIM, 443
SPACE, 455
SUBSTRING/SUBSTR, 459
TRANSLATE, 467
TRIM, 468
UCASE, 469
UPPER, 470
UPSHIFT, 471
Character string literals, 261
Character value expression
examples of, 244
syntax diagram of, 243
CHECK constraint, 47, 77, 227
Clauses
DEFAULT, 302
FORMAT, 304
SAMPLE, 306
SEQUENCE BY, 314
TRANSPOSE, 317
Cluster sampling, 308
Clustering key
description of, 260
limits, 511
COALESCE function
example of, 350
syntax diagram of, 350
CODE_VALUE function
example of, 351
syntax diagram of, 351
Column-list, general rules, 290
Columns
column reference, 225
default values, 226
description of, 225
qualified name, 225
COMMIT WORK statement
considerations for, 59
example of, 59
syntax diagram of, 59
Comparable data types, 144, 233
Comparison predicates
comparison operators, 274
data conversions, 276
examples of, 276
operand requirements, 275
syntax diagram of, 274
Compatible data types, 144, 233
CONCAT function
examples of, 352
syntax diagram of, 352
Concatenation operator (||)
description of, 352
examples of, 349, 352
Concurrency
DELETE statement, 108
description of, 29
INSERT statement, 144
SELECT statement, 171, 172
SET TRANSACTION statement, 190
UPDATE statement, 199
Constraints
CHECK, 227
description of, 227
524 Index