For the 1st time i am using MACROS. I want to set the macro dynamically while reading data.

Somnath_Das

<宏/ >

<背景高度= " 232 "的位置="//Samples/Tutorials/Basics/01/tutorial1" width="1502" x="26" y="47"/>

yyhuang

Hi@Somnath_Das,

You can parameterizing SQL query for loading data dynamically from DB.

https://community.www.turtlecreekpls.com/discussion/32966/how-to-use-macros
https://community.www.turtlecreekpls.com/discussion/31861/parameterizing-sql-query/p1

Some other discussions can be found if you do a little bit search
https://community.www.turtlecreekpls.com/discussion/57121/read-database-query-sql-in
https://community.www.turtlecreekpls.com/discussion/57210/using-macro-inside-sql-queries

HTH!

Cheers,