Reading uesr id and password from a file -- MLOAD

Tools & Utilities
Enthusiast

Reading uesr id and password from a file -- MLOAD

Hi,

I want to read the user id and password from a file insted of hard coding in the MLOAD control file. Please help me how to get it.

Regards,
KKR
2 REPLIES
Enthusiast

Re: Reading uesr id and password from a file -- MLOAD

Hi

(Make changes to the following that are specific to your environment)

Create a file called example.logon which contains the following line.

.LOGON TD_DEV/username,password;

In your mload, tpump etc add the following line

.Run file 'C:\logon\example.logon'; /* Connect to the Teradata DBS */

hope this helps
david pracy
Enthusiast

Re: Reading uesr id and password from a file -- MLOAD

Thank you David,

I will try that.

Regards,
KKR