I need some help in scripting. I have 2 scripts. One script is scheduling the query to run and another script views results. In order to view the result of the query, i need to provide query name, query number (which is unique value and i can parameterize it with no problem) query sequence number (which is a dynamic value in yyyymmddhhmmss format that is generated by the application from the server when the query is scheduled to run).
I used web_reg_save_param() function to save this number, however it can be used only in the same script. can someone point me to the function that will help to save these parameters and I will be able to use them in another script.
You have stumbled upon the very reason for the existence of the VTS, or the Virtual Table Server. Download this highly useful item from the Mercury Support site and you should be able to use it to share information on a dynamic basis between scripts.