TPT OS Operator

Pradeep

TPT OS Operator

Teradata Parallel Transporter (TPT) provides a way to executes some of OS command inside Teradata session using TPT standalone OS Operator.

TPT OS Operator Characteristics:

This is a standalone operator which means it is neither a consumer or producer operator.
DDL Operator can use only single teradata session.
Multiple instances are not supported in SELECT Operator, if specified then it will fail with below error.
```
Producer_Query_Detail: TPT10327: Multiple instances are not supported
```
Output from executed commands in TPT OS operator will be written to TPT job log.

Example 1: Simple OS Operator example, running single OS command

DEFINE JOB OS_Operator
  DESCRIPTION 'Running OS Commands'
  (
      DEFINE OPERATOR os_commands
      TYPE OS COMMAND
      ATTRIBUTES
      (
          VARCHAR  OsCmd= 'touch /Users/username/Desktop/testfile',
          VARCHAR IgnoreError = 'NO'
      );
      APPLY TO OPERATOR (os_commands);
);

Example 2: OS Operator with multiple command example

DEFINE JOB OS_Operator
  DESCRIPTION 'Running OS Commands'
  (
      DEFINE OPERATOR os_commands
      TYPE OS COMMAND
      ATTRIBUTES
      (
          VARCHAR ARRAY OsCmd= ['pwd','ls -lrt'],
          VARCHAR IgnoreError = 'NO'
      );
      APPLY TO OPERATOR (os_commands);
);

Example 3: Simple OS Operator example, running single OS command

DEFINE JOB OS_Operator
  DESCRIPTION 'Running OS Commands'
  (
      DEFINE OPERATOR os_commands
      TYPE OS COMMAND
      ATTRIBUTES
      (
          VARCHAR ARRAY OsCmd= ['pwd','ls -lrt'],
          VARCHAR IgnoreError = 'NO'
      );
      STEP BACKUP_FILE
      (
         APPLY TO OPERATOR (os_commands);
      );
);

Executing TPT OS

Example 1: Executing simple TPT OS Operator script
```
tbuild -f tpt_os_command.tpt
```
Example 2: Executing TPT OS Operator script with multiple commands
```
tbuild -f tpt_os_commands.tpt
```
Example 3: Executing OS Operator script with steps
```
tbuild -f tpt_os_command_with_step.tpt
```

Download script files