Revising Scripts and Run Files - Basic Teradata Query

Basic Teradata Query Reference

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

There are two ways to edit BTEQ scripts and run files:

 

BTEQ State

Command

Invoked

Use the TSO command to access a mainframe-attached system editor, or the OS command to access a workstation-attached system editor.

Not Invoked

Use any available system editor.

Note: Do not use an editor that introduces line numbers into the file.

Note: When editing a script or run file from within BTEQ, it might be necessary to increase the size of the region in use for the TSO command to succeed.

Accessing the System Editor

To access a system editor from within BTEQ:

 

Operating System

Command Options

z/OS

The TSO command:

.TSO ISPF

UNIX OS

The OS command as either:

.OS VI filename

or

.OS ED filename

Windows

The OS command as either:

.OS NOTEPAD filename

or

.OS EDLIN filename

After revising a file and exiting the system editor, BTEQ resumes process control.