A
abend
Abnormal END of task. Termination of a task prior to its completion because of an error condition that cannot be resolved by the recovery facilities that operate during execution.
ASCII
American Standard Code for Information Interchange.
B
BOM
Byte Order Mark. A two or three byte field at the beginning of a Unicode file indicating the byte order of the text. A BOM is optional for Unicode text files. A BOM is not allowed in files containing both Unicode text and binary data. A UTF-8 BOM = 0xEFBBBF. A UTF-16LE BOM = 0xFFFE. A UTF-16BE BOM = 0xFEFF.
BTEQ
Basic Teradata Query facility. A utility that allows users to access data on Teradata Database, and format reports for both print and screen output.
C
CLI
Call-Level Interface. The interface between the application program and the MTDP (for workstation-attached clients) or TDP (for mainframe-attached clients).
CLIv2
Call-Level Interface Version2
client
A computer that can access Teradata Database.
client-server environment
The distribution of work on a LAN in which the processing of an application is divided between a front-end client and a back-end server, resulting in faster, more efficient processing.
D
DIF
Data Interchange Format. An export format supported by BTEQ, DIF is a text format used by many spreadsheet applications as a program-independent method for storing row and column data.
DBA
Database Administrator
DBC
Database Computer
DOS
Disk Operating System
F
Field Mode
A Teradata Database response mode which returns database fields (except for large objects) formatted as character data.
FIPS
Federal Information Processing Standards
FastExport
Fast Data Export utility. A program that transfers large amounts of data from Teradata Database to a workstation-attached or mainframe-attached client.
FastLoad
Fast Data Load utility. A program that loads empty tables on Teradata Database with data from a workstation-attached or mainframe-attached client.
G
gateway
A device that connects networks having different protocols.
I
Indicator Mode
A Teradata Database response mode which returns all fields (except for large objects) as unformatted data.
I/O
Input/Output
J
JCL
Job Control Language
L
LAN
Local Area Network
LDO
A Large Data Object, such as a CLOB, BLOB, JSON, or XML data type.
M
mainframe-attached
A mainframe computer that communicates with a server (for example, Teradata Database) through a channel driver or over a local area network (through TCP/IP).
macro
a file that is created and stored on Teradata Database, and is executed in response to a Teradata SQL EXECUTE statement
Multipart Indicator Mode
A Teradata Database response mode which returns all fields (including large objects) as unformatted data.
MTDP
Micro Teradata Director Program
MultiLoad
Multiple Table Update utility. A program that executes specified insert, update, and delete operations against multiple Teradata Database tables.
N
network
In the context of Teradata Database, a LAN (see LAN).
workstation-attached
A computer that communicates over the LAN with a server (for example, Teradata Database).
P
protocol
The rules for the format, sequence and relative timing of messages exchanged on a network.
PDE
Parallel Database Extension
R
Record Mode
A Teradata Database response mode which returns non-null fields (except for large objects) as unformatted data.
records
A formatted record, in Teradata Database terms, consists of a record created by a Teradata Database utility, such as BTEQ, where the record is packaged with begin- and end-record bytes specific to Teradata Database. Unformatted records are any records not originating on Teradata Database. These files contain records that must be defined before loading onto Teradata Database.
row
Used to represent a record in a file or a tuple in relational modeling.
run file
A script that is not contained within the SYSIN file, but rather executed through use of the .RUN BTEQ command.
S
script
A file that contains a set of BTEQ commands or SQL statements or both.
session
A session begins when the user logs on to Teradata Database and ends when the user logs off Teradata Database. Also called a Teradata Database session.
SQL
(Structured Query Language) See Teradata SQL.
stored procedure
a file that is created, compiled and stored on Teradata Database, and is executed in response to a Teradata SQL CALL statement
T
TDP
Teradata Director Program
TDPID
Teradata Director Program Identification
TSO
Time Sharing Option
Teradata SQL
The Teradata Database dialect of the relational language SQL, having data definition and data manipulation statements. A data definition statement would be a CREATE TABLE statement and a data manipulation statement would be a data retrieval statement (a SELECT statement).
U
unformatted records
See Records.
Unicode®
The universal character encoding, maintained by the Unicode® Consortium
http://www.unicode.org. The encoding standard provides the basis for processing, storage, and interchange
of text data in any language in all modern software and information technology protocols.
Within this manual, Unicode® refers to either UTF-8 or UTF-16.
UTF-8
Code scheme that uses a sequence of one to four bytes to represent each Unicode® scalar value.
UTF-16
Code scheme that uses a single 16-bit code unit to represent the most common 63k Unicode® scalar values, and a pair of 16-bit code units, called surrogates, to encode supplementary characters in Unicode®.
V
varbyte
A data type that represents a variable-length binary string.
varchar
A data type that represents a variable-length non-numeric character.
vargraphic
A data type that represents a variable-length string of characters.
W
workstation
A workstation-attached client.
Z
z/OS
Z Series Operating System. An IBM mainframe operating system. One of the primary operating systems for large IBM computers.