A GED macro can appear in any of the following:
-
EXECUTE criteria expressions
-
<SQL> elements
-
<FILTER> elements
The macro appears as a string between dollar signs, such as $P.PIPELINE-REFERENCE$. When the element is evaluated, the macro is substituted with a value taken from a property of the POD file being processed. The sample <SQL> statement shown below contains the macro $P.PIPELINE-REFERENCE$.
<SQL>
SELECT * FROM PIPELINES WHERE [LINE-REF] = '$P.PIPELINE-REFERENCE$'
</SQL>
In this example, when the <SQL> element is evaluated at a pipeline, the $P.PIPELINE-REFERENCE$ string is replaced with the PIPELINE-REFERENCE property of the current pipeline. If this is SG-1, the SQL statement becomes
SELECT * FROM PIPELINES WHERE [LINE-REF] = 'SG-1'