Operands can contain the following elements, with syntax varying according to the value type and data source:
<KEYWORD>
A keyword indicating a value type. For example, a keyword indicates whether the value type of the expression is a connection or a class.
:
The colon (“:”) assigns the value type in the keyword to the expression.
\
The backslash (“\”) indicates a folder. Folders are objects combining other objects, including other folders, defining the location of those objects in a catalog. A folder cannot contain two objects of the same name and same type, but can contain two objects of the same name but different types.
The folder can be expressed by:
<folder> :: = \ | <folder> <folder_name> \
Accessing the root folder:
\
Accessing a folder:
\'folder'\
Accessing a subfolder:
\'folder'\'subfolder'\
'<NAMEx>'
Element names must be in single quotation marks. Depending on the data source, names can be connections, classes, catalogs, schema, tables, folders, or subfolders.
::
The double-colon (“::”) accesses database connections or text files. For example, to access information in a database connection called 'tbc':
connection : \'tbc'::'tbc.family'.'FAMILY'
.
The dot (“.”) accesses attributes or values contained in tables or files, such as columns.