Using DNI_DI_OPEN

To open a connection to the data integrity framework, issue the following SQL CALL statement:
Read syntax diagramSkip visual syntax diagramCALL schema.DNI_DI_OPEN (schema,returnCode)

Input parameters

Table 1. DNI_DI_OPEN input parameters
Parameter Name SQL Data Type Description
schema VARCHAR(254) Database schema of your FTM SWIFT environment.

Output information

Table 2. DNI_DI_OPEN output parameters
Parameter Name SQL Data Type Description
returnCode VARCHAR(20)
OK
The call completed successfully.
Table 3. SQL completion information
Parameter Name Description
SQLSTATE
00000
DNI_DI_OPEN completed successfully.
990O5
An error occurred when retrieving the data integrity password. Check the reason code for additional information:
1
Vault does not exist or cannot be accessed by the user ID that is associated with the address space of the Java WLM application environment.
2
Incorrect passphrase for vault.
3
Incorrect generation value.
4
Exception in crypto operation.
xxxxx
Other SQLSTATE. Check the Db2® description.
SQL message The message that contains additional information about the SQL state. It is returned only in case of an SQL error.