Inserting Aster Analytical Functions - Teradata Studio

Teradata Studio IDE Plug-in User Guide

Product
Teradata Studio
Release Number
15.12
Published
August 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
pts1468860020550.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2043
lifecycle
previous
Product Category
Teradata Tools and Utilities
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.