The following are available for variable substitution in the run and run-now macros:
Replacement
- Replacement occurs for variables found within the body of the macro just prior to rendering the body. It cannot replace variables produced by the rendering process like data produced by downstream macros.
- Variable in sql macro body worksÂ
select * from test_address1 where last ='Jones' Variable in sql script coming from file will not work.
The file contains same query:
select * from test_address1 where last ='Jones'
select * from test_address1 where last ='$page_title'
