Integration Server 10.7 | WmDB User’s Guide | Accessing Databases with Services | Creating Database Flow Services | Generating a Database Flow Service from an SQL Statement | Steps for Generating a Flow Service from an SQL Statement
 
Steps for Generating a Flow Service from an SQL Statement
Use the following procedure to generate a flow service from an SQL statement.
*To generate a flow service from an SQL statement
1. Open the Integration Server Administrator if it is not already open.
2. Go to Adapters > WmDB > Service Generation.
3. In the Source alias list, select the database you want the service to access.
4. In the Package list, select the package in which you want the service to reside.
5. In the Folder field, type the name of the folder in which you want to save the service.
6. In the Service field, type the name you want to assign to the service.
7. In the Execute ACL list, select the ACL group to which you want to limit access to the service. Only the users who are members of the groups in the selected ACL will be able to invoke the service.
8. If you want to overwrite any existing services with the same name as the new service, next to Overwrite Existing, select the Generated objects overwrite existing objects check box.
9. Click Generate from SQL. The server displays the Edit SQL Statement page.
10. In the Enter SQL statement section of the page, enter the SQL statement you want the service to execute. You can specify a statement that is dynamic (that is, contains question marks or template tags) or static.
11. If you included template tags in the SQL statement, select the Process webMethods template tags in this SQL statement check box.
12. Click Evaluate. The server displays the Input Binding Generation page.
If you specified question marks (?) in the SQL statement for input values, the server displays a Bind parameters section of the page. Under Bind parameters, one Parameter # field exists for each question mark you specified in the SQL statement. The first question mark corresponds to Parameter 0, the second to Parameter 1, and so forth. Use this section of the page to indicate additional information about the input parameters that a user will supply in place of the question marks.
13. For each Parameter # field under Bind parameters, specify the following information:
For this field...
Specify or select...
name
The name that you want the service to use for the input parameter.
type
The data type of the input parameter.
14. Click Generate.