I have written a Multiload script to Load Data in TeraData Database and the commands in the script is like:
.LOGTABLE Employee_log;
.LOGON 192.168.1.1/dbc,dbc;
.BEGIN MLOAD TABLES Employee_Stg;
.LAYOUT Employee;
.FIELD in_EmployeeNo * VARCHAR(10);
.FIELD in_FirstName * VARCHAR(30); ....
But the password is clearly visible in the script. Is there a option to secure the password or any alternate way/command to logon and then run the script.
You can create a logon file and run it in your MLOAD script using the following command
.RUN FILE logonfile.txt
In the logon file you can provide the statement that you used in your script
.LOGON 192.168.1.1/dbc,dbc;