Sequence
Functionality for manipulating the database sequence objects.
- Module:
db/v4/sequence
- Alias:
db/sequence
- Definition: https://github.com/eclipse/dirigible/issues/124
- Source: /db/v4/sequence.js
- Facade: DatabaseFacade
- Status:
stable
Basic Usage
var sequence = require("db/v4/sequence");
var response = require("http/v4/response");
var value = sequence.nextval("MYSEQUENCE");
response.println(value);
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. | - |