Nine Stars

tTeradataMultiLoad - 'mload' is not recognized

When I attempt to use tTeradataMultiLoad to load data to a Teradata table, the error log says:
'mload' is not recognized as an internal or external command, operable program or batch file.
2 REPLIES
Community Manager

Re: tTeradataMultiLoad - 'mload' is not recognized

Hi 
Before to use load & unload utilities, you are required to install Teradata client tool and add the <Teradata client tool installation path>/bin/ path to the system variable PATH.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
Nine Stars

Re: tTeradataMultiLoad - 'mload' is not recognized

Hi Shong,
Are you talking about the Windows System Environment Variables?
In the Path variable value, I now have:
C:\Program Files\Teradata\client\15.00\Teradata Parallel Transporter\bin64
C:\Program Files\Teradata\client\15.00\Teradata Parallel Transporter\msg64
C:\Program Files (x86)\Teradata\client\15.00\Teradata Parallel Transporter\bin
C:\Program Files (x86)\Teradata\client\15.00\Teradata Parallel Transporter\msg
C:\Program Files\Teradata\Client\15.00\bin\
C:\Program Files (x86)\Teradata\Client\15.00\bin\
C:\Program Files\Teradata\Client\15.10\bin
C:\Program Files (x86)\Teradata\Client\15.10\bin

This is what I now have installed on my machine:
Version                 Display Name
--------------------------------------------------------------------------------------------------------------------
14.11.0.1               .NET Data Provider for Teradata 14.11.0.1
15.00.00.00           Teradata Administrator 15.00
15.00.00.00           Teradata BTEQ 15.00
15.00.00.00           Teradata Data Connector 15.00
15.00.00.00           Teradata Data Connector nt-x8664 15.00
15.00.00.00           Teradata FastExport 15.00
15.00.00.00           Teradata FastLoad 15.00
15.00.00.00           Teradata GSS Client nt-i386  15.0
15.00.00.00           Teradata GSS Client nt-x8664  15.0
15.00.00.00           Teradata GeoSpatial Tool 15.00
15.00.00.00           Teradata GeoSpatial Tool nt-x8664 15.00
15.00.00.00           Teradata MultiLoad 15.00
15.00.00.00           Teradata Parallel Transporter Base 15.00
15.00.00.00           Teradata Parallel Transporter Base nt-x8664 15.00
15.00.00.00           Teradata Parallel Transporter Stream 15.00
15.00.00.00           Teradata Parallel Transporter Stream nt-x8664 15.00
15.00.00.00           Teradata SQL Assistant 15.00
15.00.00.00           Teradata TPump 15.00
15.00.00.00           Teradata Tools and Utilities - Base 15.00.00
15.00.00.00           Teradata Wallet 15.00
15.00.00.00           Teradata Wallet nt-x8664 15.00
15.00.00.01           Teradata CLIv2 15.00.0.1
15.00.00.01           Teradata CLIv2 nt-x8664 15.00.0.1
15.10.00.00           ODBC Driver for Teradata 15.10
15.10.00.00           ODBC Driver for Teradata nt-x8664 15.10
15.10.00.00           Shared ICU Libraries for Teradata 15.10
15.10.00.00           Shared ICU Libraries for Teradata nt-x8664 15.10
15.10.00.00           Teradata GSS Client nt-i386  15.10
15.10.00.00           Teradata GSS Client nt-x8664  15.10
15.10.01.00           ODBC Driver for Teradata - Suite 15.10.01

According to feinholz I should be using TPT instead?
https://forums.teradata.com/forum/tools/mload-utility