sequence

Description	Syntax	Parameters	Returns	Example
Used to return the next value from a database sequence.	`sequence(dbSequenceName)`	dbSequenceName: name of the database sequence.	Next sequence value converted to string.	`sequence('MQ_SEQUENCE_1')` `sequence(mysequence)` `concat('HS=' lpad(sequence('MQ_SEQUENCE_1'), 9, '0'), '-JAL')`

Description

Syntax

Parameters

Returns

Example

Used to return the next value from a database sequence.

sequence(dbSequenceName)

dbSequenceName: name of the database sequence.

Next sequence value converted to string.

sequence('MQ_SEQUENCE_1')

sequence(mysequence)

concat('HS=' lpad(sequence('MQ_SEQUENCE_1'), 9, '0'), '-JAL')