Hybrid Integration 10.1 | Integrating On-Premises Applications | Document Conventions | 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.
Copyright © 2015- 2017 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.