SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Compatibility with Teradata 16.10

Reply
Occasional Contributor
Posts: 8

Compatibility with Teradata 16.10

 

Hi,

Do anybody checked if you use SAS/ACCESS® Interface to Teradata with Teradata 16.10?

Thanks,

RD

PROC Star
Posts: 549

Re: Compatibility with Teradata 16.10

I have not. I use Teradata 15 with SAS. Did you face any issues

Occasional Contributor
Posts: 8

Re: Compatibility with Teradata 16.10

I was interested if anyone tested it, if I should expect issues/changes..

Will test it on Monday, will let you know if any changes.

PROC Star
Posts: 549

Re: Compatibility with Teradata 16.10

we faced one issue when moving from 14 to 15. Please check the topic

Impact of ROW_NUMBER in Teradata 15 versus Teradata 14 on SAS tables in below article

 

http://www.mwsug.org/proceedings/2016/SA/MWSUG-2016-SA11.pdf

 

PROC Star
Posts: 549

Re: Compatibility with Teradata 16.10

Hi @reginado, did you find any thing exciting/unusual in your tests.

Occasional Contributor
Posts: 8

Re: Compatibility with Teradata 16.10

Hi, I tested the connectivity form SAS to TD and all went fine. For now no additional test were done.
Thanks, RD
Contributor
Posts: 42

Re: Compatibility with Teradata 16.10

We are in the process of testing loading SAS dataset into Teradata using the proc append procedure with fastload and multistmt option and both arefailing.

the code that works fine with TTU 15.0 is not working on TTU 15.10 and 16.10. 

PROC Star
Posts: 549

Re: Compatibility with Teradata 16.10

what is the error.

Contributor
Posts: 42

Re: Compatibility with Teradata 16.10

I am using below script.

LIBNAME UTIL TERADATA USER="XXX" PASSWORD="XXY" SERVER=SERVER_NAME SCHEMA=DB_NAME 

                                                UTILCONN_TRANSIENT=YES;

proc append data=work.sample

                     base=util.td_tablename (MULTISTMT=YES) FORCE;

 

 

I am getting below error:

 

ERROR: teradata connection: the column SEQ is not found in 'td_tablename_RS' table. correct error and restart with option TPT_RESTART=YES.

 

I got above error on a test server that has ttu 16.10. but same script run perfectly fine on ttu 15.0.

 

Anybody have similar issue with ttu 15.10 or above. I don't understand what changing in new versions after ttu 15.0.

PROC Star
Posts: 549

Re: Compatibility with Teradata 16.10

 

 

I have never used multistmt  and have no idea on this. @JBailey  who is an expert and has written quite a few papers on this kind of topic might be able to help us.

 

 i would do following too. 

First I would check the DDL of your base table and data table and check whether they are same or not in both the versions.

I would also try fastload and multiload whether they are working or not

 

proc append data=work.sample

                     base=util.td_tablename_new (fastload=YES) FORCE;

 

 

 

SAS Employee
Posts: 293

Re: Compatibility with Teradata 16.10

Hi @kiranv_,

 

You are way too kind.

 

Best wishes,

Jeff

SAS Employee
Posts: 293

Re: Compatibility with Teradata 16.10

Hi @nbonda,

 

Are you loading into an existing Teradata table or are you creating the table during the load?

 

Best wishes,

Jeff

SAS Employee
Posts: 293

Re: Compatibility with Teradata 16.10

[ Edited ]

Hi @nbonda

 

Is there any chance that there is an old restart table hanging around? It could be that  'td_tablename_RS' is referring to a different version of the table - one without the column SEQ in it. If there is a spurious restart table you may want to DROP it. Or you can point it to a different table name by specifying the TPT_LOG_TABLE= option.

 

There is more information here: https://support.sas.com/resources/papers/proceedings11/142-2011.pdf

 

Best wishes,
Jeff

Ask a Question
Discussion stats
  • 12 replies
  • 424 views
  • 2 likes
  • 4 in conversation