You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Rick Hillegas (JIRA)" <ji...@apache.org> on 2014/09/03 13:55:51 UTC
[jira] [Closed] (DERBY-6580) Document the new
SYSCS_UTIL.SYSCS_PEEK_AT_IDENTITY function
[ https://issues.apache.org/jira/browse/DERBY-6580?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas closed DERBY-6580.
--------------------------------
> Document the new SYSCS_UTIL.SYSCS_PEEK_AT_IDENTITY function
> -----------------------------------------------------------
>
> Key: DERBY-6580
> URL: https://issues.apache.org/jira/browse/DERBY-6580
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.11.1.1
> Reporter: Rick Hillegas
> Assignee: Kim Haase
> Fix For: 10.11.1.1
>
> Attachments: DERBY-6580-2.diff, DERBY-6580-3.diff, DERBY-6580.diff, DERBY-6580.stat, rrefsistabs22441.html, rrefsyscspeekidentity.html, rrefsyscspeekidentity.html
>
>
> 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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)