You can translate the question and the replies:

Stored Procedure with out parameter from mainframe

i have a stored procedure on mainframe. which has one OUT parameter. what is the way to create a base view from query to call the stored procedure as any value i give to the out parameter is rejected. i tried "?", gave a variable and tried to set its value to "?". expectation is a global variable. how to resolve this?
user
15-09-2021 23:13:02 -0400
code

1 Answer

Hi, To create a base view from calling the stored procedure in the mainframe (DB2), there are two ways to achieve this. - Create the base view graphically using the administration tool. Please refer to this community article on [JDBC Sources — Virtual DataPort Administration Guide](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources#importing-stored-procedures-from-ibm-db2) for details. - Create the base view from the VQL inside the administration tool. Go to your DB2 connection, and choose tab “Create base view” Choose “Create from query” In my example I have a DB2 stored procedure with one OUT parameter so I used the following syntax and it worked. `CALL schemaName.storedProcedureName(?)` Click OK to save your new view If you still need help and you have a valid support user account, please open a new support case at the [Denodo Support site](https://support.denodo.com/) so that the support team can assist you. Hope this helps!
Denodo Team
22-09-2021 00:48:13 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here