15.00 - Usage Notes - Interactive Teradata Query Facility

Interactive Teradata Query Reference

prodname
Interactive Teradata Query Facility
vrm_release
15.00
category
Programming Reference
featnum
B035-2451-034K

Usage Notes

The SHOW MACRO, VIEW, and TABLE commands are actually Teradata SQL statements that are processed by the Teradata DBS. The abbreviations “SM”, “SV”, and “ST” are unique to ITEQ.

SHOW MACRO allows the user to view and/or modify the last version of a macro, either in the CREATE MACRO statement form, or in the REPLACE MACRO statement form. The display area is converted to the edit area to display the statement, and any desired changes are made in the edit area. The macro definition may then be replaced with the revised version, using the REPLACE MACRO statement. If no changes are made in the macro, the display can be erased from the screen by pressing the CLEAR INPUT key (PF17) on the terminal. The abbreviation for SHOW MACRO is SM.

SHOW VIEW allows the user to see and/or modify the latest statement that defines a view. The current version of the view may be replaced with a revised version using the REPLACE VIEW statement. If no changes are made in the displayed statement, it can be erased from the screen by pressing the CLEAR INPUT key (PF17) on the terminal. The abbreviation for SHOW VIEW is SV.

SHOW TABLE allows the user to see the present CREATE TABLE statement used to define a table. Although the table definition cannot be replaced, the user may add or delete table columns using the ALTER TABLE statement.

A user can print a copy of SHOW results while the results are still active in the display area by entering the SHOW command and then the PRINT command.

A user can obtain information about the attributes of a specific object contained within a table, view, or macro by entering a HELP statement. (For specific information about the HELP statement, refer to the Teradata SQL Reference Manual.

The abbreviation for SHOW TABLE is ST.