REC2XML SNAPSHOT DATABASE REPEAT SNAPSHOT DBM REPLACE 442 SNAPSHOT_DYN_ SQL RIGHT 443 SNAPSHOT FCM ROUND SNAPSHOT FCMPARTITION RTRIM SNAPSHOT LOCK RTRIM(SYSFUN schema) SNAPSHOT LOCKWAIT SECOND SNAPSHOT QUIESCERS SIGN SNAPSHOT RANGES SNAPSHOT STATEMENT SINH 451 SNAPSHOT SUBSECT SMALLINT SNAPSHOT SWITCHES SOUNDEX SNAPSHOT TABLE E 454 SNAPSHOT TBS SNAPSHOT TBS CFG SUBSTR SQLCACHE_SNAPSHOT TABLE NAME Procedures TABLE SCHEMA 461 GET ROUTINE SAR 46 TAN PUT ROUTINE SAR TANH User-defined functions TIMESTAMP Chapter 4. Queries 553 TIMESTAMP FORMAT 468 SOL IMESTAMP ISO 470 Subselect TIMESTAMPDIFF select-clause 555 TO CHAR from-clause TO DATE table-reference 561 TRANSLATE joined-table TRUnCAtE or TRUNC where-clause TYPE ID group-by-cla ause TYPE NAME ause TYPE SCHEMA order-by-clause UCASE or UPPER fetch-first-clause ALUE Examples of subselects VARCHAR 583 VARCHAR FORMAT Examples of grouping sets, cube, and VARGRAPHIC WEEK Fullselect 597 WEEK ISO Examples of a fullselect YEAR Select-statement 601 Table functions common-tab express MQREADALL update-clause MQREADALLCLOB read-only-clause MQRECEIVEALL ptimize-for-clause MQRECEIVEALLCLOB Examples of a select-statemeni SNAPSHOT AGENT SNAPSHOT APPL AppendⅸxA. SQL limits 0 SNAPSHOT APPL INFO 510 SNAPSHOT BP 512 AppendⅸxB. SQLCA(sQL SNAPSHOT CONTAINER 514 communications area) 615 VI SQL Reference, Volume 1REC2XML . . . . . . . . . . . . 436 REPEAT . . . . . . . . . . . . . 441 REPLACE . . . . . . . . . . . . 442 RIGHT . . . . . . . . . . . . . 443 ROUND . . . . . . . . . . . . . 444 RTRIM . . . . . . . . . . . . . 446 RTRIM (SYSFUN schema) . . . . . . . 447 SECOND . . . . . . . . . . . . 448 SIGN . . . . . . . . . . . . . . 449 SIN . . . . . . . . . . . . . . 450 SINH . . . . . . . . . . . . . . 451 SMALLINT . . . . . . . . . . . . 452 SOUNDEX . . . . . . . . . . . . 453 SPACE . . . . . . . . . . . . . 454 SQRT . . . . . . . . . . . . . . 455 SUBSTR . . . . . . . . . . . . . 456 TABLE_NAME. . . . . . . . . . . 460 TABLE_SCHEMA. . . . . . . . . . 461 TAN . . . . . . . . . . . . . . 463 TANH . . . . . . . . . . . . . 464 TIME . . . . . . . . . . . . . . 465 TIMESTAMP . . . . . . . . . . . 466 TIMESTAMP_FORMAT . . . . . . . . 468 TIMESTAMP_ISO . . . . . . . . . . 470 TIMESTAMPDIFF. . . . . . . . . . 471 TO_CHAR . . . . . . . . . . . . 473 TO_DATE . . . . . . . . . . . . 474 TRANSLATE . . . . . . . . . . . 475 TRUNCATE or TRUNC. . . . . . . . 478 TYPE_ID. . . . . . . . . . . . . 480 TYPE_NAME . . . . . . . . . . . 481 TYPE_SCHEMA . . . . . . . . . . 482 UCASE or UPPER . . . . . . . . . 483 VALUE . . . . . . . . . . . . . 484 VARCHAR . . . . . . . . . . . . 485 VARCHAR_FORMAT . . . . . . . . 487 VARGRAPHIC. . . . . . . . . . . 489 WEEK . . . . . . . . . . . . . 491 WEEK_ISO . . . . . . . . . . . . 492 YEAR. . . . . . . . . . . . . . 493 Table functions. . . . . . . . . . . 494 MQREADALL . . . . . . . . . . . 495 MQREADALLCLOB . . . . . . . . . 497 MQRECEIVEALL . . . . . . . . . . 499 MQRECEIVEALLCLOB. . . . . . . . 502 SNAPSHOT_AGENT . . . . . . . . 505 SNAPSHOT_APPL . . . . . . . . . 506 SNAPSHOT_APPL_INFO . . . . . . . 510 SNAPSHOT_BP . . . . . . . . . . 512 SNAPSHOT_CONTAINER. . . . . . . 514 SNAPSHOT_DATABASE . . . . . . . 516 SNAPSHOT_DBM . . . . . . . . . 521 SNAPSHOT_DYN_SQL . . . . . . . . 523 SNAPSHOT_FCM . . . . . . . . . 525 SNAPSHOT_FCMPARTITION . . . . . 526 SNAPSHOT_LOCK . . . . . . . . . 527 SNAPSHOT_LOCKWAIT . . . . . . . 529 SNAPSHOT_QUIESCERS . . . . . . . 531 SNAPSHOT_RANGES . . . . . . . . 532 SNAPSHOT_STATEMENT . . . . . . . 533 SNAPSHOT_SUBSECT . . . . . . . . 535 SNAPSHOT_SWITCHES . . . . . . . 537 SNAPSHOT_TABLE . . . . . . . . . 538 SNAPSHOT_TBS . . . . . . . . . . 540 SNAPSHOT_TBS_CFG . . . . . . . . 542 SQLCACHE_SNAPSHOT . . . . . . . 544 Procedures . . . . . . . . . . . . 545 GET_ROUTINE_SAR . . . . . . . . 546 PUT_ROUTINE_SAR . . . . . . . . 548 User-defined functions . . . . . . . . 550 Chapter 4. Queries . . . . . . . . . 553 SQL queries. . . . . . . . . . . . 553 Subselect. . . . . . . . . . . . . 554 select-clause. . . . . . . . . . . 555 from-clause . . . . . . . . . . . 560 table-reference . . . . . . . . . . 561 joined-table . . . . . . . . . . . 565 where-clause . . . . . . . . . . 568 group-by-clause . . . . . . . . . 569 having-clause . . . . . . . . . . 576 order-by-clause . . . . . . . . . 576 fetch-first-clause . . . . . . . . . 579 Examples of subselects . . . . . . . 580 Examples of joins . . . . . . . . . 583 Examples of grouping sets, cube, and rollup . . . . . . . . . . . . . 586 Fullselect. . . . . . . . . . . . . 597 Examples of a fullselect . . . . . . . 598 Select-statement . . . . . . . . . . 601 common-table-expression . . . . . . 601 update-clause . . . . . . . . . . 603 read-only-clause . . . . . . . . . 604 optimize-for-clause . . . . . . . . 605 Examples of a select-statement . . . . 605 Appendix A. SQL limits . . . . . . . 607 Appendix B. SQLCA (SQL communications area) . . . . . . . 615 vi SQL Reference, Volume 1