How to hide logon password in Teradata Mload Log file?

153 Views Asked by At

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 file.

Logfile:

...

003 .Logon &id_pwd;

... *** UTY2402 Previous statement modified to:

005 .Logon id,pwd; // pwd visible

Is there any option to hide password in log file?

Original script was

.Logon id,pwd;

Logfile:

003 .Logon id,; //not display password

0

There are 0 best solutions below