 |
 |
Archives of the TeradataForum
Message Posted: Wed, 16 Jul 2003 @ 18:11:38 GMT
| Subj: | | Re: Alternatives to Teradata load utils |
| |
| From: | | Geoffrey Rommel |
| | Hopefully it's just a matter of time until one clever programmer will use CLI to build something as good as Fastload and Multiload,
but cheaper. | |
With all due respect to the clever programmers out there, this might be very difficult to do. One reason FastLoad and MultiLoad are
so fast is that they do not use the DBC/SQL partition. When Teradata sees that a session is running in the FASTLOAD or MLOAD partition, it
uses a different code path to work with whole blocks rather than individual rows. By the same token, you must issue requests that are
appropriate for those partitions; for instance, just as you cannot issue MONITOR SESSION from DBC/SQL, you cannot issue EXEC from FASTLOAD.
Since NCR, as far as I know, is not in the habit of disclosing the detailed interface for those partitions (although I believe they did
disclose the interface for FastLoad to SAS), a programmer might find it nearly impossible to duplicate what the utilities are doing.
| |
