Question

2
Replies
1756
Views
Keviv_Singh Member since 2017 7 posts
Accenture
Posted: July 11, 2017
Last activity: August 24, 2017
Closed
Solved

Pass SQL Scripts dynamically to CONNECT SQL

Hi All,

The requirement is to set the complete SQL script and pass it to CONNECT SQL for executing them.

For instance:

1) Setting the SQL Query to a property on a page like this PageName.SQLQuery ="SELECT * FROM pr_operator;"

2) In the CONNECT SQL rule specifiy the SQL Query in this representation {PageName.SQLQuery}

Well this is not working. But anyone has any idea how to achieve this type of requirement. or do we need ot write java step to acheive this?

System Administration
Moderation Team has archived post
Share this page LinkedIn