SQL_INITIALIZE_SEQUENCE¶

Applies to: ORAFlex PGFlex

This command is used to initialize all auto increment columns, or sequences in Oracle, of the specified table to be the highest number plus one. This is useful when inserting a large amount of records in the table and the sequence is not being updated because the auto incremented column is being manually filled.

Syntax

SQL_INITIALIZE_SEQUENCE of {FILE.File_Number}

Parameter

Description

FileNumber

The file number