II08226: CHANGES TO DB2 SQL REFERENCE SC26-4890-00 THAT DID NOT MAKE THE VERSION 3 GA PUBS. CONTINUED FROM II07609.

APAR status

• Closed as canceled.

Error description

• This Info. APAR documents changes to the DB2 SQL Reference
  SC26489000 which did not make the Version 3 GA pubs.
  Continuation of II07609.
  5740xyr00 R310
  ================================================================
  Book Title: SQL Reference
  Version: 3.1
  Pages: 55
  Change Description:
  
  Change the last bullet in the list that describes where
  long string column cannot be referenced to:
  
       Long string columns cannot be referenced in:
       -
       - A predicate other than EXISTS or LIKE (for LIKE,
         you can use a long string column for the first
         operand but not for the second operand)
  ===============================================================
  Book Title:  DB2 SQL Reference
  Version: 3
  page: 157
  
  Change Description:
  
     Replace: "There is another form of the SELECT statement
               described in "SELECT INTO" on page 373.
  
     With:   "There is another SQL statement called
              SELECT INTO, which is described in "SELECT INTO"
              on page 373.  SELECT INTO is not a subselect,
              fullselect, or select-statement."
  ================================================================
  Book Title:  DB2 SQL Reference
  Version: 3
  page: 166
  Change Description:
  
      Add the following footnote to the second sentence of
      the first paragraph on the page:
              "DB2 allows SELECT INTO as the operands of
               UNION.  This is a deprecated feature with
               undefined results."
  ================================================================
  Version 3 Book Title:  SQL Reference
  Pages:  186
  
  Change Description:
  Modify the 3rd sentence of the description for the PART
  clause to include the list of clauses that cannot be
  used when PART is specified:
  
     You must not use this clause if the index is not
  |  partitioned, or if you use the BUFFERPOOL, CLOSE,
  |  or DSETPASS clause.
  ============================================================
  Version 3 Book Title:  DB2 SQL Reference
  Pages: 198 (ALTER TABLE), 255 (CREATE TABLE)
  Change Description:
  
  For both ALTER TABLE and CREATE TABLE, modify the
  description of the "constant" parameter for FIELDPROC to:
  
   constant
      Is a parameter that is passed to the field procedure
      when it is invoked.  A parameter list is optional.
      The nth parameter specified in the FIELDPROC clause on
      ALTER (CREATE) TABLE corresponds to the nth parameter
      of the specified field procedure.  The maximum length
      of the parameter list is 254 bytes, including commas
      but excluding insignificant blanks and delimiting
      parentheses.
  ================================================================
  Version 3 Book Title: SQL Reference
  Pages: 202
  Change Description:
  
  Under "Invalidation of plans and packages", replace the
  last bullet and add a paragraph as follows:
  
   o A self-referencing constraint is defined.
  
  When a referential constraint is defined with a delete rule
  of CASCADE or SET NULL, all plans and packages that refer
  to the parent table of the constraint are invalidated.
  Furthermore, all plans and packages that refer to tables
  from which deletes cascade to this parent table are also
  invalidated.
  ================================================================
  Version 3 Book Title:  SQL Reference
  Pages: pg 208  (ALTER TABLESPACE)
         pg 210  (ALTER TABLESPACE)
         pg 266  (CREATE TABLESPACE)
  Change Description:
  
   For the description of PRIQTY on pg 208, add this paragraph
   before the last paragraph:
     At least one of the volumes of the identified storage
     group must have enough available space for the primary
     quantity.  Otherwise, the primary space allocation will
     fail.
  
   Under the Notes section on page 210, add a second sentence
   to the last paragraph:
     next time you use the REORG, RECOVER, or LOAD REPLACE
   | utility on the table space or partition.  If there is
   | not enough storage to satisfy the primary space
   | allocation, a REORG might fail.  If you change the
     primary space allocation parameters or erase rule, you
     can have the changes take effect earlier if you move
     the data before you start the table space or partition.
  
   For the description of PRIQTY on pg 266, add this paragraph
   before the Syntax Note.
     At least one of the volumes of the identified storage
     group must have enough available space for the primary
     quantity.  Otherwise, the primary space allocation will
     fail.
  ============================================================
  Version 3 Book Title:  SQL Reference
  Pages:  274
  Change Description:
  
  Modify the first sentence of the third paragraph under
  WITH CHECK OPTION to read:
  
        WITH CHECK OPTION must not be specified if the view
        is read-only or its search condition includes a
   |    subquery, or the search condition of an underlying
   |    view includes a subquery.
  ============================================================
  Version 3 Book Title: SQL Reference
  Pages: 278
  Change Description:
  
  Change the sixth paragraph from:
   WITH HOLD is ignored in CICS pseudo-conversational programs
   and IMS message driven programs (MPP, IFP, and
   message-driven BMP).
  
  to:
   WITH HOLD is ignored in IMS message driven programs
   (MPP, IFP, and message-driven BMP).  WITH HOLD maintains
   the cursor position in a CICS pseudo-conversational
   program until the end-of-task (EOT).
  ================================================================
  Version 3 Book Title: SQL Reference
  Pages: 297
  Please add a usage note for DROP TABLESPACE as follows:
  
    Deleting SYSLGRNG records for dropped table spaces:  After
    dropping a table space, you cannot delete the associated
    SYSLGRNG records.  If you want to remove the records, you
    must QUISCE the table space, and then run the MODIFY
    RECOVERY utility BEFORE dropping the table space.
    Warning: if you delete the SYSLGRNG records and drop
    the table space, you cannot reclaim the table space.
  ================================================================
  Version 3 Book Title: SQL Reference
  Pages: 298
  Change Description:
  
  Add the following example:
  
  Example 5:  Drop the package DSN8CC0 with the version
  identifier "1994-07-14-09.56.30.196952".  When a version
  identifier is generated by the VERSION(AUTO) precompiler
  option, delimit the version identifier.
  
  DROP PACKAGE DSN8CC23.DSN8CC0 VERSION
  "1994-07-14-09.56.30.196952"
  ================================================================
  Book Title: SQL Reference
  Version: 3.1
  Pages: 430, 431, 432, 455, 456, 457, 459, 462
  Change Description:
  In Appendix D, which describes the DB2 catalog tables,
  delete the phrase "multiplied by 100" in the descriptions
  for the following columns:
   Page          Column Name      Catalog Tables
   -----------   -----------      --------------------------
   Pg 430, 432   CLUSTERRATIO     SYSINDEXES, SYSINDEXSTAT
   Pg 431, 455   PCTFREE          SYSINDEXPART, SYSTABLEPART
   Pg 455        PERACTIVE        SYSTABLEPART
   Pg 455        PERCDROP         SYSTABLEPART
   Pg 456        PAGESAVE         SYSTABLEPART
   Pg 457, 462   PCTPAGES         SYSTABLES, SYSTABSTATS
   Pg 459, 462   PCROWCOMP        SYSTABLES, SYSTABSTATS
  ===============================================================
  Version 3 Book Title: SQL Reference
  Pages: 434
  Change Description:
  
  Modify the description of CREATOR:
  
  Authorization ID of the creator of the package version.
  ================================================================
  Appendix D. V3 SQL Reference
  SYSIBM.SYSTABLEPART field PAGESAVE has been modified to add:
  Percentage of pages saved in the table space or
  partition as a result of using data compression or
  other compression routines......
  The value is 0 if there are no savings from using data
  compression or other compression routines, or
  if statistics have not been gathered.  The value
  can be negative, if for example, data compression
  or other compression routines cause an increase
  in the number of pages in the data set.
  ================================================================
  

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

• close for INTERNET viewing
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels