Skip navigation
CA Technologies
Products
Solutions
Education & Training
Services & Support
Partners
Company
Home
Communities
Browse
Content
People
Help
Getting Started
Customer Care
Training
Events
My Account
Log in
0
Search
Search
Search
Cancel
Error: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page.
All Places
>
CA Automic Community
>
CA Automic Workload Automation
>
Questions
Log in
to create and rate content, and to follow, bookmark, and share content with other members.
Answered
Assumed Answered
how to create dynamic variables
Question asked by
shanikushwaha606112
on Apr 6, 2018
Latest reply
on Apr 6, 2018 by Andrew_Garland_7890
Like
•
Show 0 Likes
0
Comment
•
1
how to define a query on the DB using a VARA SQL object such that whenever it is referenced we get the Business Date.
Outcomes
This content has been marked as final.
Show 1 comment
1 Reply
Name
Email Address
Website Address
Name
(Required)
Email Address
(Required, will not be published)
Website Address
Andrew_Garland_7890
Apr 6, 2018 5:30 PM
Mark Correct
Correct Answer
Hi Shani!
Check out our documentation on the VARA.SEC_SQLI variable. You can have a SQL query where the result will be put into this VARA on execution!
https://docs.automic.com/documentation/webhelp/english/AWA/12.1/DOCU/12.1/AWA%20Guides/help.htm#AWA/Objects/varaSEC_SQLI.htm%3FTocPath%3DUser%2520Guide%7CProcess%2520Assembly%2520Perspective%7CDefining%2520the%2520Object-Specific%2520Pages%7CVariables%2520(VARA
)%7CVariables%2520Types%7C_____5
Let me know if you have additional questions!
Check out our documentation on the VARA.SEC_SQLI variable. You can have a SQL query where the result will be put into this VARA on execution!
https://docs.automic.com/documentation/webhelp/english/AWA/12.1/DOCU/12.1/AWA%20Guides/help.htm#AWA/Objects/varaSEC_SQLI.htm%3FTocPath%3DUser%2520Guide%7CProcess%2520Assembly%2520Perspective%7CDefining%2520the%2520Object-Specific%2520Pages%7CVariables%2520(VARA)%7CVariables%2520Types%7C_____5
Let me know if you have additional questions!