Versions of SQL/MX software components

Each software component and persistent entity has a version identifier that identifies its software release and that can be interpreted by other releases. Software version components include the system software version (MXV).

Versioned persistent entities, which persist over time and across releases, include:

• Schemas that contain SQL/MX database objects.

• Database objects, such as tables, views, and indexes.

• Compiled modules.

SQL/MX uses version identifiers to determine if a software component or persistent entity is compatible with the release. Before using a software component or operating on a persistent entity, SQL/MX checks the version identifier of the software component or persistent entity. If the version identifier is compatible with the release, SQL/MX successfully proceeds with the operation. If the version identifier is incompatible with the release, SQL/MX fails the operation and returns a versioning error indicating an incompatibility.

The use of version identifiers enables interoperability between compatible versions and prevents interoperability between incompatible versions. For more information, see:

• Software requirements
• Starting TMF
• SQL/MX Release Information