Books
in black and white
Main menu
Share a book About us Home
Books
Biology Business Chemistry Computers Culture Economics Fiction Games Guide History Management Mathematical Medicine Mental Fitnes Physics Psychology Scince Sport Technics
Ads

Introduction to the Teradata® RDBMS for UNIX® Version 2 Release 2.1 - NCR

NCR Introduction to the Teradata® RDBMS for UNIX® Version 2 Release 2.1 - NCR, 1998. - 315 p.
Download (direct link): inntroduktionteradata1998.pdf
Previous << 1 .. 37 38 39 40 41 42 < 43 > 44 45 46 47 48 49 .. 76 >> Next

Application Development

Using the Call-Level Interface to Develop Applications

Introduction

What is the CLI?

Using the Call-Level Interface to Develop Applications

The Teradata RDBMS uses CLI or ODBC for all communication between a user terminal and the Teradata RDBMS. Whether used explicitly or under the covers, the CLI and ODBC are the basis for all communication between users and the Teradata RDBMS.

This topic describes using the CLI explicitly to develop applications.

The CLI packages SQL requests on a client for routing to the Teradata server. When a results set is returned to the client, the CLI unpackages the results for the system to display to the user or write in a report.

The CLI can be used directly in application programs written in any language that supports a CALL statement.

The exact implementation of the CLI differs slightly between channel-attached and network-attached clients, but the basic functions of the CLI are the following:

• To block and unblock messages

• To log sessions on and off the server

• To provide an interface between users and the TDP (or MTDP).

Like all other messages sent to the Teradata RDBMS, the CLI messages are ultimately processed as SQL by the parser on the server. The CLI packages and unpackages this SQL by means of calls to system subroutines.

Because any client language that supports a call statement can use the CLI to communicate with a Teradata RDBMS, the CLI is a very flexible tool for developing applications.

On the other hand, it is rather difficult to master, and most users will probably find that their time is better spent developing applications using explicit SQL, either embedded in a native client language supported by Preprocessor2 or in macros.

Introduction to the Teradata RDBMS for UNIX

8-9
Application Development

Using the Call-Level Interface to Develop Applications

CLI routines are provided as object modules that have been compiled or assembled according to standard linkage conventions. CLI routines are available for many client operating environments including the following:

• MVS
• CICS
• IMS
• VM/SP
• UNIX
• DOS

Custom ports to other platforms are also available.

The OBDC Driver for Teradata Database System provides an What is ODBC? alternate, CLI-independent interface to Teradata databases using the

industry standard OBDC application programming interface.

OBDC is support in the Windows, Windows NT, and Windows 95 environments.

8-10

Introduction to the Teradata RDBMS for UNIX
Application Development

Using TS/API to Develop Applications for the Teradata RDBMS

Using TS/API to Develop Applications for the Teradata RDBMS

Introduction

The Teradata RDBMS supports many third party software products. There are two general components of supported products: those of the transparency series and the native interface products.

TS/API Products

The Transparency Series/Application Program Interface (TS/API) product provides a gateway between the IBM mainframe relational database products DB2 (MVS/TSO) and SQL/DS (VM/CMS) and the Teradata RDBMS.

TS/API permits a SQL statement formulated for either DB2 or SQL/DS to be translated into Teradata SQL so DB2 or SQL/DS applications can access data stored in a Teradata RDBMS.

Many third party interactive query products operate in conjunction C°mpatible Third Party with the Teradata RDBMS, permitting queries formulated in a

Software Products 8 native query language to access a Teradata RDBMS.

The list of supported third party products changes continuously.

For a current list, contact your NCR sales office.

Introduction to the Teradata RDBMS for UNIX

8-11
Application Development

For More Information

For More Information

For more information on the topics presented in this chapter, see the following Teradata RDBMS manuals.

IF you want to learn more about . . . THEN see this manual . . .
Teradata SQL data manipulation statements Teradata RDBMS for UNIX SQL Reference Manual
Embedded SQL Teradata RDBMS for UNIX SQL Reference Teradata Application Programming With Embedded SQL for C, COBOL, and PL/I
Using the Teradata SQL preprocessor Teradata Application Programming With Embedded SQL for C, COBOL, and PL/I
Call Level Interface programming Teradata Call-Level Interface Version2 for Channel-Attached Systems Teradata Call-Level Interface Version2 for Network-Attached Systems
TS/API products Teradata RDBMS TS/API Concepts and Facilities Teradata RDBMS TS/API User’s Guide Teradata RDBMS TS/API System and Database Administration Guide Teradata RDBMS TS/API Installation Guide

8-12

Introduction to the Teradata RDBMS for UNIX
Fault Tolerance

Chapter 9

Fault Tolerance

Introduction to the Teradata RDBMS for UNIX
Fault Tolerance

Introduction to the Teradata RDBMS for UNIX
Introduction

Software Fault Tolerance

Hardware Fault Tolerance

Fault Tolerance

About This Chapter
Previous << 1 .. 37 38 39 40 41 42 < 43 > 44 45 46 47 48 49 .. 76 >> Next