17.10 - First Output File - FastLoad

Teradata® FastLoad Reference

Product
FastLoad
Release Number
17.10
Published
June 2021
Last Update
2021-07-01
Content Type
Programming Reference
Publication ID
B035-2411-061K
Language
English (United States)
      ===================================================================
      =                                                                 =
      =             FASTLOAD UTILITY VERSION 17.10.00.02                =
      =             PLATFORM LINUX 64-bit                               =
      =             PID 17433                                           =
      =                                                                 =
      ===================================================================
      ===================================================================
      =                                                                 =
      =            Copyright 1984-2021, Teradata Corporation.           =
      =            ALL RIGHTS RESERVED.                                 =
      =                                                                 =
      ===================================================================
**** 02:50:02 Processing starting at: Wed Apr 17 02:50:02 2021
      ===================================================================
     =                                                                 =
     =            Logon/Connection                                     =
     =                                                                 =
     ===================================================================
0001 .LOGON NODEID/fluser,

**** 02:50:02 Teradata Database Release: 17.10.00.00
**** 02:50:02 Teradata Database Version: 17.10.00.00
**** 02:50:02 Number of AMPs available: 4
**** 02:50:02 Current CLI or RDBMS allows maximum row size: 64K
**** 02:50:02 Character set for this job: ASCII

0002 DROP TABLE FL0161e1;

**** 02:50:02 RDBMS error 3807: Object 'FL0161e1' does not exist.

0003 DROP TABLE FL0161e2;

**** 02:50:02 RDBMS error 3807: Object 'FL0161e2' does not exist.

0004 DROP TABLE FL0161;

**** 02:50:03 Command completed successfully

0005 CREATE TABLE FL0161, FALLBACK(
        c1 integer,
        c2 char(10),
        c3 varchar(3))
     UNIQUE PRIMARY INDEX (c1);
	 
**** 02:50:03 Command completed successfully

0006 BEGIN LOADING FL0161 ERRORFILES FL0161e1,FL0161e2;

**** 02:50:03 Session count 4 returned by the DBS overrides
              user-requested session count
**** 02:50:04 Number of FastLoad sessions connected = 4
**** 02:50:04 FDL4808 LOGON successful
**** 02:50:04 Number of AMPs available: 4
**** 02:50:04 BEGIN LOADING COMPLETE

0007 DEFINE c1 (integer), c2 (char(10)), c3 (varchar(3)) FILE=INDAT24;

**** 02:50:04 FDL4803 DEFINE statement processed

0008 SHOW;

FILE = INDAT24
C1                              OFFSET = 0  LEN = 4 INTEGER
C2                              OFFSET = 4  LEN = 10 CHAR
C3                              OFFSET = 14 LEN = 3 VARCHAR
TOTAL RECORD LENGTH = 19
      ===================================================================
      =                                                                 =
      =                    Insert Phase                                 =
      =                                                                 =
      ===================================================================
0009 INSERT INTO FL0161 (c1,c2,c3) VALUES (:c1,:c2,:c3);
**** 02:50:04 Number of recs/msg: 2920
**** 02:50:04 Starting to send to RDBMS with record 1
**** 02:50:04 Sending row 9
**** 02:50:04 Finished sending rows to the RDBMS

**** 02:50:04 Acquisition Phase statistics:
              Elapsed time: 00:00:00 (in hh:mm:ss)
              CPU time: 0 Seconds
              MB/sec: N/A
              MB/cpusec: N/A
			  
0010 LOGOFF;
     ===================================================================
     =                                                                 =
     =             Logoff/Disconnect                                   =
     =                                                                 =
     ===================================================================
**** 02:50:04 Logging off all sessions
**** 02:50:04 Total processor time used = '0.94 Seconds'
     .        Start :  Wed Apr 17 02:50:02 2021
     .        End   :  Wed Apr 17 02:50:04 2021
     .        Highest return code encountered = '4'.
**** 02:50:04 FastLoad Paused