Using the Runfile (-r) Parameter
The typical option selection is:
mload -r '.RUN FILE mld.startup;' < infilename >outfilename
Sample Logon Contents:
.logtable mloadlog;
.logon kiowa/xx151,xx151;
Sample MLOAD Job:
drop table wt_foo;
drop table et_foo;
drop table uv_foo;
drop table foo;
create table foo (
f1 char(3),
f2 char(3),
f3 varchar(3)
)
;
.begin mload tables foo sessions 4;
.layout lay1;
.field f1 * char(3);
.field f2 * char(3);
.field f3 * varchar(3);
.dml label dml1;
insert foo (f1) values (:f1);
.import infile foo.data
layout lay1
apply dml1;
.end mload;
.logoff;
Sample Command:
$ mload -r ".run file logon;" < job.mload
Sample Output:
========================================================================
= =
= MultiLoad Utility Release MLOD.15.10.00.000 =
= Platform WIN32 =
= PID 22164 =
= =
========================================================================
= =
= Copyright 1990-2015 Teradata Corporation. ALL RIGHTS RESERVED. =
= =
========================================================================
**** 10:51:50 UTY2411 Processing start date: WED JAN 7, 2015
========================================================================
= =
= Logon/Connection =
= =
========================================================================
0001 .run file logon;
0002 .LOGTABLE ML0021_LOG;
0003 .LOGON NODEID/HEMANTHDB,;
**** 21:00:53 UTY8400 Teradata Database Release: 15.10.00.000
**** 21:00:53 UTY8400 Teradata Database Version: 15.10.00.000
**** 21:00:53 UTY8400 Default character set: ASCII
**** 21:00:53 UTY8400 Current RDBMS has interval support
**** 21:00:53 UTY8400 Current RDBMS has UDT support
**** 21:00:53 UTY8400 Current RDBMS has Large Decimal support
**** 21:00:53 UTY8400 Current RDBMS has TASM support
**** 21:00:53 UTY8400 Maximum supported buffer size: 1M
**** 21:00:53 UTY8400 Data Encryption supported by RDBMS server
**** 21:00:55 UTY6211 A successful connect was made to the RDBMS.
**** 21:00:55 UTY6210 Logtable 'HEMANTHDB.ML0021_LOG' indicates that a restart
is in progress.
========================================================================
= =
= Processing Control Statements =
= =
========================================================================
0004 DROP TABLE WT_ML0020;
**** 21:00:56 UTY1008 RDBMS failure: 3807, Object 'WT_ML0020' does not exist.
0005 DROP TABLE ET_ML0020;
**** 21:00:57 UTY1008 RDBMS failure: 3807, Object 'ET_ML0020' does not exist.
0006 DROP TABLE UV_ML0020;
**** 21:00:58 UTY1008 RDBMS failure: 3807, Object 'UV_ML0020' does not exist.
0007 DROP TABLE ML0020;
**** 21:00:59 UTY1016 'DROP' request successful.
0008 CREATE TABLE ML0020,FALLBACK(
F1 INTEGER,
F2 BYTEINT,
F3 SMALLINT,
F4 INTEGER,
F5 BIGINT,
F6 DECIMAL(9,2),
F7 FLOAT)
primary index(F1);
**** 21:01:00 UTY1016 'CREATE' request successful.
0009 .BEGIN IMPORT MLOAD TABLES ML0020 SESSIONS 4;
========================================================================
= =
= Processing MultiLoad Statements =
= =
========================================================================
0010 .LAYOUT LAY1A;
0011 .FIELD FF1 * INTEGER;
0012 .FIELD FF2 * FLOAT;
0013 .FIELD FF3 * FLOAT;
0014 .FIELD FF4 * FLOAT;
0015 .FIELD FF5 * FLOAT;
0016 .FIELD FF6 * FLOAT;
0017 .FIELD FF7 * FLOAT;
0018 .DML LABEL LABELA;
0019 INSERT INTO ML0020 VALUES(:FF1,:FF2,:FF3,:FF4,:FF5,:FF6,:FF7);
0020 .IMPORT INFILE INDAT94
LAYOUT LAY1A
APPLY LABELA;
0021 .END MLOAD;
========================================================================
= =
= MultiLoad Initial Phase =
= =
========================================================================
**** 21:01:00 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:01:00 UTY0817 MultiLoad submitting the following request:
Select NULL from HEMANTHDB.ML0021_LOG where (LogType = 125) and (Seq = 1)
and (MloadSeq = 0);
**** 21:01:01 UTY0817 MultiLoad submitting the following request:
Select NULL from HEMANTHDB.ML0021_LOG where (LogType = 120) and (Seq = 1);
**** 21:01:03 UTY0817 MultiLoad submitting the following request:
SET QUERY_BAND='UTILITYNAME=MULTLOAD;' UPDATE FOR SESSION;
**** 21:01:03 UTY0817 MultiLoad submitting the following request:
CHECK WORKLOAD FOR BEGIN MLOAD ML0020;
**** 21:01:03 UTY0817 MultiLoad submitting the following request:
CHECK WORKLOAD END;
**** 21:01:09 UTY0812 MLOAD session(s) requested: 4.
**** 21:01:09 UTY0815 MLOAD session(s) connected: 4.
**** 21:01:09 UTY0817 MultiLoad submitting the following request:
BEGIN MLOAD ML0020 WITH INTERVAL;
**** 21:01:09 UTY0817 MultiLoad submitting the following request:
INS HEMANTHDB.ML0021_LOG (LogType, Seq, MLoadSeq)VALUES(130, 1, 10);
**** 21:01:10 UTY0817 MultiLoad submitting the following request:
MLOAD ML0020 with WT_ML0020 errortables ET_ML0020, UV_ML0020;
========================================================================
= =
= MultiLoad DML Transaction Phase =
= =
========================================================================
**** 21:01:11 UTY0817 MultiLoad submitting the following request:
BT;
**** 21:01:11 UTY0817 MultiLoad submitting the following request:
USING FF1(INTEGER), FF2(FLOAT), FF3(FLOAT), FF4(FLOAT), FF5(FLOAT),
FF6(FLOAT), FF7(FLOAT) INSERT INTO ML0020
VALUES(:FF1,:FF2,:FF3,:FF4,:FF5,:FF6,:FF7);
**** 21:01:12 UTY0817 MultiLoad submitting the following request:
INS HEMANTHDB.ML0021_LOG (LogType, Seq, MLoadSeq)VALUES(130, 1, 20);
**** 21:01:12 UTY0817 MultiLoad submitting the following request:
ET;
========================================================================
= =
= MultiLoad Acquisition Phase =
= =
========================================================================
**** 21:01:12 UTY0817 MultiLoad submitting the following request:
BEGIN TRANSACTION;
**** 21:01:12 UTY0817 MultiLoad submitting the following request:
CHECKPOINT LOADING INTERVAL 0;
**** 21:01:13 UTY0817 MultiLoad submitting the following request:
CHECKPOINT LOADING INTERVAL 0;
**** 21:01:14 UTY0817 MultiLoad submitting the following request:
CHECKPOINT LOADING INTERVAL 0;
**** 21:01:15 UTY0817 MultiLoad submitting the following request:
USING Ckpt(VARBYTE(1024)) INSERT HEMANTHDB.ML0021_LOG (Logtype,
Seq, MLoadSeq, MLoadImpSeq, MLoadSrcSeq,
MiscInt1,MiscInt2,MiscInt3,MiscInt4,
MiscInt5,MiscInt6,MiscInt7,MiscInt8,CkptInterval,byteflag,MLoadCkpt)
VALUES (110, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, :Ckpt);
**** 21:01:16 UTY0817 MultiLoad submitting the following request:
CHECKPOINT LOADING INTERVAL 0;
**** 21:01:17 UTY0817 MultiLoad submitting the following request:
USING Ckpt(VARBYTE(1024)) INSERT HEMANTHDB.ML0021_LOG (Logtype,
Seq, MLoadSeq, MLoadImpSeq, MLoadSrcSeq,
MiscInt1,MiscInt2,MiscInt3,MiscInt4,
MiscInt5,MiscInt6,MiscInt7,MiscInt8,CkptInterval,byteflag,MLoadCkpt)
VALUES (110, 1, 1, 1, 0, 5, 5, 5, 5, 0, 0, 0, 0, 0, 1, :Ckpt);
**** 21:01:17 UTY0826 A checkpoint has been taken, recording that end of file
has been reached for IMPORT 1 of this MultiLoad Import task.
**** 21:01:17 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:01:17 UTY1821 Aquisition Phase statistics
Elapsed time: 00:00:05
CPU time: 0 Seconds
MB/sec: 5.2e-005
MB/cpusec: N/A
**** 21:01:17 UTY0817 MultiLoad submitting the following request:
CHECKPOINT LOADING INTERVAL 0;
**** 21:01:19 UTY0817 MultiLoad submitting the following request:
CHECKPOINT LOADING INTERVAL 0 END;
**** 21:01:20 UTY0817 MultiLoad submitting the following request:
INS HEMANTHDB.ML0021_LOG (LogType, Seq, MLoadSeq)VALUES(130, 1, 30);
**** 21:01:20 UTY0817 MultiLoad submitting the following request:
ET;
========================================================================
= =
= MultiLoad Application Phase =
= =
========================================================================
**** 21:01:21 UTY0817 MultiLoad submitting the following request:
EXEC MLOAD ML0020;
**** 21:01:21 UTY0818 Statistics for table ML0020:
Inserts: 5
Updates: 0
Deletes: 0
**** 21:01:21 UTY1822 Application Phase statistics
Elapsed time: 00:00:00
**** 21:01:21 UTY0817 MultiLoad submitting the following request:
INS HEMANTHDB.ML0021_LOG (LogType, Seq) VALUES (115, 1)
**** 21:01:22 UTY0817 MultiLoad submitting the following request:
BEGIN TRANSACTION;
**** 21:01:22 UTY0817 MultiLoad submitting the following request:
END MLOAD;
**** 21:01:22 UTY0817 MultiLoad submitting the following request:
INS HEMANTHDB.ML0021_LOG (LogType, Seq) VALUES (120, 1)
**** 21:01:22 UTY0817 MultiLoad submitting the following request:
USING Ckpt(VARBYTE(1024)) INS HEMANTHDB.ML0021_LOG (LogType, Seq,
MLoadCkpt)VALUES(135, 1, :Ckpt);
**** 21:01:23 UTY0817 MultiLoad submitting the following request:
END TRANSACTION;
========================================================================
= =
= MultiLoad Task Cleanup =
= =
========================================================================
**** 21:01:24 UTY0817 MultiLoad submitting the following request:
SELECT COUNT(*) FROM ET_ML0020;
**** 21:01:24 UTY0821 Error table ET_ML0020 is EMPTY, dropping table.
**** 21:01:24 UTY0817 MultiLoad submitting the following request:
BEGIN TRANSACTION;
**** 21:01:24 UTY0817 MultiLoad submitting the following request:
INS HEMANTHDB.ML0021_LOG (LogType, Seq, MLoadSeq)VALUES(125, 1, 1)
**** 21:01:25 UTY0817 MultiLoad submitting the following request:
DROP TABLE ET_ML0020;
**** 21:01:25 UTY0817 MultiLoad submitting the following request:
END TRANSACTION;
**** 21:01:25 UTY0817 MultiLoad submitting the following request:
SELECT COUNT(*) FROM UV_ML0020;
**** 21:01:26 UTY0821 Error table UV_ML0020 is EMPTY, dropping table.
**** 21:01:26 UTY0817 MultiLoad submitting the following request:
BEGIN TRANSACTION;
**** 21:01:26 UTY0817 MultiLoad submitting the following request:
INS HEMANTHDB.ML0021_LOG (LogType, Seq, MLoadSeq)VALUES(125, 1, 2)
**** 21:01:26 UTY0817 MultiLoad submitting the following request:
DROP TABLE UV_ML0020;
**** 21:01:27 UTY0817 MultiLoad submitting the following request:
END TRANSACTION;
**** 21:01:27 UTY0817 MultiLoad submitting the following request:
BEGIN TRANSACTION;
**** 21:01:27 UTY0817 MultiLoad submitting the following request:
INS HEMANTHDB.ML0021_LOG (LogType, Seq, MLoadSeq)VALUES(125, 1, 3)
**** 21:01:28 UTY0817 MultiLoad submitting the following request:
DROP TABLE WT_ML0020;
**** 21:01:28 UTY0817 MultiLoad submitting the following request:
END TRANSACTION;
**** 21:01:28 UTY0825 Error table statistics for:
Target table 1: ML0020
Number of Rows Error Table Name
============== ========================================================
0 ET_ML0020
0 UV_ML0020
**** 21:01:28 UTY0817 MultiLoad submitting the following request:
BEGIN TRANSACTION;
**** 21:01:28 UTY0817 MultiLoad submitting the following request:
USING Ckpt(VARBYTE(1024)) INS HEMANTHDB.ML0021_LOG (LogType, Seq,
MLoadCkpt)VALUES(140, 1, :Ckpt);
**** 21:01:29 UTY0817 MultiLoad submitting the following request:
INS HEMANTHDB.ML0021_LOG (LogType, Seq) VALUES (125, 1)
**** 21:01:29 UTY0817 MultiLoad submitting the following request:
END TRANSACTION;
**** 21:01:32 UTY0822 MultiLoad processing complete for this MultiLoad import
task.
========================================================================
= =
= MultiLoad Task Complete =
= =
========================================================================
**** 21:01:35 UTY1024 Session modal request, 'SET
QUERY_BAND='UTILITYNAME=MULTLOAD;' UPDATE FOR SESSION;', re-executed.
========================================================================
= =
= Processing Control Statements =
= =
========================================================================
0022 .LOGOFF;
========================================================================
= =
= Logoff/Disconnect =
= =
========================================================================
**** 21:01:35 UTY6216 The restart log table has been dropped.
**** 21:01:35 UTY6212 A successful disconnect was made from the RDBMS.
**** 21:01:35 UTY2410 Total processor time used = '0.499203 Seconds'
. Start : 21:00:48 - WED JAN 7, 2015
. End : 21:01:35 - WED JAN 7, 2015
. Highest return code encountered = '0'.