I’ve been using Exasols database for a while but wasn’t aware that you can pass variables in the scripts I’m writing. Although I usually write are lua scripts it’s useful to have the ability to include variables in complex queries.
Below is an example of passing variables in queries;
define intDateid = 20161115;
DateID = &intDateid;
If you do forget to assign a value (initialise) the variable you’ll have a handy pop up box that appears asking you to enter the value.
Hope you find this useful!
– Vinit Joshi