Forum Discussion
Use Parameters in DB2 SQL
I have an Excel Workbook where I am writing an ODBC query to select DB2 data. This query needs to vary the Year and PayPeriod so I would like to have parameters in my DB2 SQL. How do I do this. I wan...
Thank you. This worked great.
Oh, so old thread. Glad it helped.
I never worked with DB2 and don't know connector to it works with query folding or not. If the former perhaps we could do everything with M-scripts or even from UI, without native SQL scripts.
What is more optimal - it depends.