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
2
votes
1 answer

Is MLOAD executed in a single transaction?

I have an MLOAD job that inserts data from an Oracle database into a Teradata database. One of the things it does it drop the destination table and recreate it. Our production website populates a dropdown list based on what's in the destination…
oscilatingcretin
  • 10,457
  • 39
  • 119
  • 206
1
vote
1 answer

uty4014 access module error 35 received during 'comm_pmreadddparse' operation:

I'm new to mload. I get this error when I try to execute my mload script: uty4014 access module error 35 received during 'comm_pmreadddparse' operation:'Unable to determine EOR for the datafile !ERROR! Could not find a valid EOR'. Also…
Phantom
  • 31
  • 2
  • 7
1
vote
0 answers

Teradata Mload Error : UTY4014 Access module error '42' received during 'get position' operation

I hope some one can help me with the following problem. While loading a file through MLoad I am getting the below error 'Unable to obtain data signature Quoted data- Column missing close quote !ERROR! No corresponding close quote for open quote was…
ITIB
  • 353
  • 6
  • 16
1
vote
1 answer

Run a Teradata MLOAD command in Windows command prompt, but use Python to trigger it

I used to execute the MLOAD process by opening a command prompt and then typing MLOAD < MLOAD_FILE.txt. How do I do it using Python? Assume that the MLOAD_FILE.txt is under directory C:\\Users\\MLOAD_FILES. Thanks!
DanZimmerman
  • 1,626
  • 6
  • 23
  • 45
1
vote
2 answers

teradata export query using cmd windows not working

new post : i already read tutorial and i found this script .LOGMECH LDAP; .LOGON xx.xx.xx.xx/username,password; .LOGTABLE dbname.LOG_tablename; DATABASE dbname; .BEGIN EXPORT SESSIONS 2; .EXPORT OUTFILE D:\test.txt MODE RECORD format text; select…
JohnDoeLearning
  • 23
  • 4
0
votes
0 answers

Space between each character in Teradata mLoad target table

I am loading a flat file into Teradata target table. Example flat file: Employee_ID, Employee_First_Name, Employee_Salary 1,Jay,50000 2,Sam,60000 3,Tom,70000 The result of the mload looks as such in the Teradata target table. 1 , J a y , 5 0 0 0 0…
Jordan Sabo
  • 1
  • 1
0
votes
1 answer

Teradata Error 2679 when loading text file into table using MLoad

I have a problem with loading my data into teradata table using MLoad. I have a text file with a data which is an output from SQL…
neekitit
  • 61
  • 6
0
votes
0 answers

6706: Untranslatable Characters in Teradata

I have following 2 strings consisting of Arabic characters, such strings fails' my mloads on daily basis: شركة جيبكا السعودية ح717695 Both columns in which these 2 strings are inserted are defined as Unicode. And in case of these string…
Burhan Khalid Butt
  • 275
  • 1
  • 7
  • 20
0
votes
0 answers

Teradata mutliload CSV source file load issue

I have a comma separated CSV file that needs to be loaded into Teradata Table. Usually fastload is very useful in such scenarios when there is a single file which needs to be loaded into a single table. The issue here is that the data fields in CSV…
nofel
  • 1
  • 1
  • 3
0
votes
0 answers

Can we use multiple delimiter in Mload teradata?

I have a file where I have multiple delimiters. I want to split based on delimeters and load it into a table in teradata. Please see below…
Thiyagu
  • 85
  • 1
  • 12
0
votes
0 answers

How to hide logon password in Teradata Mload Log file?

I just wanted to hide password in teradata mload script. So I encrypted the password and tried to logon like that... .Accept id_pwd From Env var IdPwdStr // Decrypted string .Logon &id_pwd; It worked okay. But the password was not hide in the log…
jandbond
  • 11
  • 5
0
votes
1 answer

How to load plain text file in teradata varbyte column using multiload utility?

I have plain text (test.txt) file as…
TheBeginner
  • 405
  • 5
  • 23
0
votes
1 answer

How to use Import Utilities like Fastload or MLOAD in Teradata, if the target table has Referential Integrity?

I'm new to Teradata, started exploring a few weeks back. I know Fastload or Multiload utilities will work only if there is no Referential Integrity on the tables, like Foreign key relationship. I wanted to know, what if my table actually has a…
Gowtham Vakani
  • 358
  • 3
  • 10
0
votes
0 answers

Disable logs in MultiLoad and FastExport - Teradata

I'm working with a script in python that will first create mload or fastexport files depending on parameters and then within the script I start those files to insert/export data. result = subprocess.run(["{0} < {1}".format(file_type,…
Aleksander Lipka
  • 354
  • 1
  • 9
  • 20
0
votes
0 answers

Getting error while running my mload script

I have been getting this error when i tried to run my mload script. "Mload: Command not found". I tried to run manually from command line. Command used : mload < filename.txt.
Phantom
  • 31
  • 2
  • 7
1
2