Sample Command
mload -b < samplescript
Sample Output
**** 17:46:03 UTY2414 BRIEF option is enabled.
========================================================================
= MultiLoad Utility Release MLOD.20.00.00.01 =
= Platform WIN 64-bit =
= =
= MultiLoad Utility is DEPRECATED. =
= It is provided to run existing workloads created =
= prior to 07-SEP-2023. =
= Please use Teradata Parallel Transporter for =
= workloads. =
========================================================================
= Copyright 1990-2023 Teradata. All rights reserved. =
========================================================================
**** 17:46:03 UTY2411 Processing start date: SUN SEP 10, 2023
========================================================================
= Logon/Connection =
========================================================================
0001 .LOGTABLE ML0020_LOG;
0002 .LOGON NODEID/mlntuser,
**** 17:46:03 UTY8400 Teradata Database Release: 20.00.00.00
**** 17:46:03 UTY8400 Teradata Database Version: 20.00.00.00
**** 17:46:03 UTY8400 Default character set: ASCII
**** 17:46:03 UTY8400 Current RDBMS has interval support
**** 17:46:03 UTY8400 Current RDBMS has UDT support
**** 17:46:03 UTY8400 Current RDBMS has Large Decimal support
**** 17:46:03 UTY8400 Current RDBMS has TASM support
**** 00:13:39 UTY8400 Maximum supported buffer size: 1M
**** 17:46:03 UTY8400 Data Encryption supported by RDBMS server
**** 17:46:03 UTY6211 A successful connect was made to the RDBMS.
**** 17:46:03 UTY6217 Logtable 'MLNTUSER.ML0020_LOG' has been created.
0003 DROP TABLE WT_ML0020;
**** 00:13:40 UTY1008 RDBMS failure: 3807, Object 'WT_ML0020' does not exist.
0004 DROP TABLE ET_ML0020;
**** 00:13:40 UTY1008 RDBMS failure: 3807, Object 'ET_ML0020' does not exist.
0005 DROP TABLE UV_ML0020;
**** 00:13:40 UTY1008 RDBMS failure: 3807, Object 'UV_ML0020' does not exist.
0006 DROP TABLE ML0020;
**** 00:13:40 UTY1008 RDBMS failure: 3807, Object 'ML0020' does not exist.
0007 CREATE TABLE ML0020,FALLBACK(
F1 INTEGER,
F2 BYTEINT,
F3 SMALLINT,
F4 INTEGER,
F5 BIGINT,
F6 DECIMAL(9,2),
F7 FLOAT)
primary index(F1);
**** 00:13:40 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 =
========================================================================
**** 00:13:40 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.
**** 00:13:40 UTY0812 MLOAD session(s) requested: 4.
**** 00:13:40 UTY0815 MLOAD session(s) connected: 4.
========================================================================
= MultiLoad Acquisition Phase =
========================================================================
**** 00:13:44 UTY0826 A checkpoint has been taken, recording that end of file
has been reached for IMPORT 1 of this MultiLoad Import task.
**** 00:13:45 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
**** 00:13:45 UTY1821 Aquisition Phase statistics
Elapsed time: 00:00:04
CPU time: 0 Seconds
MB/sec: 6.5e-05
MB/cpusec: N/A
========================================================================
= MultiLoad Application Phase =
========================================================================
**** 00:13:46 UTY0818 Statistics for table ML0020:
Inserts: 5
Updates: 0
Deletes: 0
**** 00:13:46 UTY1822 Application Phase statistics
Elapsed time: 00:00:00
========================================================================
= MultiLoad Task Cleanup =
========================================================================
**** 00:13:46 UTY0821 Error table ET_ML0020 is EMPTY, dropping table.
**** 00:13:46 UTY0821 Error table UV_ML0020 is EMPTY, dropping table.
**** 00:13:46 UTY0825 Error table statistics for:
Target table 1: ML0020
Number of Rows Error Table Name
==================== ==================================================
0 ET_ML0020
0 UV_ML0020
**** 00:13:47 UTY0822 MultiLoad processing complete for this MultiLoad import
task.
========================================================================
= MultiLoad Task Complete =
========================================================================
**** 00:13:47 UTY1024 Session modal request, 'SET
QUERY_BAND='UTILITYNAME=MULTLOAD;' UPDATE FOR SESSION;', re-executed.
0021 .LOGOFF;
========================================================================
= Logoff/Disconnect =
========================================================================
**** 00:13:47 UTY6216 The restart log table has been dropped.
**** 00:13:47 UTY6212 A successful disconnect was made from the RDBMS.
**** 00:13:47 UTY2410 Total processor time used = '0.078125 Seconds'
. Start : 00:13:39 - TUE AUG 08, 2023
. End : 00:13:47 - TUE AUG 08, 2023
. Highest return code encountered = '0'.