Integration Server 10.5 | WmDB User’s Guide | Accessing Databases with Services | Creating Database Flow Services | Generating a Database Flow Service from an SQL Statement
 
Generating a Database Flow Service from an SQL Statement
 
Specifying a Dynamic SQL Statement
Steps for Generating a Flow Service from an SQL Statement
To generate a service from an SQL statement, you must select the SQL statement that you want the service to perform. You can specify a static SQL statement or a dynamic SQL statement.
Important:
The generated flow service is unable to properly call a stored procedure or return the result set or output parameters. If you want to call a stored procedure, create the service in Java or C/C++ and call the stored procedure using the pub.db:call service.