ttVersion

The ttVersion built-in procedure returns the five parts of the TimesTen release number.

Required Privilege

This procedure requires no privilege.

Related Views

This procedure has this related view.

SYS.V$VERSION

Syntax

ttVersion()

Parameters

ttVersion has no parameters.

Result Set

ttVersion returns the result set:

Column Type Description

major

TT_INTEGER NOT NULL

The first part of the five-part release number (22 for release 26.1.1.1.0), indicating the last two digits of the year of the major release.

A change in major1 indicates major infrastructure and functionality changes.

minor

TT_INTEGER NOT NULL

The second part of the five-part release number (1 for release 26.1.1.1.0).

A change in only major2 indicates a version with new functionality and possibly some infrastructure changes.

Releases with the same major1.major2 are patch-compatible. Data can be unloaded from a database from one release and loaded into a database from the other without the migration process.

patchset

TT_INTEGER NOT NULL

The third part of the five-part release number (1 for release 26.1.1.1.0).

A change in only patchset indicates a release that contains bug fixes and possibly some feature enhancements.

patch

TT_INTEGER NOT NULL

The fourth part of the five-part release number (9 for release 26.1.1.1.0).

A change in only patch indicates a release with only critical bug fixes.

reserved

TT_INTEGER NOT NULL

The fifth part of the five-part release number (0 for release 26.1.1.1.0). Reserved for future use.

Examples

Return for release 26.1.1.1.0:

Command>  call ttVersion();
< 22, 1, 1, 9, 0 >
1 row found.