Neoview SQL Reference Manual (R2.3)

syntax diagram of, 306
CAST expression
data type conversion, 309
examples of, 310
syntax diagram of, 309
valid type combinations, 309
CEILING function
examples of, 311
syntax diagram of, 311
CHAR data type, 210, 211
CHAR function
examples of, 312
syntax diagram of, 312
CHAR VARYING data type, 211
CHAR_LENGTH function
examples of, 313
syntax diagram of, 313
Character sets
setting default, 233
support standards, 470
character sets, 200
Character string data types
CHAR and VARCHAR, differences, 211
examples of literals, 234
maximum storage lengths, 211
Character string functions
summary of, 290
ASCII, 299
CHAR, 312
CHAR_LENGTH , 313
COALESCE, 314
CODE_VALUE, 315
CONCAT, 316
INSERT, 356
LCASE, 360
LEFT, 361
LOCATE, 362
LOWER, 365
LPAD, 370
LTRIM, 371
OCTET_LENGTH, 391
POSITION, 394
REPEAT, 401
REPLACE, 401
RIGHT, 402
RPAD, 405
RTRIM, 406
SPACE, 418
TRANSLATE, 428
TRIM, 429
UCASE, 430
UPPER, 438
UPSHIFT, 439
Character string literals, 233
Character value expression
examples of, 218
syntax diagram of, 218
CHECK constraint, 203
Clauses
DEFAULT, 268
SAMPLE, 270
SEQUENCE BY, 278
TRANSPOSE, 281
Cluster sampling, 271
Clustering key
description of, 232
limits, 463
COALESCE function
example of, 314
COALESCE function, syntax diagram of, 314
CODE_VALUE function, syntax diagram of, 315
column-list, general rules, 256
Columns
column reference, 201
default values, 201
description of, 201
qualified name, 201
COMMIT WORK statement
constraints check, 56
syntax diagram of, 56
Comparable data types, 127, 209
Comparison predicates
comparison operators, 244
data conversions, 246
examples of, 246
operand requirements, 245
syntax diagram of, 244
Compatible data types, 127, 209
CONCAT function
examples of, 316
syntax diagram of, 316
Concatenation operator (||)
description of, 316
examples of, 313, 316
Concurrency
DELETE statement, 93
description of, 33
INSERT statement, 126, 127
SELECT statement, 153, 154
SET TRANSACTION statement, 174
UPDATE statement, 181
Constraints
CHECK, 203
description of, 203
limits, 463
NOT NULL, 203
PRIMARY KEY, 203
Control statements, 43
CONVERTTIMESTAMP function
examples of, 318
JULIANTIMESTAMP inverse relationship to, 318
syntax diagram of, 318
Correlation names
examples of, 204
purpose of, 204
table reference use of, 204
COS function
examples of, 319
472 Index