1 Open a text editor such as Notepad or Microsoft Word.
2 Create a header line at the start of the file.
This header can be any word(s). In the examples shown in the figures below, it is Reports.
This header displays in the Query Builder dialog box as the text on the third line in the drop-down list.
3 Ensure the remaining lines in this file contain pairs of strings, each enclosed in double quotes and separated by a comma.
The first string is the statement type, the second is the statement itself.
4 Select Save As and name the file custom.syn.
5 Put this file in the bin subdirectory of the Teradata Administrator installation directory.
By default, the location is: drive:\Program Files\Teradata\Client\15.10\bin.
The following is an example of the custom.syn file:
The following is an example of how those statements appear when using Query Builder:
