Generating a Database Flow Service from an SQL Statement

Application Integration (On-Premises) : Accessing databases : Accessing Databases with Services : Creating Database Flow Services : 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.

Contact Support | Community | Feedback