IBM Support

II12330: CHANGES TO DB2 SQL REFERENCE SC26-3270-00 THAT DID NOT MAKE V4.1 GA PUBS. CONTINUATION OF II09159

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • INTRAN

Error description

  • 5740xyr00 DB2 R410 V4    continuation of II09159
    This APAR documents changes to the DB2 SQL Reference
    SC26327000 which did not make Version 4.1 GA pubs.
    ================================================================
    Version 4 Book Title: SQL Reference
    Pages: 389 and 400
    
    Change Description:
    For the REVOKE statement, revise the last paragraph of the
    "Cascade Revoke" usage note, which appears at the bottom
    of page 389, to:
    
    |   Revoking a SELECT privilege that was exercised to
    |   create a view causes the view to be dropped, unless
    |   the owner of the view was directly granted the SELECT
    |   privilege from another source before the view was
        created. Revoking a SYSADM privilege that was required
        to create a view causes the view to be dropped. For
        details on when SYSADM authority is required to
        create a view, see Authorization in "CREATE VIEW".
    
    For the REVOKE (table or view) statement, revise the
    description of SELECT, which appears at the bottom of
    page 400, to:
    
        SELECT
        Revokes the privilege to use the SELECT statement.
    |   A view is dropped when the SELECT privilege that was
    |   used to create it is revoked, unless the owner of
    |   the view was directly granted the SELECT privilege
    |   from another source before the view was created.
    ============================================================
    

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    II12330

  • Reported component name

    PB LIB INFO ITE

  • Reported component ID

    INFOPBLIB

  • Reported release

    001

  • Status

    INTRAN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2000-03-24

  • Closed date

  • Last modified date

    2000-03-24

  • 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

[{"Business Unit":{"code":null,"label":null},"Product":{"code":"SG19O","label":"APARs - MVS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"001","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"001","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
24 March 2000