SSP Paths and Connection

Components are assigned to stored procedures using assignment files. All stored procedure components which have the default Stored Procedure Component implementation type are mapped to the $SSP path.

$SSP can point to a separate or shared DBMS connection. You must explicitly map the $SSP path, because it has no default mapping. Stored procedure components can also be mapped to an explicit DBMS connection, via the [SERVICES_EXEC] section. Stored procedure components can also be located on a remote DBMS, and accessed via a Uniface Server.

If a component has multiple implementations (including a stored procedure component which is not set to default), explicitly assigning the component to a DBMS connection in the [SERVICES_EXEC] section results in Uniface using the Stored Procedure Component implementation.

Uniface ensures that a DBMS connection is established before a stored procedure component operation executes the activate ProcScript statement.

[PATHS]
$ORA1 =ORA:|scott|tiger
$ORA2 =ORA:|system|manager
$SSP =$ORA2
[SERVICES_EXEC]
component_1 = $ORA1:component_1