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