Beginning in r11, there is support for multiple Multi-User Facilities.
With SQL programs, one compile unit must run against one CA Datacom Datadictionary, have one plan, and execute against the Multi-User Facility containing both. An SQL program may execute with a multiple Multi-User Facilities User Requirements Table, but all SQL requests execute using the first Multi-User Facility in the connection list. In this case it would have the ability to specify a SIDNAME= and not be forced to use DBSIDPR. An SQL program could be split into multiple modules and each could connect to a different Multi-User Facility, but no joining of tables or constraints outside of one Multi-User Facility are allowed.
SQL detects RRS User Requirements Tables, issues a return code, and does not process COMMIT or ROLLBACK requests. The multiple Multi-User Facility interface detects the specific errors and generates RRS COMMIT or ROLLBACK calls. If RRS is successful, the SQLCODE and related error fields are set to zero/blank. If RRS provides a return code on the SRRCMIT/SRRBACK, the SQL error is changed to:
RETURN CODE <94(121)> ON COMMAND <COMIT> R15 <?>
where ? is the R15 error value from RRS.
Note: For more information on multiple Multi-User Facilities, see the CA Datacom/DB Database and System Administration Guide.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|