This component execute a stored procedure.
Parameters
Data Source Name: name of the ODBC source for the connexion to the database
Authentification
- Login: a login to connect to the database
- Password: the password associated to the login
Output
You have three kinds of outputs:
1.Result to table: in this case a table is created automatically with the result
When you execute this treatment you can see the result in Table Manager in the bottom of the screen.
2. Result to file: in this case a CSV file is created with the result
File Format:
- in the result file you indicate “\r\n” for a CRLF (Carriage Return Line Feed)
- if you have a lot of column in the result file you indicate the Text Delimiter
3. Result to file: in this case a XML file is created with the result
Stored procedure
allow to show a list of the procedures stored in the Data Source Name
Stored Procedure: select a stored procedure in the combo box
Stored Procedure Parameters:
- Name: indicates each parameter's name
- Type: displays each parameter's type
- Is Output:
- RETURN_VALUE: value of the RETURN instruction
- INPUT: Input parameter
- OUTPUT: Output parameter
- INPUT_OUTPUT: Input/output parameter
- Value: displays each parameter's value
- Property name: save RETURN value
