Hi All, I'm testing the Teradata stages for the first time since the installation and I'm having a problem using MultiLoad and Tpump. The Enterise Stage work fine. Is there a specfic path DataStage needs to point to to find the mload executable? I'm assuming that this is what is causing the error.
mload: No such file or directory
.logtable SMB_DEV_TABLE.LOGT_CD_DDT_DimDate;
.logon 142.182.194.146 142.182.194.148 142.182.194.145 142.182.194.147/DATA_STAGE,PASSWORD;
.begin import mload tables SMB_DEV_TABLE.T_CD_DDT_DimDate CHECKPOINT 0 TENACITY 2;
.layout internal indicators;
.field DDT_Key * integer;
.field DDT_Date * char(26);
.field DDT_DateDesc * varchar(25);
.field DDT_DayOfWeek * integer;
.field DDT_MonthDesc * varchar(20);
.field DDT_MonthNum * integer;
.field DDT_QuarterDesc * varchar(20);
.field DDT_QuarterNum * integer;
.field DDT_Year * integer;
.field DDT_WeekStartDate * date;
.field DDT_WeekEndDate * date;
.field DDT_DayOfWeekDesc * varchar(20);
.field DDT_FiscalYear * integer;
.field DDT_FiscalWeekStartDate * date;
.field DDT_FiscalWeekEndDate * date;
.field DDT_FiscalQuarterNum * integer;
.field DDT_FiscalQuarterDesc * varchar(20);
.field DDT_PreviousYear * integer;
.field DDT_WeekNum * integer;
.field DDT_PreviousWeekNum * integer;
.field DDT_PreviousQuarterNum * integer;
.field DDT_PreviousMonthNum * integer;
.field DDT_PreviousDayOfWeek * integer;
.field DDT_FiscalQuarterStartDate * date;
.field DDT_FiscalQuarterEndDate * date;
.field DDT_HolidayIndicator * varchar(20);
.field DDT_Weekday_Indicator * varchar(20);
.dml label tdmload do insert for missing update rows;
update SMB_DEV_TABLE.T_CD_DDT_DimDate
set DDT_Date = :DDT_Date,
DDT_DateDesc = :DDT_DateDesc,
DDT_DayOfWeek = :DDT_DayOfWeek,
DDT_MonthDesc = :DDT_MonthDesc,
DDT_MonthNum = :DDT_MonthNum,
DDT_QuarterDesc = :DDT_QuarterDesc,
DDT_QuarterNum = :DDT_QuarterNum,
DDT_Year = :DDT_Year,
DDT_WeekStartDate = :DDT_WeekStartDate,
DDT_WeekEndDate = :DDT_WeekEndDate,
DDT_DayOfWeekDesc = :DDT_DayOfWeekDesc,
DDT_FiscalYear = :DDT_FiscalYear,
DDT_FiscalWeekStartDate = :DDT_FiscalWeekStartDate,
DDT_FiscalWeekEndDate = :DDT_FiscalWeekEndDate,
DDT_FiscalQuarterNum = :DDT_FiscalQuarterNum,
DDT_FiscalQuarterDesc = :DDT_FiscalQuarterDesc,
DDT_PreviousYear = :DDT_PreviousYear,
DDT_WeekNum = :DDT_WeekNum,
DDT_PreviousWeekNum = :DDT_PreviousWeekNum,
DDT_PreviousQuarterNum = :DDT_PreviousQuarterNum,
DDT_PreviousMonthNum = :DDT_PreviousMonthNum,
DDT_PreviousDayOfWeek = :DDT_PreviousDayOfWeek,
DDT_FiscalQuarterStartDate = :DDT_FiscalQuarterStartDate,
DDT_FiscalQuarterEndDate = :DDT_FiscalQuarterEndDate,
DDT_HolidayIndicator = :DDT_HolidayIndicator,
DDT_Weekday_Indicator = :DDT_Weekday_Indicator
where DDT_Key = :DDT_Key;
insert SMB_DEV_TABLE.T_CD_DDT_DimDate (DDT_Key, DDT_Date, DDT_DateDesc, DDT_DayOfWeek, DDT_MonthDesc, DDT_MonthNum, DDT_QuarterDesc, DDT_QuarterNum, DDT_Year, DDT_WeekStartDate, DDT_WeekEndDate, DDT_DayOfWeekDesc, DDT_FiscalYear, DDT_FiscalWeekStartDate, DDT_FiscalWeekEndDate, DDT_FiscalQuarterNum, DDT_FiscalQuarterDesc, DDT_PreviousYear, DDT_WeekNum, DDT_PreviousWeekNum, DDT_PreviousQuarterNum, DDT_PreviousMonthNum, DDT_PreviousDayOfWeek, DDT_FiscalQuarterStartDate, DDT_FiscalQuarterEndDate, DDT_HolidayIndicator, DDT_Weekday_Indicator)
values (:DDT_Key, :DDT_Date, :DDT_DateDesc, :DDT_DayOfWeek, :DDT_MonthDesc, :DDT_MonthNum, :DDT_QuarterDesc, :DDT_QuarterNum, :DDT_Year, :DDT_WeekStartDate, :DDT_WeekEndDate, :DDT_DayOfWeekDesc, :DDT_FiscalYear, :DDT_FiscalWeekStartDate, :DDT_FiscalWeekEndDate, :DDT_FiscalQuarterNum, :DDT_FiscalQuarterDesc, :DDT_PreviousYear, :DDT_WeekNum, :DDT_PreviousWeekNum, :DDT_PreviousQuarterNum, :DDT_PreviousMonthNum, :DDT_PreviousDayOfWeek, :DDT_FiscalQuarterStartDate, :DDT_FiscalQuarterEndDate, :DDT_HolidayIndicator, :DDT_Weekday_Indicator);
.import INFILE Teradata_Multiload_22.DateDim format fastload layout internal apply tdmload;
.end mload;
.if &SYSETCNT then;
.logoff 20;
.endif;
.if &SYSUVCNT then;
.logoff 20;
.endif;
.logoff;
Teredata mload: No such file or directory error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 342
- Joined: Tue Nov 04, 2008 10:38 am
- Location: Chennai, India