Syntax Variable Definitions - Basic Teradata Query

Variable

Definition

bteq_command

BTEQ command

charstring

Character set name

code

Numeric code of character set

ddname

Name of the z/OS JCL DD statement

errno

Error number

filename

Name of workstation-attached system file

Note: Enclose all file name variables within single or double quotation marks. In the following example, 'myscript.txt' is the file name:

.RUN FILE 'myscript.txt' 

Also, when text follows a file name, the file name must be enclosed in quotation marks. For example:

.RUN FILE "myscript.txt" SKIP 2 

'init-string'

Name of the initiation string used to start the import process.

modname

Name of the file that is to receive the imported data.

operator

Comparison operator

options

z/OS QUEUE option

os_command

Legal command in the current operating system

sql_request

SQL statement

string

Text string

text

16-character job identifier

withlist

List of WITH clause identifiers

xxx

Name of z/OS DD statement