About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
DVAASUSERAPIKEY stored procedure
Last updated: Mar 17, 2025
Add the API key onto the Data Virtualization catalog table so that it can be used when personal credentials is enabled. This stored procedure is a prerequisite step needed for you to access a datasource that is enabled with personal credentials using your own API key.
Input parameters
- USER_API_KEY
- The type of this required parameter is VARCHAR(32672). The User API key generated from the IAM access.
Syntax
Use the following syntax and replace the parameter for this stored
procedure:
CALL DVSYS.SETDVAASUSERAPIKEY('<USER_API_KEY>')
Example
CALL DVSYS.SETDVAASUSERAPIKEY('0f0c50b5767b4b5ab4c3456dd8190d82')
Was the topic helpful?
0/1000