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;

SELECT
*
FROM
DIM_TBL_DATE
WHERE
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.

variable

Hope you find this useful!

– Vinit Joshi

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s