Teradata V13.10 is certified as a metadata, warehouse and statistics repository with Strategy 9.3.0 - 9.3.1. As noted in the Strategy General Information Readme files of these releases, the Teradata ODBC driver listed for this certification on Windows operating system is Teradata ODBC Driver 14.00.00.04.
This technical note outlines that the certification has been extended to Teradata 13.10.00.07 ODBC driver on Windows operating system for the same combination - Teradata V13.10 with Strategy 9.3.0 - 9.3.1. This is a post-certification since the testing was performed after the release of Strategy 9.3.0 - 9.3.1. Therefore, this certification information (tabulated below) is not present in the Strategy 9.3.0 - 9.3.1 General Information Readme files.
The following is the additional certification information on Windows for Strategy 9.3.0 - 9.3.1:
<?xml version='1.0'?>
create table T7RTQ22AEOP000 nologging as
select distinct a12.CUST_CITY_ID CUST_CITY_ID,
a13.CALL_CTR_ID CALL_CTR_ID,
a11.QUARTER_ID QUARTER_ID
from LU_MONTH a11
join CITY_MNTH_SLS a12
on (a11.MONTH_ID = a12.MONTH_ID)
join CITY_CTR_SLS a13
on (a12.CUST_CITY_ID = a13.CUST_CITY_ID)
...
select pa14.YEAR_ID YEAR_ID,
avg((a11.TOT_COST - a13.TOT_COST)) WJXBFS1
from QTR_CATEGORY_SLS a11
join T7RTQ22AEOP000 pa12
on (a11.QUARTER_ID = pa12.QUARTER_ID)
join CITY_CTR_SLS a13
on (pa12.CALL_CTR_ID = a13.CALL_CTR_ID and
pa12.CUST_CITY_ID = a13.CUST_CITY_ID)
join TCM8D230MOP001 pa14
on (a11.QUARTER_ID = pa14.QUARTER_ID)
group by pa14.YEAR_ID
...
Teradata V13.10 32-bit Teradata ODBC Driver 13.10.00.07 Certified | <?xml version='1.0'?>
create table T7RTQ22AEOP000 nologging as
select distinct a12.CUST_CITY_ID CUST_CITY_ID,
a13.CALL_CTR_ID CALL_CTR_ID,
a11.QUARTER_ID QUARTER_ID
from LU_MONTH a11
join CITY_MNTH_SLS a12
on (a11.MONTH_ID = a12.MONTH_ID)
join CITY_CTR_SLS a13
on (a12.CUST_CITY_ID = a13.CUST_CITY_ID)
...
select pa14.YEAR_ID YEAR_ID,
avg((a11.TOT_COST - a13.TOT_COST)) WJXBFS1
from QTR_CATEGORY_SLS a11
join T7RTQ22AEOP000 pa12
on (a11.QUARTER_ID = pa12.QUARTER_ID)
join CITY_CTR_SLS a13
on (pa12.CALL_CTR_ID = a13.CALL_CTR_ID and
pa12.CUST_CITY_ID = a13.CUST_CITY_ID)
join TCM8D230MOP001 pa14
on (a11.QUARTER_ID = pa14.QUARTER_ID)
group by pa14.YEAR_ID
...
Teradata V13.10 32-bit Teradata ODBC Driver 13.10.00.07 Certified | <?xml version='1.0'?>
create table T7RTQ22AEOP000 nologging as
select distinct a12.CUST_CITY_ID CUST_CITY_ID,
a13.CALL_CTR_ID CALL_CTR_ID,
a11.QUARTER_ID QUARTER_ID
from LU_MONTH a11
join CITY_MNTH_SLS a12
on (a11.MONTH_ID = a12.MONTH_ID)
join CITY_CTR_SLS a13
on (a12.CUST_CITY_ID = a13.CUST_CITY_ID)
...
select pa14.YEAR_ID YEAR_ID,
avg((a11.TOT_COST - a13.TOT_COST)) WJXBFS1
from QTR_CATEGORY_SLS a11
join T7RTQ22AEOP000 pa12
on (a11.QUARTER_ID = pa12.QUARTER_ID)
join CITY_CTR_SLS a13
on (pa12.CALL_CTR_ID = a13.CALL_CTR_ID and
pa12.CUST_CITY_ID = a13.CUST_CITY_ID)
join TCM8D230MOP001 pa14
on (a11.QUARTER_ID = pa14.QUARTER_ID)
group by pa14.YEAR_ID
...
Teradata V13.10 32-bit Teradata ODBC Driver 13.10.00.07 Certified |
