|Applies To||RSA Product Set: Identity Governance & Lifecycle|
RSA Version/Condition: 7.0.x, 7.1.x
|Issue||This article provides the configuration information required to call a stored procedure from the AFX Generic DB Connector.|
|Resolution||Stored procedures may be called to execute any of the AFX generic database connector capabilities such as CreateAccount, DeleteAccount, etc. The format of the Stored Procedure call is:|
The Call command is universal across all databases and AFX database connectors, both the AFX generic database connector and the AFX database-specific connectors.
NOTE: The AFX database-specific connectors have been enhanced to allow the use of the Execute command to call stored procedures. However, to execute a stored procedure from the AFX generic database connector, the Call command must be used.
The following table lists the parameters on the CreateAccount screen:
The SQL command to CreateAccount is:
Instead of using a SQL command, a stored procedure may be used. The syntax for calling a stored procedure to execute a SQL command is:
sp_CreateAccount is a stored procedure name and the parameters are separated by a comma () and enclosed inside the brackets.
An example of a stored procedure for creating an account on SQL Server is shown below: