17.10 - CLI Design Goals - Call-Level Interface Version 2

Teradata® Call-Level Interface Version 2 Reference for Workstation-Attached Systems

Product
Call-Level Interface Version 2
Release Number
17.10
Release Date
October 2021
Content Type
Programming Reference
Publication ID
B035-2418-061K
Language
English (United States)
The design of CLI was guided by the following goals:
  • It must be simple to use.
  • It must have enough power and flexibility to enable Teradata SQL (Structured Query Language) applications to exploit fully the power of Advanced SQL Engine.
  • It must be efficient. Workstation CPU and virtual storage utilization must be minimized.
  • The above goals must be met both for preprocessor applications and for applications that do not use a preprocessor, that is, for applications that make direct calls to CLI.
  • It must support SQL/DS- and DB2-compatible preprocessors, if they become available.
  • Installation and maintenance must be simple.