Specifying Multiple Parameters - MultiLoad

Teradata® MultiLoad Reference

Product
MultiLoad
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-18
dita:mapPath
aim1544831946660.ditamap
dita:ditavalPath
gyk1507317446489.ditaval
dita:id
B035-2409
lifecycle
previous
Product Category
Teradata Tools and Utilities

Sample Command

mload -c ascii -b < samplescript

Sample Output

**** 11:52:21 UTY2407 Run time parameters in effect are: ASCII.
**** 11:52:21 UTY2414 BRIEF option is enabled.
      ========================================================================
      =             MultiLoad Utility Release MLOD.17.00.00.00               =
      =             Platform WIN 64-bit                                      =
      =             PID 6524                                                 =
      ========================================================================
      = Copyright 1990-2019 Teradata Corporation. ALL RIGHTS RESERVED.       =
      ========================================================================
****   11:52:21 UTY2411 Processing start date: WED APR 17, 2019
      ========================================================================
      =                Logon/Connection                                      =
      ========================================================================
0001 .LOGTABLE SAMPLESCRIPT_LOG;
0002 .LOGON NODEID/FLUSER,;
**** 11:52:23 UTY8400 Teradata Database Release: 17.00.00.00
**** 11:52:23 UTY8400 Teradata Database Version: 17.00.00.00
**** 11:52:23 UTY8601 Character set specified: ASCII
**** 11:52:23 UTY8400 Current RDBMS has interval support
**** 11:52:23 UTY8400 Current RDBMS has UDT support
**** 11:52:23 UTY8400 Current RDBMS has Large Decimal support
**** 11:52:23 UTY8400 Current RDBMS has TASM support
**** 11:52:23 UTY8400 Maximum supported buffer size: 1M
**** 11:52:23 UTY8400 Data Encryption supported by RDBMS server
**** 11:52:24 UTY6211 A successful connect was made to the RDBMS.
**** 11:52:24 UTY6217 Logtable 'FLUSER.SAMPLESCRIPT_LOG' has been created.

0003 DROP TABLE WT_ML0020;
**** 11:52:25 UTY1008 RDBMS failure: 3807, Object 'WT_ML0020' does not exist.
0004 DROP TABLE ET_ML0020;
**** 11:52:26 UTY1008 RDBMS failure: 3807, Object 'ET_ML0020' does not exist.
0005 DROP TABLE UV_ML0020;
**** 11:52:32 UTY1008 RDBMS failure: 3807, Object 'UV_ML0020' does not exist.
0006 DROP TABLE ML0020;

**** 11:52:33 UTY1016 'DROP' request successful.
0007 CREATE TABLE ML0020,FALLBACK(
               F1 INTEGER,
               F2 BYTEINT,
               F3 SMALLINT,
               F4 INTEGER,
               F5 BIGINT,
               F6 DECIMAL(9,2),
               F7 FLOAT)
              primary index(F1);
**** 11:52:34 UTY1016 'CREATE' request successful.

0008 .BEGIN IMPORT MLOAD TABLES ML0020 SESSIONS 4;
     ========================================================================
     =              Processing MultiLoad Statements                         =
     ========================================================================
0009 .LAYOUT LAY1A;
0010 .FIELD FF1 * INTEGER;
0011 .FIELD FF2 * FLOAT;
0012 .FIELD FF3 * FLOAT;
0013 .FIELD FF4 * FLOAT;
0014 .FIELD FF5 * FLOAT;
0015 .FIELD FF6 * FLOAT;
0016 .FIELD FF7 * FLOAT;

0017 .DML LABEL LABELA;
0018 INSERT INTO ML0020 VALUES(:FF1,:FF2,:FF3,:FF4,:FF5,:FF6,:FF7);

0019 .IMPORT INFILE INDAT94
             LAYOUT LAY1A
             APPLY LABELA;
0020 .END MLOAD;
     ========================================================================
     =                     MultiLoad Initial Phase                          =
     ========================================================================
**** 11:52:34 UTY0829 Options in effect for this MultiLoad import task:
     . Sessions:      4 session(s).
     . Checkpoint:    15 minute(s).
     . Tenacity:      4 hour limit to successfully connect load sessions.
     . Errlimit:      No limit in effect.
     . AmpCheck:      In effect for apply phase transitions.
***  11:52:40 UTY0812 MLOAD session(s) requested: 4.
**** 11:52:40 UTY0815 MLOAD session(s) connected: 4.
     ========================================================================
     =                     MultiLoad Acquisition Phase                      =
     ========================================================================
**** 11:52:47 UTY0826 A checkpoint has been taken, recording that end of file
      has been reached for IMPORT 1 of this MultiLoad Import task.
**** 11:52:49 UTY1803 Import processing statistics
     .                                      IMPORT 1 Total thus far
     .                                      ========= ==============
     Candidate records considered:........          5....... 5
     Apply conditions satisfied:..........          5....... 5
     Candidate records not applied:.......          0....... 0
     Candidate records rejected:..........          0....... 0
**** 11:52:49 UTY1821 Aquisition Phase statistics
     Elapsed time: 00:00:06
     CPU time: 0 Seconds
     MB/sec: 4.33333e-005
     MB/cpusec: N/A
     ========================================================================
     =              MultiLoad Application Phase                             =
     ========================================================================
**** 11:52:53 UTY0818 Statistics for table ML0020:
     Inserts: 5
     Updates: 0
     Deletes: 0
**** 11:52:53 UTY1822 Application Phase statistics
     Elapsed time: 00:00:01
     ========================================================================
     =                 MultiLoad Task Cleanup                              =
     ========================================================================
**** 11:52:55 UTY0821 Error table ET_ML0020 is EMPTY, dropping table.
**** 11:52:57 UTY0821 Error table UV_ML0020 is EMPTY, dropping table.
**** 11:52:58 UTY0825 Error table statistics for:
     Target table 1: ML0020
     Number of Rows           Error Table Name
     ==================== ==================================================
                       0 ET_ML0020
                       0 UV_ML0020
**** 11:53:01 UTY0822 MultiLoad processing complete for this MultiLoad import
     task.
     ========================================================================
     =                 MultiLoad Task Complete                              =
     ========================================================================
**** 11:53:03 UTY1024 Session modal request, 'SET
      QUERY_BAND='UTILITYNAME=MULTLOAD;' UPDATE FOR SESSION;', re-executed.
0021 .LOGOFF;
      ========================================================================
      =                      Logoff/Disconnect                               =
      ========================================================================
**** 11:53:03 UTY6216 The restart log table has been dropped.
**** 11:53:03 UTY6212 A successful disconnect was made from the RDBMS.
**** 11:53:03 UTY2410 Total processor time used = '0.71875 Seconds'
     . Start    : 11:52:21 - WED APR 17, 2019
     . End      : 11:53:03 - WED APR 17, 2019
     . Highest return code encountered = '0'.