16.20 - Teradata.syn - 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

This file contains an example for each Teradata statement. This information can be viewed in the Favorites window, or within the Query Builder.

The file consists of one definition for each example. Each definition contains two parts and can span multiple lines in the file. The two parts are separated by the string ~|~ and the definition ends with the string |~|.

The first part is the statement keyword itself – possibly followed by text within parenthesis. This extra text is used when multiple examples are defined for a single statement.

The second part is the example itself. This will be displayed, and optionally inserted into a query, exactly as entered in this file.

Example:

CREATE DATABASE~|~CREATE DATABASE finance
   FROM ApplDb
AS
   PERM = 2000000 SKEW = 100
   SPOOL = 5000000
   FALLBACK
   ACCOUNT= 'ACCTG'
   NO AFTER JOURNAL
   DUAL BEFORE JOURNAL
   DEFAULT JOURNAL TABLE = finance.journals;|~|
DROP DATABASE~|~DROP DATABASE MyDb;|~|
SELECT (Aggregate)~|~SELECT COUNT(employee)
  FROM Department
  WHERE DeptNo > 100
  HAVING COUNT(employee) > 10 ;|~|