 |
 |
Archives of the TeradataForum
Message Posted: Fri, 19 Oct 2001 @ 09:34:46 GMT
| 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
Dieter
| |
