15.00 - Completion Message - FastLoad

Teradata FastLoad Reference

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

Completion Message

The Teradata FastLoad completion message is:

Now set to read “UNFORMATTED” records.

SET SESSION CHARSET

Purpose  

The SET SESSION CHARSET command specifies which character set is in effect during a specific Teradata FastLoad invocation.

Note: The SET SESSION CHARSET command applies only to network‑attached systems. For mainframe‑attached systems, see “Invoking Teradata FastLoad” on page 33 for a description of the CHARSET parameter.

Syntax  

where:

 

Syntax Element

Description

ASCII

ASCII character set.

KANJIEUC_0U

Kanji Extended UNIX Code character set.

KANJISJIS_0S

Combined JIS‑x0208 and JIS‑x0201 character set developed by Microsoft.

Usage Notes  

Table 50 describes the things to consider when using the SET SESSION CHARSET command.

 

Table 50: Usage Notes for SET SESSION CHARSET 

Topic

Usage Notes

Command Placement

The SET SESSION CHARSET command must appear before the LOGON command in the Teradata FastLoad job script.

Double Quote Characters in Character Set Name Specifications

The names of the character sets must be enclosed in double quote characters.

Priority of Character Set Specifications

The order in which the character set is determined for a Teradata FastLoad job is:

1 User specified by a:

  • Runtime parameter (This specification has the highest priority on all supported platforms.)
  • SET SESSION CHARSET command on networkattached systems
  • CHARSET parameter in the Teradata FastLoad configuration file
  • 2 System Parameter Block (SPB) specified by the:

  • HSHSPB on mainframeattached systems
  • clispb.dat file on networkattached systems.
  • 3 Teradata Database default, determined by a query from Teradata FastLoad.

    SHOW

    Purpose  

    The SHOW command displays active definitions for the input data source or INMOD routine and the field names that were established by one or more DEFINE commands.

    Syntax  

    Usage Notes

    The SHOW command displays:

  • Field names
  • Data type (integer or character) of each field
  • Internal length of each field
  • Offset of each field within the input record
  • Input data source or INMOD routine names
  • If a DEFINE command has not been entered, the result is blank and Teradata FastLoad responds with this message:

    TOTAL RECORD LENGTH = 0

    Note: The SHOW command is processed by Teradata FastLoad. It is not transmitted to the Teradata Database.

    Example  

    When the following DEFINE command is active:

    DEFINE EmpNo (smallint),
    Name (varchar(12)),
    DeptNo (decimal (3,0)),
    JobTitle (varchar(12)),
    Salary (decimal(8,2)),
    YrsExp (byteint),
    DOB (date),
    Sex (char(1)),
    Race (char(1)),
    MStat (char(1)),
    EdLev (byteint),
    HCap (byteint)
    FILE=EmpData ; 

    The Teradata FastLoad response to the SHOW command is:

    FILE = EmpData
    EMPNO        OFFSET=   0   LEN =  2   SMALLINT
    NAME         OFFSET =  2   LEN =  12  VARCHAR
    DEPTNO       OFFSET=  16   LEN =  2   DECIMAL
    JOBTITLE     OFFSET=  18   LEN =  12  VARCHAR
    SALARY       OFFSET=  32   LEN =  4   DECIMAL
    YRSEXP       OFFSET=  36   LEN =  1   BYTEINT
    DOB          OFFSET=  37   LEN =  4   DATE
    SEX          OFFSET=  41   LEN =  1   CHAR
    RACE         OFFSET=  42   LEN =  1   CHAR
    MSTAT        OFFSET=  43   LEN =  1   CHAR
    EDLEV        OFFSET=  44   LEN =  1   BYTEINT
    HCAP         OFFSET=  45   LEN =  1   BYTEINT
    TOTAL RECORD LENGTH=  46

    SHOW VERSIONS

    Purpose  

    The SHOW VERSIONS command displays the current level of all Teradata FastLoad utility software modules.

    Syntax  

    Usage Notes  

    Use the SHOW VERSIONS command to retrieve the version information when reporting software problems.

    Example  

    The following command example displays the current versions of software modules in use:

    .SHOW VERSION;
     
        FastLoad Version 15.00.00.00 for Win 32 running Windows Sockets
        FastLoad  : 15.00.00.02
        FastCmds  : 15.00.00.04
        FastIO    : 15.00.00.00
        FastMBCS  : 14.10.00.00
        FastNtfy  : 15.00.00.00
        FastPars  : 15.00.00.03
        FastSQL   : 15.00.00.03
        FastUtil  : 15.00.00.04
        Fdlosdep  : 13.01.00.00
        Teradata Data Connector  : 15.00.00.00
        PMPROCS   : 15.00.00.09
        PMRWFMT   : 15.00.00.00
        PMTRCE    : 13.10.00.02
        PMMM      : 13.00.00.01
        PMUDDI    : 15.00.00.02
        DCUDDI    : 15.00.00.09
        PMHEXDMP  : 14.10.00.00
        PMUNXDSK  : 15.00.00.05
        ICUVER    : TDICU, 15.00.00.00
        CLIV2     : 15.00.00.05
        MTDP      : 15.00.00.04
        MOSIos    : 14.10.00.09
        MOSIDEP   : 14.10.00.06
        OSENCRYPT : N/A
        OSERR     : 14.00.00.00
     
        FastLoad linking date: Dec 23 2013

    SLEEP

    Purpose  

    The SLEEP command specifies the number of minutes that Teradata FastLoad pauses before retrying a logon operation when the maximum number of load operations is already running on the Teradata Database.

    Syntax  

    where:

     

    Syntax Element

    Description

    minutes

    Number of minutes that Teradata FastLoad pauses before retrying the logon operation.

    The minutes specification must be greater than zero. If zero is entered, Teradata FastLoad responds with an error message, and terminates.

    The Teradata FastLoad default, if the SLEEP command is not used, the number of minutes is 6.

    Usage Notes  

    Table 51 describes the things to consider when using the SLEEP command.

     

    Table 51: Usage Notes for SLEEP 

    Topic

    Usage Notes

    Function

    The SLEEP specification works with the TENACITY specification to control Teradata FastLoad logon attempts.

    When Teradata FastLoad tries to log on for a new session, and the Teradata Database indicates that the maximum number of load sessions is already running, the Teradata FastLoad utility:

    1 Logs off any new sessions that were logged on

    2 Waits for 6 minutes, by default, or for the amount of time specified by the SLEEP command

    However, if the amount of time specified by the SLEEP command exceeds that of the TENACITY command, then the sleep interval is reset and equated to the amount of time specified by the TENACITY command.

    For example, if the time specified with the SLEEP command is 65 minutes and the time specified with TENACITY command is 1 hour, then the SLEEP time is reset to 60 minutes so that the SLEEP time does not exceed the TENACITY time.

    3 Tries again to log on to the Teradata Database

    Teradata FastLoad repeats this process until it has either logged on for the required number of sessions or equates the amount of time specified by the TENACITY command.

    Note: The sleep interval specified in the SLEEP command is dynamically adjusted so that the total sleep times does not exceed the amount of time specified by the TENACITY command.

    For example, if the time specified with the SLEEP command is 35 minutes and the time specified with the TENACTY command is 1 hour, then:

  • FastLoad sleeps for 35 minutes and then attempts to log on to the Teradata Database.
  • If the first logon attempt fails, then the SLEEP time is adjusted to 25 minutes so that the total SLEEP time does not exceed the TENACITY time.
  • Command Placement

    Command placement affects the logon operation. State the SLEEP and TENACITY commands before the LOGON command in the Teradata FastLoad job script. Teradata FastLoad terminates with an error message if these commands are stated after the LOGON command.

    Command Overrides

    The SLEEP and TENACITY command specifications override the corresponding SLEEP and TENACITY specifications that may be made in the Teradata FastLoad configuration file.

    Similarly, the SLEEP and TENACITY command specifications themselves are overridden by the corresponding specifications made as runtime parameters when invoking Teradata FastLoad.

    The order of preferences for the SLEEP and TENACITY specifications, from highest to lowest, is:

    1 Runtime parameters

    2 Teradata FastLoad script commands

    3 Teradata FastLoad configuration file specifications

    4 Teradata FastLoad default values

    TENACITY

    Purpose  

    The TENACITY command specifies the number of hours that Teradata FastLoad continues trying to log on when the maximum number of load operations is already running on the Teradata Database.

    Syntax  

    where:

     

    Syntax Element

    Description

    hours

    Number of hours that Teradata FastLoad continues trying to log on.

    The hours specification must be greater than zero. If zero is entered, Teradata FastLoad responds with an error message and terminates.

    Usage Notes  

    Table 52 describes the things to consider when using the TENACITY command.

     

    Table 52: Usage Notes for TENACITY 

    Topic

    Usage Notes

    Function

    The TENACITY specification works with the SLEEP specification to control Teradata FastLoad logon attempts.

    When Teradata FastLoad tries to log on for a new session, and the Teradata Database indicates that the maximum number of load sessions is already running, Teradata FastLoad:

    1 Logs off any new sessions that were logged on

    2 Waits for 6 minutes, by default, or for the amount of time specified by the SLEEP command

    3 Tries again to log on to the Teradata Database

    Teradata FastLoad repeats this process until it has either logged on for the required number of sessions or exceeded the amount of time specified by the TENACITY command.

    For more information on how the TENACITY command interacts with the SLEEP command, please see Table 51 on page 164.

    Note: The utility default for TENACITY is no tenacity. A Teradata FastLoad configuration file entry, the runtime parameter, or a TENACITY command must be used in the Teradata FastLoad job script to enable the tenacity feature for the Teradata FastLoad logon operation.

    Command Placement

    Command placement affects the logon operation. State the TENACITY and SLEEP commands before the LOGON command in the Teradata FastLoad job script. Teradata FastLoad terminates with an error message if the Teradata FastLoad job script states the TENACITY or SLEEP command after the LOGON command.

    Command Overrides

    The TENACITY and SLEEP command specifications override the corresponding TENACITY and SLEEP specifications that may be made in the Teradata FastLoad configuration file.

    Similarly, the TENACITY and SLEEP command specifications themselves are overridden by the corresponding specifications made as runtime parameters when invoking Teradata FastLoad.

    The order of preferences for the TENACITY and SLEEP specifications, from highest to lowest, is:

    1 Runtime parameters

    2 Teradata FastLoad script commands

    3 Teradata FastLoad configuration file specifications

    4 Teradata FastLoad default values