Using environment variable in mload script

Tools
Enthusiast

Using environment variable in mload script


Hi,

How to use environment variable declare in .profile file in mload script.Please help me to get through this.
Plaese let me know the syntax for it and how to us it.
3 REPLIES
Teradata Employee

Re: Using environment variable in mload script

You are trying to use Unix variables in a Teradata utility.

To accomplish this you have to interpret the script through the ksh. For example:

mload<<eof

.logtable $MYLOGTABLE;

.logon $MYTDP/$MYID,$MYPASSWORD;
..
..
eof
Enthusiast

Re: Using environment variable in mload script

In MLOAD you can use the .ACCEPT command
Junior Supporter

Re: Using environment variable in mload script

Linux 'sed' command can be an alternative too.

HTH.

Cheers.

Carlos.