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?
Hi Vivek,
Pls try with {ASIS:PageName.SQLQuery} and check if it works.