SQL Language Guide : A. Terminal Monitor : Terminal Monitor Macros : Use of Quotes
 
Share this page                  
Use of Quotes
Sometimes text strings must be passed through the macro processor without being processed. In such cases single quotes must surround the literal text (for example, to pass the word sel through without converting it to select type 'sel').
If you want to enter more than one word for substitution into a macro parameter, you must quote the parameter.
For example, if you define a macro:
{define; sel $1 $2; SELECT $1 FROM part WHERE $2}\eval
Invoke it with the query:
sel ‘p.name, p.qoh * p.stk AS weight’ ‘p.cn=10’\l
The query is evaluated as:
SELECT p.name, p.qoh * p.stk AS weight FROM part WHERE p.cn=10