Running Multi-Line SQL Queries in ACT - Aster Client

Teradata Aster® Client Guide

Product
Aster Client
Release Number
7.00
Published
May 2017
Language
English (United States)
Last Update
2018-04-13
dita:mapPath
hki1475000360386.ditamap
dita:ditavalPath
Generic_no_ie_no_tempfilter.ditaval
dita:id
B700-2005
lifecycle
previous
Product Category
Software
To run a multi-line SQL query from the command line:
  1. Type the first line of the query, then press Enter.

    The ACT prompt changes from => to -> (for example, retail_sales->).

  2. Enter the remaining lines.

    You can press Ctrl-C at any time to abandon this command mode without executing the query.

  3. On the last line, type a semicolon at the end of the line, then press Enter to run the query.

For example:

retail_sales=> select customer_id, gender, city_id
retail_sales->from customer_dim
retail_sales->order by gender;

or

retail_sales=> select customer_id, gender, city_id
retail_sales->from customer_dim
retail_sales->order by gender
retail_sales->;