vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/ddm/umn/ddm_03_0036.html
Hasko, Vladimir a5cc543164 reverting ddm umn to state before last commit in #613 
Reviewed-by: Wagner, Fabian <fabian.wagner@t-systems.com>
Co-authored-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-committed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
2024-01-17 13:06:49 +00:00

3.2 KiB
Raw Permalink Blame History

Using NEXTVAL or CURRVAL to Query Global Sequence Numbers

  • NEXTVAL returns the next sequence number, and CURRVAL returns the current sequence number. nextval(n) returns n unique sequence numbers.
  • nextval(n) can be used only in select sequence.nextval(n) and does not support cross-schema operations.
  • currval(n) is not supported.

Procedure

  1. Log in to the required DDM instance using a client.
  2. Open the required schema.
  3. Run the following command to create a global sequence:

    create sequence seq_test;

  4. Run the following command to obtain the next sequence number:

    select seq_test.nextval;

  5. Run the following command to obtain the current sequence number:

    select seq_test.currval;

  6. Run the following command to obtain sequence numbers in batches:

    select seq_test.nextval(n);

    • Cross-schema operations are not supported when sequence numbers are obtained in batches.
    • If no global sequence is used, CURRVAL returns 0.

Parent topic: Global Sequence