User-defined version numbers can be assigned to to certain objects in an ElevateDB configuration or database using the VERSION clause. These version numbers are specified as a DECIMAL number in the form of:

<MajorVersion>.<MinorVersion>

The major version may contain up to 19 digits, and the minor version may contain up to 4 digits.

The following DDL statements allow you to define version numbers for the associated object being created or altered:

CREATE JOB
ALTER JOB

CREATE TABLE
ALTER TABLE

CREATE VIEW
ALTER VIEW

CREATE FUNCTION
ALTER FUNCTION

CREATE PROCEDURE
ALTER PROCEDURE