Stack Overflow
Stack Overflow

Questions tagged [mload]

Teradata MultiLoad (MLoad) Utility to Load Initial-State Data

Teradata MultiLoad (MLoad) utility to process and load initial-state data into a Teradata database. The MLoad utility can only be used with the Event Replicator Target Adapter to load initial-state data; it cannot be used for transactional data. It can load UTF8 data.

Note:

The MLoad utility is supported in Windows environments only. In addition, composite keys are not supported when using the MLoad utility with Event Replicator Target Adapter.

22 questions
0
votes
0 answers

Insert select working and mload failing

I am facing one issue where I am able to insert into a table using normal insert select. However, when i am using the multiload to load the same table the records goes into the error table with the Error 6706: Untranslatable character error. The…
user3901666
  • 399
  • 11
  • 29
0
votes
2 answers

How to hide Logon Password in Teradata MLoad Script

I have written a Multiload script to Load Data in TeraData Database and the commands in the script is like: .LOGTABLE Employee_log; .LOGON 192.168.1.1/dbc,dbc; .BEGIN MLOAD TABLES Employee_Stg; .LAYOUT Employee; .FIELD in_EmployeeNo *…
Jay
  • 111
  • 1
  • 4
  • 13
0
votes
2 answers

MLOAD ERROR CODE 4 IN TERADATA

I am getting this error in production environment. I want to know the exact cause of this error. Can you please help me when we get this error in teradata mload utilities. This is what i got when i searched for this error message. 4:- When there is…
Vicky
  • 1,215
  • 6
  • 22
  • 45
0
votes
0 answers

Teradata Multi load Not Proceed

mload step .LOGTABLE truser2.logtable; .LOGON 127.0.0.1/truser2,trpass2; .begin import mload tables coldata_test WORKTABLES wt_test1 ERRORTABLES wt_test1 uv_test1 ERRLIMIT 1000 CHECKPOINT 100000 AMPCHECK NONE; .layout test_layout; .field col01 *…
koreaKim
  • 21
  • 3
0
votes
2 answers

automatic release mload in teradata

We are implementing data warehouse in teradata and has our stage process to load data from source to teradata using mload utility. Problem we are having is if due to some reason mload was active on the table session fail to load data. Then 99% we go…
user863952
  • 103
  • 2
  • 5
  • 15
0
votes
1 answer

How to reset mload after job?

I am running an mload script on a table that is cleared at the beginning of a job. When the script fails, the error and log tables prevent the job from running a second time. How does one reset mload cleanly after a failure?
sakurashinken
  • 3,940
  • 8
  • 34
  • 67
0
votes
1 answer

What's causing my MLOAD job to fail on Windows Server 2003 when it works on Windows 7 x64 Professional?

I created an MLOAD job using OleLoad on my Windows 7 x64 Professional machine. It loads data from Oracle 11g into Teradata 14. Everything works great when I run it locally. When I copy it to a remote Windows Server 2003 SP2 machine and run it, it…
oscilatingcretin
  • 10,457
  • 39
  • 119
  • 206
1
2