%GetNextSeqValue meta-SQL element

Syntax

%GetNextSeqValue(sequence_name)

Description

The %GetNextSeqValue meta-SQL returns the next value in the sequence and increments that value after fetching it.

Parameters

Parameter	Description
sequence_name	Specify the database sequence.

Returns

A numeric value.

Example

INSERT INTO PS_PURCHASE_ORDER (PO_NUMBER, ...) VALUES (%GetNextSeqValue(PS_PO_NUMBER_SEQ), ...)