Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 19 Oct 2001 @ 09:34:46 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Oracle - TeraData Equivalence Description
From:   Dieter Nöth

Hi Robert,

TeraData                Oracle
==========              ==========
BTEQ                    SQL/PLUS

If SQL/PLUS is the same as PL SQL, then there are differences: BTEQ lacks a real IF/THEN/ELSE, Loops, User Defined Variables ...

PL/I Preprocessor       Nothing

Only for IBM mainframe

  Also, on what platforms does the TeraData Server run? So far from the documentation I found that TeraData runs on NCR systems, Windows (NT and/or 2000) and Mainframes running MVS, VM. How about UNIX servers such as Solaris, AIX, and HP-UX?  

You probably read about the Client. The server runs only on NCR's MPRAS UNIX and on WinNT/2000. MPRAS will not be ported to 64bit, but Teradata is ported to so-called 'Open Unix', the first port is probably HP-Unix. It was supposed to be Solaris, but SUN cancelled support for 64bit Intel (and Teradata runs _only_ on Intel)

  My take on how the Oracle side works is (please correct me if I am wrong):  

  1) A C program with Embedded SQL is run through a C Preprocessor which results in a C program with OCI Calls. (Likewise, a Java program making JDBC calls ends up using the OCI layer via the JDBC drivers)  

  2) The OCI calls interface with NET8 (aka SQLNET). NET8 is really the protocol used by Oracle to connect among clients and servers.  

  3) NET8 (aka SQLNET) interfaces with the next layer (TCP/IP, SNA, etc.).  

AFAIK Teradata uses _only_ TCP/IP

  4) The data flow goes on through Ethernet, Token Ring, Frame Relay, etc to the other side.  

  5) Return data follows the same path in reverse.  

  How could these steps be paraphrased using the Teradata environment?  

mainframe client:
application -> CLI -> TDP -> mainframe channel -> Channel Driver -> Parsing Engine

LAN client (UNIX/Win/OS2...):
application -> CLI -> MTDP -> MOSI -> Ethernet/Token Ring ... -> Teradata Gateway -> Parsing Engine

On Windows/Unix using ODBC:
application -> ODBC -> Ethernet/Token Ring ... -> Teradata Gateway -> Parsing Engine

Don't know about JDBC


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020