TSO - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
15.00
Language
English (United States)
Last Update
2018-09-25
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

TSO

Purpose  

Submits a TSO command in z/OS TSO only. Not valid on workstation-attached systems.

Syntax  

where:

 

Syntax Element

Specification

tso_command

Any TSO command or program

Usage Notes  

Use the TSO command to allocate files, list catalogs, or perform other TSO activities. The TSO command requires an interactive TSO environment. The command cannot be run within a
z/OS batch environment, regardless if the TSO terminal monitor program (TMP) is being used or not.

BTEQ removes all trailing semicolons before submitting the command.

The TSO command can be used in a Teradata SQL macro, but only for one command at a time.

Example  

To allocate a file named ABC, specify:

   .TSO ALLOC DDNAME(ABC) DSNAME(ABC) SHR

Example  

The Example 1 TSO command in a Teradata SQL macro appears as:

   ECHO '.TSO ALLOC DDNAME';