command issue in mload
Teradata Teradata Discussion Forums Teradata.com Discussion Forum
Visit Teradata.com
Home       Guidelines    Member List
Welcome Guest ( Login | Register )
        


This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.


command issue in mload Expand / Collapse
Author
Message
Posted 8/28/2009 6:19:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 9/7/2009 9:55:58 AM
Posts: 2, Visits: 13
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..




Yuvaraj manohar.
Post #16697
Posted 9/10/2009 2:53:05 PM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Forum Members
Last Login: 11/9/2009 3:27:04 PM
Posts: 38, Visits: 46
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".
Post #16805
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )
No members currently viewing this topic.


All times are GMT -5:00, Time now is 5:16pm

Powered By InstantForum.NET v4.1.4 © 2009
Execution: 0.078. 8 queries. Compression Disabled.