Interoperability of SQL/MX releases
SQL/MX R3.5 supports a one-way interoperability between systems in an EXPAND network and supports SQL access from systems running SQL/MX R3.3 or SQL/MX R3.4.
It means that an application on the R3.3 or R3.4 system can use SQL/MX statements to access database objects and metadata that reside fully or partially on a SQL/MX database on a R3.5 system.
However, since this is a lower to higher version one-way interoperability, a system running SQL/MX R3.5 will not be able to do SQL access to a system running SQL/MX R3.4 or older version in an EXPAND network. For more information, see Interoperability of SQL/MX releases.
Related schemas must have identical schema version, that is, a trigger in a v3500 schema cannot reference a sequence generator in a v3400 schema.
The one-way interoperability does not support remote ESPs. An R3.3 or R3.4 system might generate a query plan that would start ESPs on a R3.5 system, however the R3.5 ESPs rejects requests from the R3.3 or R3.4 master executor.
To ensure interoperability when your network includes earlier versions of SQL/MX, you must upgrade all of them to 3.5.
| To Release (Horizontal axis) |
3.3 |
3.4 | 3.5 |
| From Release (Vertical axis) | |||
| 3.3 |
Yes |
Yes (with restrictions)1 | Yes (with restrictions)1 |
| 3.4 | No |
Yes |
Yes (with restrictions)1 |
| 3.5 | No |
No |
Yes |