For the commands not listed below, refer to the tables above. RETRY resubmit requests that fail under certain error conditions. BTEQ vs. Yet, BTEQ is not a utility designed for bulk data movement. Firstly, Teradata export and load utilities are fully parallel.
|Published (Last):||27 December 2018|
|PDF File Size:||3.99 Mb|
|ePub File Size:||6.82 Mb|
|Price:||Free* [*Free Regsitration Required]|
Teradata Fastexport is a command driven utility that uses multiple sessions to transfer data from tables or views to client system. The main reason for using FastExport is that it takes full advantage of multiple session which influence Teradata parallelism. Thus the export is lightning fast. Retrieve the data from database by executing the query provided. Export data to the specified file. Log off from database. It can support conditional logic, arithmetic calculations, logical expressions and data conversion.
Only 15 Utilities? This value can be reset from The reason why Teradata allows only 15 session is that these all utilities use large blocks to transfer the data. If more than 15 jobs are supported then there might be a possibility of reaching saturation point for the resources available.
Thus to protect system from this saturation Teradata allows only 15 jobs at a time keeping rest it the queue state. Once the FastExport is invoked it puts the rows into spool and then starts building the data blocks.
If the output data is sorted, Bteq will still continue to send the data row by row, no redistribution is required.
Redistribution of data is required to build the blocks into correct sequence which thus takes a little longer time. If BTEQ terminates abruptly, all the rows are discarded from the spool.
You will have to rerun the BTEQ from scratch. If FastExport terminates abruptly, all the rows are in worktables and it can continue sending them where it left off.
BTEQ - Entering DOS commands in Teradata
Teradata BTEQ Scripts
BTEQ - Commands for Session control in Teradata