Question

1
Replies
905
Views
Keviv_Singh Member since 2017 7 posts
Accenture
Posted: 3 years ago
Last activity: 3 years 3 months ago
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