縮小プリント出力(-b)パラメータの使用 - MultiLoad

Teradata® MultiLoadリファレンス

Product
MultiLoad
Release Number
17.10
Published
2021年6月
Language
日本語
Last Update
2021-09-23
dita:mapPath
ja-JP/fel1608578437279.ditamap
dita:ditavalPath
ja-JP/fel1608578437279.ditaval
dita:id
B035-2409
Product Category
Teradata Tools and Utilities

サンプル コマンド:

mload -b < samplescript

サンプル出力

**** 17:45:59 UTY2414 BRIEF option is enabled.
     ====================================================================
     =         MultiLoad Utility Release MLOD.17.10.00.02               =
     =         Platform WIN 64-bit                                      =
     =         PID 12360                                                =
     ====================================================================
     = Copyright 1990-2021 Teradata Corporation. ALL RIGHTS RESERVED.   =
     ====================================================================
     **** 17:45:59 UTY2411 Processing start date: WED APR 17, 2021
     ====================================================================
     =        Logon/Connection                                          =
     ====================================================================
0001 .LOGTABLE ML0020_LOG;
0002 .LOGON NODEID/fluser,;
**** 17:46:01 UTY8400 Teradata Database Release: 17.10.00.00
**** 17:46:01 UTY8400 Teradata Database Version: 17.10.00.00
**** 17:46:01 UTY8400 Default character set: ASCII
**** 17:46:01 UTY8400 Current RDBMS has interval support
**** 17:46:01 UTY8400 Current RDBMS has UDT support
**** 17:46:01 UTY8400 Current RDBMS has Large Decimal support
**** 17:46:01 UTY8400 Current RDBMS has TASM support
**** 17:46:01 UTY8400 Maximum supported buffer size: 1M
**** 17:46:01 UTY8400 Data Encryption supported by RDBMS server
**** 17:46:02 UTY6211 A successful connect was made to the RDBMS.
**** 17:46:02 UTY6217 Logtable 'FLUSER.ML0020_LOG' has been created.

0003 DROP TABLE WT_ML0020;
**** 17:46:03 UTY1008 RDBMS failure: 3807, Object 'WT_ML0020' does not exist.
0004 DROP TABLE ET_ML0020;
**** 17:46:04 UTY1008 RDBMS failure: 3807, Object 'ET_ML0020' does not exist.
0005 DROP TABLE UV_ML0020;
**** 17:46:05 UTY1008 RDBMS failure: 3807, Object 'UV_ML0020' does not exist.
0006 DROP TABLE ML0020;
**** 17:46:06 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);
**** 17:46:07 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                                   =
      ====================================================================
**** 17:46:07 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.
**** 17:46:13 UTY0812 MLOAD session(s) requested: 4.
**** 17:46:13 UTY0815 MLOAD session(s) connected: 4.
     ====================================================================
     =        MultiLoad Acquisition Phase                               =
	 ====================================================================
**** 17:46:20 UTY0826 A checkpoint has been taken, recording that end of file
     has been reached for IMPORT 1 of this MultiLoad Import task.
**** 17:46:21 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
**** 17:46:22 UTY1821 Aquisition Phase statistics
     Elapsed time: 00:00:07
     CPU time: 0 Seconds
     MB/sec: 3.71429e-005
     MB/cpusec: N/A	 
     ====================================================================
     =             MultiLoad Application Phase                          =
     ====================================================================
**** 17:46:25 UTY0818 Statistics for table ML0020:
        Inserts: 5
        Updates: 0
        Deletes: 0
**** 17:46:25 UTY1822 Application Phase statistics
      Elapsed time: 00:00:00
     ====================================================================
     =                MultiLoad Task Cleanup                            =
     ====================================================================
**** 17:46:27 UTY0821 Error table ET_ML0020 is EMPTY, dropping table.
**** 17:46:29 UTY0821 Error table UV_ML0020 is EMPTY, dropping table.
**** 17:46:31 UTY0825 Error table statistics for:

     Target table 1: ML0020
     Number of Rows        Error Table Name
     ==================== ==================================================
                       0 ET_ML0020
                       0 UV_ML0020
					   
**** 17:46:33 UTY0822 MultiLoad processing complete for this MultiLoad import
     task.
     ====================================================================
     =               MultiLoad Task Complete                            =
     ====================================================================
**** 17:46:35 UTY1024 Session modal request, 'SET
     QUERY_BAND='UTILITYNAME=MULTLOAD;' UPDATE FOR SESSION;', re-executed.
0021 .LOGOFF;
     ====================================================================
     =              Logoff/Disconnect                                   =
     ====================================================================
**** 17:46:35 UTY6216 The restart log table has been dropped.
**** 17:46:35 UTY6212 A successful disconnect was made from the RDBMS.
**** 17:46:35 UTY2410 Total processor time used = '0.5 Seconds'
     .       Start : 17:45:59 - WED APR 17, 2021
     .       End : 17:46:35 - WED APR 17, 2021
     .       Highest return code encountered = '0'.