How do I run a FastLoad script in Teradata?

fl, you can run the FastLoad script using the following command in UNIX and Windows. FastLoad < EmployeeLoad. fl; Once the above command is executed, the FastLoad script will run and produce the log.

How do you run a Tpump?

1. TPUMP – Start Run cmd TPUMP <[Script path]>[Log file path]
2. BTEQ – $Sh> BTEQ<[ Script path >[LOG FILE PATH]
3. FLOAD – Sh> FASTLOAD<[ Script path]/TEE< LOGFILE PATH >(OR)
4. FLOAD – $Sh> FASTLOAD <[ Script path >[LOG FILE PATH]
5. MLOAD – $Sh> Mload <[ Script path]/TEE< LOGFILE PATH >(OR)

How do I run a script in Teradata?

Basic Teradata Query Reference. BTEQ run files are the same as scripts or input stream files except that they are not defined as the SYSIN file for automatic execution when BTEQ is invoked. To execute the file, define the file with a z/OS DD statement. Then, invoke BTEQ and use the RUN command to execute the file.

What is BTEQ script?

A script is a special input file that contains BTEQ commands and Teradata SQL, and is defined as the SYSIN file for automatic execution when BTEQ is invoked.

How to run FastLoad in Teradata on Windows?

Once the input file employee.txt is created and the FastLoad script is named as EmployeeLoad.fl, you can run the FastLoad script using the following command in UNIX and Windows. Once the above command is executed, the FastLoad script will run and produce the log. In the log, you can see the number of records processed by FastLoad and status code.

What is the input file for fastload.txt?

The input file used for the load is named EMPS.TXT. Below the sample script each step will be described in detail. Normally it is not a good idea to put the DROP and CREATE statements in a FastLoad script. The reason is that when any of the tables that FastLoad is using are dropped, the script cannot be restarted.

What does it mean when a restart is requested in FastLoad?

RESTART means that the job is capable of running the processing again from the point where it left off when the job was interrupted, causing it to fail. When CHECKPOINT is requested, it allows FastLoad to resume loading from the first row following the last successful CHECKPOINT.

What are the terms used in FastLoad script?

Following is the list of common terms used in FastLoad script. LOGON − Logs into Teradata and initiates one or more sessions. DATABASE − Sets the default database. BEGIN LOADING − Identifies the table to be loaded. ERRORFILES − Identifies the 2 error tables that needs to be created/updated. CHECKPOINT − Defines when to take checkpoint.