Sequence

Functionality for manipulating the database sequence objects.

Overview

• Module: db/sequence
• Definition: https://github.com/eclipse/dirigible/issues/124
• Source: /db/sequence.js
• Status: stable
• Group: core

Basic Usage

ECMA6CommonJS

import { sequence } from "@dirigible/db";
import { response } from "@dirigible/http";

let value = sequence.nextval("MYSEQUENCE");

response.println(value.toString());
response.flush();
response.close();

const sequence = require("db/sequence");
const response = require("http/response");

let value = sequence.nextval("MYSEQUENCE");

response.println(value.toString());
response.flush();
response.close();

Functions

---

Function	Description	Returns
nextval(name, databaseType?, datasourceName?)	Increment the sequence with the given name and returns the value. Creates the sequence implicitly if it deos not exist.	integer
create(name, databaseType?, datasourceName?)	Creates the sequence by the given name.	-
drop(name, databaseType?, datasourceName?)	Remove the sequence by the given name.	-