15.10 - Glossary - Call-Level Interface Version 2

Teradata Call-Level Interface Version 2 Reference for Mainframe-Attached Systems

Call-Level Interface Version 2
Programming Reference



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 during execution.


The distinct portion of a system account string, excluding the performance group designation. Accounts can be employed wherever a user object can be specified.


A special user responsible for allocating resources to a community of users.


Application Processor


American National Standards Institute. ANSI maintains a standard for SQL. For information about Teradata compliance with ANSI SQL, see SQL Fundamentals (B035‑1141).


Application Program Interface, which is a set of calling conventions by which an application accesses an operating system and other services. An API is defined in the source code and provides a level of abstraction between an application and the kernel (or other privileged utilities) to ensure the portability of the code.

An API can also provide an interface between a high-level language and lower-level utilities and services written without consideration for the calling conventions supported by compiled languages. In this case, the API can translate the parameter lists from one format to another and the interpret call-by-value and call-by-reference arguments in one or both directions.


Application Processor Reset Containment


American Standard Code for Information Interchange, a character set used primarily on personal computers.



Binary large object, which is a large database object (up to 2 GB) that doesn’t require character set conversion, including MIDI, MP3, PDF, graphics, and more.


Call-Level Interface Version 2 (CLIv2)

A collection of callable service routines that provide an interface between an application and the MTDP (for network-attached clients) or TDP (for mainframe-attached). CLI builds parcels that are sent to Teradata Database and provides the application with a pointer to each of the parcels returned from Teradata Database.


Computer-Aided Software Engineering


A mainframe computer that communicates with a server (for example, Teradata Database) through a channel driver.

character set

A grouping of alphanumeric and special characters used by computer systems to support user languages and applications. Various character sets have been codified by the American National Standards Institute (ANSI).


Customer Information Control System


A computer that can access the Teradata Database.


Call-Level Interface Version 2 Shared Object, which is the program that installs the CLI libraries required by other utilities. When CLIv2so submits a request to Teradata Database, CLI Library components transform the request into Teradata Database formats. The CLI Library sends requests to, and receives responses from, Teradata Database over a network.


Character large object, which is a large character-based (such as HTML, RTF) database object up to 2 GB.


Common Business-Oriented Language


In the relational model of Teradata SQL, databases consist of one or more tables. In turn, each table consists of fields, organized into one or more columns by zero or more rows. All of the fields of a given column share the same attributes.


Central processing unit



A related set of tables that share a common space allocation and owner. A collection of objects that provide a logical grouping for information. The objects include tables, views, macros, triggers, and stored procedures.

Data Definition Language (DDL)

In Teradata SQL, the statements and facilities that manipulate database structures (such as CREATE, MODIFY, DROP, GRANT, REVOKE, and GIVE) and the Data Dictionary information kept about those structures.


Database administrator


Data definition language, which supports manipulating database structures and the Data Dictionary information kept about these structures.


In Teradata SQL, a punctuation mark or other special symbol that separates clauses in a Teradata SQL statement or separates one Teradata SQL statement from another.


Extended binary coded decimal interchange code, which is an IBM code that uses 8 bits to represent 256 possible characters. It is used primarily in IBM mainframes, whereas personal computers use ASCII.


Extended UNIX Code. For Japanese and Traditional-Chinese, EUC defines a set of encoding rules that can support from 1 to 4 character sets.


The copying of a subset of data from a source to a target environment.

exit routine

Specifies a predefined action to be performed whenever certain significant events occur during a job.



The basic unit of information stored in Teradata Database. A field is either null, or has a single numeric or string value.


Federal Information Processing Standards



I/Os per transaction


A transaction in process on two or more independent computer processing systems when an interruption of service occurs on one or more of the systems. The transaction is said to be in doubt because it is not known whether the transaction is successfully processed on all of the systems.




International Standards Organization



Job Control Language is a language for describing jobs (units of work) to z/OS and VSE operating systems (OSs), which run on IBM z800/900 large server (mainframe) computers. These OSs allocate their time and space resources among the total number of jobs started in a computer. Jobs then break down into job steps. All the statements required to run a particular program constitute a job step. Jobs are background (sometimes called batch) units of work that run without user interaction (for example, print jobs). The OS manages interactive (foreground) user requests that initiate units of work. In general, foreground work is given priority over background work.


Japanese Industrial Standards specify the standards for industrial activities in Japan. The standardization process is published through Japanese Standards Association.



Large object, which is a database object that is up to 2 gigabytes. LOBs can be character-based (CLOBs) or binary-based (BLOBs).


A file that records events. Many programs produce log files. Log files can help determine what happened during an processing failure. Log files have the extension “.log”.



A file that is created and stored on Teradata Database, and executed in response to a Teradata SQL EXECUTE statement


Micro Teradata Director Program, which is a library of routines that implement the session layer on the workstation. MTDP is the interface between CLI and Teradata Database.


Massively parallel processing

MVS (Multiple Virtual Storage)

One of the primary operating systems for large IBM computers.



A word supplied by a user that refers to an object, such as a column, database, macro, table, user, or view.


The absence of a value for a field.



A variable name in a macro for which an argument value is substituted when the macro is executed.

physical action

A basic action type, such as <Send a Page>, <Send an E-Mail>, etc. Physical actions must be encapsulated by logical actions in order to be used in an alert policy.


Short name for Teradata stored procedure. Teradata provides Stored Procedural Language (SPL) to create stored procedures. A stored procedure contains SQL to access data from within Teradata and SPL to control the execution of the SQL.


The rules for the format, sequence, and relative timing of messages exchanged on a network.



In host software, a message sent from an application program to the Teradata Database.


The information returned to a user to satisfy a request made of the Teradata Database.


Whether null or not, a row represents one entry under each column in a table. The row is the smallest unit of information operated on by data manipulation statements.



A computer system running Teradata Database. Typically, a Teradata Database server has multiple nodes, which can include both TPA and non-TPA nodes. All nodes of the server are connected through the Teradata BYNET or other similar interconnect.


A session begins when a user logs on to Teradata Database and ends when the user logs off. Also called a Teradata Database session.


Smart LOB. A method of processing LOBs where Teradata can process LOBs as DEFERRED or INLINE based on user criteria.


Symmetric multi-processing


A request for processing by Teradata Database that consists of a keyword verb, optional phrases, and operands, and that is processed as a single entity.


The details of a process used to collect, analyze, and transform the database objects used by a given query.

stored procedure

A combination of SQL statements and control and conditional handling statements that run using a single call statement.



A set of one or more columns with zero or more rows that consist of fields of related information.


Transmission Control Protocol/Internet Protocol.


Teradata Director Program Identifier, which is the name of the Teradata Database being accessed.


Teradata Director Program, which provides a high-performance interface for messages communicated between the client and the Teradata system.

test system

A Teradata Database where you want to import Optimizer-specific information to emulate a target system and create new queries or test new features.


In Teradata SQL, a string used as a column heading in a report. By default, the title is the column name, but a title can also be explicitly declared by a TITLE phrase.


Trusted parallel application


Teradata operating system


A set of Teradata SQL statements performed as a unit. Either all of the statements are executed normally, or else any changes made during the transaction are backed out and the remainder of the statements in the transaction are not executed. Teradata Database supports both ANSI and Teradata transaction semantics.


One or more Teradata SQL statements associated with a table and executed when specified conditions are met.

two-phase commit

The process by which a relational database ensures that distributed transactions are performed in an orderly manner. Transactions are terminated by either committing them or rolling them back.


An attribute of a column that specifies the representation of data values for fields in that column. Teradata SQL data types include numerics and strings.



User-defined functions


A fixed-width (16 bits) encoding of virtually all characters present in all languages in the world.


In Teradata SQL, a database associated with a person who uses Teradata Database. The database stores the person‘s private information and accesses other Teradata Databases.


A database associated with a person who uses Teradata Database. The database stores the person‘s private information and accesses other Teradata Databases.


In simple terms, UTF-8 is an 8 bit encoding of 16 bit Unicode® to achieve an international character representation.

In more technical terms, in UTF-8, characters are encoded using sequences of 1 to 6 octets. The only octet of a sequence of one has the higher-order bit set to 0, the remaining 7 bits are used to encode the character value. UTF-8 uses all bits of an octet, but has the quality of preserving the full US-ASCII range. The UTF-8 encoding of Unicode® and UCS avoids the problems of fixed-length Unicode® encodings because an ASCII file encoded in UTF is exactly same as the original ASCII file and all non-ASCII characters are guaranteed to have the most significant bit set (bit 0x80). This means that normal tools for text searching work as expected.


A 16-bit Unicode® translation format.



A data type that represents a variable-length binary string.


A data type that represents a variable-length non-numeric character.


A data type that represents a variable-length string of characters.


An alternate way of organizing and presenting information in Teradata Database. A view, like a table, has rows and columns; however, the rows and columns of a view are not directly stored by Teradata Database, rather they are derived from the rows and columns of tables (or other views).



One of the primary operating systems for large IBM computers.

z/VM (Virtual Machine)

One of the primary operating systems for large IBM computers.