How do I specify the input fields in the Custom SQL for JDBC adapter? If my input field is “ServiceNo”, do I reference it as “${ServiceNo}” in my SQL? What about my output fields? If the output field is “Name”, how do I link it to my select column dept in my SQL?
Thanks for any help!
The JDBC adatper does not use the ${} notation that is typical of earlier adapters. You use the ‘?’ in your sql. For example
SELECT FILE_ID, FILE_NAME FROM FILE_TABLE WHERE FILE_TYPE = ? AND FILE_SOURCE = ?
Then create two input fields, the first one for FILE_TYPE, the second on is for FILE_SOURCE. The order of them in the SQL tab is important and must match the order with which they are in the where clause!
Output fields are much the same, define them in the SQL tab in order that they are returned. For example, FILE_ID and then FILE_NAME. Thus I would recommend against an SQL statement that looked like this!!!
SELECT * FROM FILE_TABLE WHERE FILE_TYPE = ? AND FILE_SOURCE = ?
Hi. Thanks for the reply! Funny, I asked support and replied using ur reply! 