Archives of the TeradataForum

Message Posted: Fri, 19 Oct 2001 @ 12:54:13 GMT

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

The Cobol and PLI pre-processors are only for use on MVS. There are mainframe, Unix and Windoze versions of all of the host (client) utilities that developers/users may need. BTEQ, Fastload and Multiload are the main ones.

BTEQ can perform small-scale imports and large(ish) exports. Above certain data volumes Fastexport takes over. BTEQ is the batch SQL workhorse. Fastload loads data to empty tables from host files. Multiload inserts/updates populated tables from host files. Arcmain performs archive and restore operations.

TPUMP is a newer utility and can be used to trickle feed data into Teradata during the day. The beauty of this facility is that it can be controlled by the user so that it runs in times of low CPU usage. It can also be stopped on demand.

All application code that runs on Teradata is SQL. It is typically submitted from a Unix, MVS or application server using an NCR client application (BTEQ, Fastload, Multiload, Queryman etc) or a 3rd party tool (SAS, Micro Strategy, Ceres, Business Objects etc). Whether running interactively or in batch mode, the SQL is sent to the Teradata server, executed and the response relayed back to the user.

Access to the server is either through a dedicated mainframe channel or a TCP/IP connection via the network. A single Teradata machine may serve incoming requests from many different sources at the same time. A user may have access to several Teradata servers from a single location.

Hope this helps,

Paul Johnson.

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