SYSTEM - Parallel Data Pump

Teradata Parallel Data Pump Reference

Product
Parallel Data Pump
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-3021
lifecycle
previous
Product Category
Teradata Tools and Utilities

SYSTEM

Purpose  

The SYSTEM command allows access to the local operating system during Teradata TPump operations.

Syntax  

where

 

Syntax Element

Description

‘oscommand'

Command string (enclosed within single quotes) that is appropriate to the local operating system

The SYSTEM command suspends the current Teradata TPump application in order to execute the command. When the command completes, the return code from the invoked command is displayed, and the &SYSRC variable is updated with the return code.

Usage Notes

On z/OS clients, the command is passed to the PGM executor. The first token of the command string is interpreted as a load module and the remainder as a PARM string. As an example, the following statement calls the load module IEBUPDTE, passing the PARM string “NEW”.

   .SYSTEM “IEBUPDTE NEW”;

This command calls IEBUPDTE in the same way it is called via the JCL statement:

   //EXEC PGM=IEBUPDTE,PARM='NEW'

On z/OS, the program must be present in the STEPLIB or JOBLIB concatenation, be resident in one of the LPAs, or be located in the linklist concatenation.

Otherwise, the invocation will fail, with code SYS_ABTM (‑14) returned, resulting from an underlying abend S806‑04. Other types of failures also are possible.

On UNIX OS clients, the SYSTEM command invokes the standard UNIX OS interface to issue the command to the shell (sh), and waits for its completion.