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

Document the new SYSCS_UTIL.SYSCS_PEEK_AT_IDENTITY function

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.11.1.1
    • 10.11.1.1
    • Documentation
    • None
    • 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. rrefsyscspeekidentity.html
          5 kB
          Camilla Haase
        2. rrefsyscspeekidentity.html
          5 kB
          Camilla Haase
        3. rrefsistabs22441.html
          8 kB
          Camilla Haase
        4. DERBY-6580-3.diff
          0.9 kB
          Camilla Haase
        5. DERBY-6580-2.diff
          4 kB
          Camilla Haase
        6. DERBY-6580.stat
          0.1 kB
          Camilla Haase
        7. DERBY-6580.diff
          4 kB
          Camilla Haase

        Issue Links

          relates to

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-6542 Improve the concurrency of identity columns by using SYS.SYSSEQUENCES

          • Major - Major loss of function.
          • Closed

          Activity

            People

              chaase3 Camilla Haase
              rhillegas Richard N. Hillegas
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: