Maintaining multiple query templates

[Former Member]

Hi,

We created a generic query templates for SQL Query and this query template does not have any query specified inside the Query Template. The SQL query is assigned inside the xMII transaction. Instead of creating and maintaing multiple query templates for various SQL queries, we created this single query template and we use this query template by assigning the SQL query in xMII Transaction at runtime. Will there be any issues around this approach?

Thanks,

Sara

[Former Member]

This approach limits the reusability/maintainability of your queries. If any query is to be used more than once (e.g. in a UI application or more than one BLS transaction), it makes sense to put it in its own query template. Also, if you want to take advantage of xMII's caching infrastructure, you should also do this.

There's also a small possibility in the future (I'm no longer with SAP, but just suggesting it is a possible outcome) that the SQL will not be dynamically assignable to avoid SQL code injection security issue(s).

[Former Member]

Thanks, Rick. I will keep this in mind when we develop future code.

-Sara