Integration Server 10.11 | WmDB User’s Guide | Accessing Databases with Services | Creating Database Flow Services | Generating a Database Flow Service from an SQL Statement | Specifying a Dynamic SQL Statement | Using Question Marks (?) in SQL Statements
 
Using Question Marks (?) in SQL Statements
Use a question mark in place of a single parameter that the service expects as input. When you test the service in Integration Server Administrator, it recognizes the question mark and prompts you for the required input value.
Example 1
To select all rows from the Names table that match the values specified for the Last_Name column, specify the following SQL statement:
select * from Names where Last_Name=?
The service expects an input value to use to match rows in the Last_Name column.
Example 2
To add a new row to the Addresses table and populate it with specified values, specify the following SQL statement:
insert into Addresses (name,street,city,state,zip)
values (?,?,?,?,?)
The service expects input values to use to populate the new row.