16.10 - Inserting Aster Analytical Functions - Teradata Studio

Teradata Studio Express User Guide

Teradata Studio
June 2017
User Guide
The Aster Database includes scripts for analytical function templates that you can insert into the SQL Editor.
  1. Select a connection profile that connects to an Aster Database.
  2. Click Query Development and launch the SQL Editor. The SQL Editor, Result Set Viewer, and Teradata SQL History views open.
  3. In the main toolbar, select Windows > Show View > Other The Show View dialog opens.
  4. Scroll up to General and select TemplatesView which is located at the bottom of the list. The Templates View opens below the SQL Editor. You can drag and dock the view in the left pane beside the Data Source Explorer to see the full list easily.

  5. Select a function in the Templates View and preview the script text in the Preview area below the view.
  6. Drag and drop the selected Aster function into the SQL Editor to insert it. The text for the Aster analytical function displays at the point you drop it in the SQL Editor script.
  7. Substitute your values for the template variables and execute the script.