15.00 - z/OS Example - FastLoad

Teradata FastLoad Reference

prodname
FastLoad
vrm_release
15.00
category
Programming Reference
featnum
B035-2411-034K

z/OS Example

Table 45 shows an example procedure for the OS command used on an z/OS client system.

 

Table 45: Example Procedure for OS Command on z/OS Client System 

Command

Example

TSO Setup Procedure

Before using the OS command on z/OS, the timesharing 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:

  • <APPLOAD LIBRARY> is the fully qualified name of the load library containing Teradata FastLoad and CLIV2 components.
  • Note: Unlike batch, TSO does not support concatenated load libraries.

  • <IBM C Linklib>is the fully qualified name of the IBM C link library.
  • 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.

     

    Table 46: Usage Notes for QUIT 

    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:

  • Code 0—Normal completion. The job completed successfully and according to the specified plan.
  • Code 4—Warning. A warning condition occurred. Warning conditions do not terminate the job.
  • Code 8—User error. A user error, such as a syntax error in the Teradata FastLoad job script, terminated the job.
  • Code 12—Fatal error. Job is terminated. A fatal error is any error other than a user error.
  • Example  

    The following command example ends Teradata FastLoad and exits the Teradata Database:

    QUIT ;