16.10 - Inserting Aster Analytical Functions - Teradata Studio

Teradata Studio Express User Guide

prodname
Teradata Studio
vrm_release
16.10
created_date
June 2017
category
User Guide
featnum
B035-2042-067K
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.