parameter query
1 Topic
How do you do a parameter query when not using Microsoft Query?
I have a workbook that uses the ODBC interface part of Microsoft Query to query a DB2 database. The workbook actually queries over 20 different tables. I have one cell in the workbook that is the main search parameter for all the queries (for example WHERE CUST_NUM = ?). I have the queries to always use this value and automatically execute when the value changes. This way I change one cell and the 20 queries all execute. I'm trying to move this process from using ODBC under Micrsoft Query to use the JDBC interface under the "Get Data / From Database / From IBM DB2 Database" path. I can't find how to do this same process and would appreciate any guidance.Solved11KViews0likes9Comments