Mark Host Variables
Use the Mark Host Variables tool to add a $ (dollar sign) prefix before all program variables used in static SQL statements.
The $
prefix forces compilation errors when a variable is not defined.
It also makes the code more readable.
From Code Editor
With the file open in the Code Editor, select
.From the File Browser or Project Manager
From the File Browser or Projects view:
- Select one or more files or groups.
- Right-click and select Mark Host Variables.