ttVersion

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

Required Privilege

This procedure requires no privilege.

Usage in TimesTen Scaleout and TimesTen Classic

This procedure is supported in TimesTen Classic.

TimesTen Scaleout applications can call this built-in procedure.

In TimesTen Scaleout, this procedure runs locally on the element from which it is called.

Related Views

This procedure has these related views.

Syntax

ttVersion()

Parameters

ttVersion has no parameters.

Result Set

ttVersion returns the result set:

Column	Type	Description
`major1`	`TT_INTEGER NOT NULL`	The first part of the five-part release number (22 for release 22.1.1.21.0), indicating the last two digits of the year of the major release. A change in `major1` indicates major infrastructure and functionality changes.
`major2`	`TT_INTEGER NOT NULL`	The second part of the five-part release number (1 for release 22.1.1.21.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 22.1.1.21.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 22.1.1.21.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 22.1.1.21.0). Reserved for future use.

Examples

Return for release 22.1.1.21.0:

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