15.00 - Specifying Multiple Parameters - MultiLoad

Teradata MultiLoad Reference

prodname
MultiLoad
vrm_release
15.00
category
Programming Reference
featnum
B035-2409-034K

Specifying Multiple Parameters

Sample Command:

mload -c ascii -b < foo2

Sample Output:

**** 21:02:38 UTY2407 Run time parameters in effect are: ASCII.
**** 21:02:38 UTY2414 BRIEF option is enabled.
     ========================================================================
     =          MultiLoad Utility    Release MLOD.15.00.00.000              =
     =          Platform WIN32                                              =
     =          PID      19304                                              =
     ========================================================================
     =     Copyright 1990-2014 Teradata Corporation. ALL RIGHTS RESERVED.   =
     ========================================================================
**** 21:02:38 UTY2411 Processing start date: FRI JAN 10, 2014
     ========================================================================
     =          Logon/Connection                                            =
     ========================================================================
0001 .LOGTABLE ML0020_LOG;
0002 .LOGON NODEID/HEMANTHDB,;
**** 21:02:43 UTY8400 Teradata Database Release: 15.00.00.000
**** 21:02:43 UTY8400 Teradata Database Version: 15.00.00.000
**** 21:02:43 UTY8601 Character set specified: ASCII
**** 21:02:43 UTY8400 Current RDBMS has interval support
**** 21:02:43 UTY8400 Current RDBMS has UDT support
**** 21:02:43 UTY8400 Current RDBMS has Large Decimal support
**** 21:02:43 UTY8400 Current RDBMS has TASM support
**** 21:02:43 UTY8400 Maximum supported buffer size: 1M
**** 21:02:43 UTY8400 Data Encryption supported by RDBMS server
**** 21:02:45 UTY6211 A successful connect was made to the RDBMS.
**** 21:02:45 UTY6210 Logtable 'HEMANTHDB.ML0020_LOG' indicates that a restart
     is in progress.
 
0003 DROP TABLE WT_ML0020;
**** 21:02:46 UTY1008 RDBMS failure: 3807, Object 'WT_ML0020' does not exist.
0004 DROP TABLE ET_ML0020;
**** 21:02:47 UTY1008 RDBMS failure: 3807, Object 'ET_ML0020' does not exist.
0005 DROP TABLE UV_ML0020;
**** 21:02:48 UTY1008 RDBMS failure: 3807, Object 'UV_ML0020' does not exist.
0006 DROP TABLE ML0020;
**** 21:02:50 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);
**** 21:02:51 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                                     =
     ========================================================================
**** 21:02:51 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.
**** 21:02:59 UTY0812 MLOAD session(s) requested: 4.
**** 21:02:59 UTY0815 MLOAD session(s) connected: 4.
     ========================================================================
     =          MultiLoad Acquisition Phase                                 =
     ========================================================================
**** 21:03:06 UTY0826 A checkpoint has been taken, recording that end of file
     has been reached for IMPORT 1 of this MultiLoad Import task.
**** 21:03:06 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
**** 21:03:06 UTY1821 Aquisition Phase statistics
     Elapsed time:  00:00:05
     CPU time:      0 Seconds
     MB/sec:        5.2e-005
     MB/cpusec:     N/A
     ========================================================================
     =          MultiLoad Application Phase                                 =
     ========================================================================
**** 21:03:09 UTY0818 Statistics for table ML0020:
        Inserts:                    5
        Updates:                    0
        Deletes:                    0
**** 21:03:09 UTY1822 Application Phase statistics
     Elapsed time:  00:00:00
     ========================================================================
     =          MultiLoad Task Cleanup                                      =
     ========================================================================
**** 21:03:12 UTY0821 Error table ET_ML0020 is EMPTY, dropping table.
**** 21:03:14 UTY0821 Error table UV_ML0020 is EMPTY, dropping table.
**** 21:03:16 UTY0825 Error table statistics for:
 
     Target table 1: ML0020
     Number of Rows  Error Table Name
     ==============  ========================================================
                  0  ET_ML0020
                  0  UV_ML0020
 
**** 21:03:20 UTY0822 MultiLoad processing complete for this MultiLoad import
     task.
     ========================================================================
     =          MultiLoad Task Complete                                     =
     ========================================================================
**** 21:03:22 UTY1024 Session modal request, 'SET
     QUERY_BAND='UTILITYNAME=MULTLOAD;' UPDATE FOR SESSION;', re-executed.
 
0021 .LOGOFF;
     ========================================================================
     =          Logoff/Disconnect                                           =
     ========================================================================
**** 21:03:22 UTY6216 The restart log table has been dropped.
**** 21:03:22 UTY6212 A successful disconnect was made from the RDBMS.
**** 21:03:22 UTY2410 Total processor time used = '0.530403 Seconds'
     .       Start : 21:02:38 - FRI JAN 10, 2014
     .       End   : 21:03:22 - FRI JAN 10, 2014
     .       Highest return code encountered = '0'.