command issue in mload

Tools
Enthusiast

command issue in mload

Hi,
I am using the following .accept command in MLOAD to accept a system variable.
.LOGTABLE ****_WORK.LT_*****MLOAD ;
.RUN FILE LOGON;
.SET SRC TO '&SYSDAY';
.ACCEPT TESTC FROM ENVIRONMENT VARIABLE SYSDAY;

But the mload is failing with
"UTY4827 The requested environment variable SYSDAY is not set."

Please help me out..

1 REPLY
Teradata Employee

Re: command issue in mload

SYSDAY is not a valid environment variable in your environment.
The message is correct.
Do not confuse "environment variable" with "pre-defined MultiLoad system variable".
They are different things.

For example, in your environment, if the "TZ" environment variable was set to something like "US/Pacific"
and you tried this:

.ACCEPT MY_TZ FROM ENVIRONMENT VARIABLE TZ;

then "MY_TZ" would be assigned the string "US/Pacific".
-- SteveF