Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-6580

Document the new SYSCS_UTIL.SYSCS_PEEK_AT_IDENTITY function

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.11.1.1
    • Fix Version/s: 10.11.1.1
    • Component/s: Documentation
    • Labels:
      None
    • Urgency:
      Blocker

      Description

      The work on DERBY-6542 has introduced a new system function. This function is used to check the next value which will be issued for an identity column. It is similar to the existing SYSCS_UTIL.SYSCS_PEEK_AT_SEQUENCE function for sequences. We need to document this new function:

      BIGINT SYSCS_UTIL.SYSCS_PEEK_AT_IDENTITY
      ( IN SCHEMANAME VARCHAR(128), IN TABLENAME VARCHAR(128) )

      All users have permission to run this function.

        Attachments

        1. DERBY-6580-3.diff
          0.9 kB
          Kim Haase
        2. rrefsistabs22441.html
          8 kB
          Kim Haase
        3. rrefsyscspeekidentity.html
          5 kB
          Kim Haase
        4. DERBY-6580-2.diff
          4 kB
          Kim Haase
        5. rrefsyscspeekidentity.html
          5 kB
          Kim Haase
        6. DERBY-6580.stat
          0.1 kB
          Kim Haase
        7. DERBY-6580.diff
          4 kB
          Kim Haase

          Issue Links

            Activity

              People

              • Assignee:
                chaase3 Kim Haase
                Reporter:
                rhillegas Rick Hillegas
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: