z/OS Example
Table 45 shows an example procedure for the OS command used on an z/OS client system.
Command |
Example |
TSO Setup Procedure |
Before using the OS command on z/OS, the time‑sharing option (TSO) must be set up to run Teradata FastLoad interactively, as in the following example: /***************************************************************/
/* */
/* THIS CLIST INVOKE IBM_C VERSION OF FASTLOAD. */
/* */
/*‑*‑*‑*‑*‑*‑*‑*‑*‑*‑*‑*‑*‑*‑*‑*‑*‑*‑*‑*‑*‑*‑*‑*‑*‑*‑*‑*‑*‑*‑*/ /* */
/* PARAMETER USE */
/* ========= === */
/* DBCPFX = HIGH LEVEL QUALIFIER FOR "APPLOAD" LIBRARY. */
/* DEFAULT IS "DBC". */
/* */
/***************************************************************/
PROC 0 DBCPFX(<APPLOAD LIBRARY>)
CONTROL NOMSG PROMPT
WRITE 'FASTLOAD CLIST TTU14.10'
ALLOC FI(CTRANS) DA('IMB_C LinkLib') SHR
ALLOC FI(SYSIN) DA(*)
ALLOC FI(SYSPRINT) DA(*)
ALLOC FI(SYSOUT) DA(*)
ALLOC FI(SYSTERM) DA(*)
CALL '&DBCPFX..APP.L(FASTLOAD)'
FREE FI(CTRANS,SYSIN,SYSPRINT,SYSOUT,SYSTERM)
EXIT
where: Note: Unlike batch, TSO does not support concatenated load libraries. Note: Input data sets can be allocated and freed. |
TSO Command |
After setting up TSO to run Teradata FastLoad interactively, the Teradata FastLoad OS command can be used to enter any valid TSO command: OS <TSO command>;
|
QUIT
Purpose
The QUIT command ends Teradata FastLoad sessions and exits from the Teradata Database.
The LOGOFF and QUIT commands may be used interchangeably.
Syntax
Usage Notes
Table 46 describes the things to consider when using the QUIT command. For more information about restarting a paused job, see “Restart a Paused Teradata FastLoad Job” on page 45.
Topic |
Usage Notes |
Pausing Teradata FastLoad |
If the QUIT command is entered after a BEGIN LOADING command, but before the END LOADING command, the Teradata FastLoad job pauses, and can be restarted later. |
Locked Tables |
When a Teradata FastLoad job pauses during the loading phase, the Teradata Database locks the tables named in the BEGIN LOADING command. The tables remain locked until an END LOADING command is entered. |
Terminating Return Codes |
When a Teradata FastLoad job terminates, the utility returns a code indicating the way the job completed: |
Example
The following command example ends Teradata FastLoad and exits the Teradata Database:
QUIT ;