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?