Logfile in MLOAD

Tools & Utilities
KM
Enthusiast

Logfile in MLOAD

Hi could someone please tell me, how to specify the LOG file in MLOAD , simillar to SQL*Loader in Oracle .
Your help will be highly appreciated .
1 REPLY

Re: Logfile in MLOAD

You can use the log table in mload as below..

.RUN FILE LOGON or (LOGON TDP/username, ;-)
.LOGTABLE Database1.Table1;
.BEGIN IMPORT MLOAD
TABLES &DB_NAME..&TBL_NAME
WORKTABLES &DB_NAME..WT_&TBL_NAME
ERRORTABLES &DB_NAME..ET_&TBL_NAME
&DB_NAME..UV_&TBL_NAME
ERRLIMIT &ERRLIM
CHECKPOINT &CHCKPNT
SESSIONS &SESSNS
TENACITY &TNCTY
SLEEP &SLP
AMPCHECK ALL;
.....