A FastExport job script, or program, is a set of FastExport commands and Teradata SQL statements that select and export data from Teradata Database.
Each FastExport job includes a number of support commands that establish and maintain the FastExport support environment, and a number of task commands that perform the actual database select and export operations.
A complete FastExport job includes:
1 Invoke FastExport, specifying desired runtime options:
2 Establish the FastExport support environment as indicated in Table 22.
Command |
Description |
Specify the restart log table that maintains checkpoint information for the FastExport job. |
|
Specify the form of the DATE data type specifications for the FastExport job. |
|
Establish a session with Teradata Database. |
|
Transfer processing control to an alternate run file. |
|
Specify an alternate destination for FastExport output messages. |
|
Submit an operating system command to the client system. |
|
Teradata SQL statements |
Submit a supported Teradata SQL statement to Teradata Database. |
At a minimum, this portion of the FastExport job must include:
State these commands in any order, but both commands must appear before any task commands in the FastExport job script.
3 Specify the FastExport task as indicated in Table 23.
Command |
Description |
Signify the beginning of an export task specification. |
|
Specify, in conjunction with immediately following FIELD and FILLER commands, the layout of the input data records on the client system. (The layout specification will be referenced in a subsequent IMPORT command.) |
|
Specify a field of the input record to be used to supply values for variables in the SELECT statement. |
|
Describe a field of the input data record that is not referenced, but used only to indicate the relative position of the following FIELD data. |
|
Specify the destination file and format specifications for export data retrieved from Teradata Database. |
|
Specify the client file that provides the USING values for the SELECT statement. |
|
SELECT |
Specify the row data to be exported from Teradata Database. |
Signify the end of the FastExport task and initiate the task processing. |
At a minimum, this portion of the FastExport job must include:
4 To specify another FastExport task:
Repeat these steps for each task in the FastExport job.
5 Use the LOGOFF command to disconnect all active sessions with Teradata Database and terminate FastExport on the client system.