Descriptions of the Files Involved - Teradata SQL Assistant

Teradata® SQL Assistant for Windows User Guide

Product
Teradata SQL Assistant
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2020-01-03
dita:mapPath
gfk1537201040714.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2430
Product Category
Teradata Tools and Utilities
teradata.lng Defines the language elements used by the parser to perform syntax highlighting, brace matching, and outlining.
teradataNF.mbr Contains a list of non-aggregate functions, together with their function prototypes and descriptions. It is used to display Quick Info when you hover over a function name and to add the functions to the drop-down lists in Select, Where, and Group/Order By clauses.
teradataAF.mbr Contains a list of aggregate functions, together with their function prototypes and descriptions. It is used to display Quick Info when you hover over a function name and to add the functions to the drop-down lists in Select, Having and Qualify clauses.
teradataTF.mbr Contains a list of table functions, together with their function prototypes and descriptions. It is used to display Quick Info when you hover over a function name and to add the functions to the drop-down list after you type ‘Table (’ in a From clause.
teradataTO.mbr Contains a list of table operators, together with their function prototypes and descriptions. It is used to display Quick Info when you hover over a function name and to add the functions to the drop-down list in a From clause. It also supports the Quick Paste function that inserts the function parameters for the associated function.
teradata.syn Contains syntax examples for each supported SQL statement. This information is used in the Favorites window and also in the Query Builder.
explain.lng Defines the language elements used to perform syntax highlighting of Teradata Explain output. If new join types or actions are added then those new words or phrases may need to be added here in order for them to be highlighted in the output.
format.lng Defines the language elements used when formatting a query. It is unlikely that this file will need to be modified but new uses of the words From, And, End or Case may have an impact on how formatting should be performed.