Forum Discussion

pricedgp's avatar
pricedgp
Contributor
10 years ago

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.

No RepliesBe the first to reply