pricedgp
10 years agoContributor
Using a property to hold a query, to be used in JDBC request steps
I would like to store my queries in one place, and insert a reference to them via a property or some other means within a JDBC request. This will allow me to create a central repository of good working queries, and will make it easy to update them when there are changes.
I should note that these are relatively long queries, with multiple nesting levels, so it's not just a matter of putting "select * from xxx" into a property. Also, whereever they're stored, I'd like them to be formatted so that I can read them, with line breaks and indents, etc.
Right now I just have a text file that I copy and paste into the JDBC request window -- it works, but -- ugh!
Any ideas on how to handle this?
Thanks.