Im trying to select 1 row from teradata just to view the column names. The problem is I get the following error:
ERROR: At least one of the columns in this DBMS table has a datatype that is not supported by this engine.
proc sql;
connect to teradata as tera (authdomain="TeradataAuth" tdpid=aprod mode=Teradata);
create table work.test as
select * from connection to tera (
select top 1 *
from tera_table.hello
);
disconnect from tera;
quit;
How can i achieve my purpose?
Try the DBC tables:
http://teradata.iexpertify.com/2011/09/dbc-tables-or-system-tables-on-teradata.html
To achieve the outcome you requested on my own system, I created a libref for the Teradata database connection and then executed a 'PROC CONTENTS' datastep:
LIBNAME Tera TERADATA AUTHDOMAIN="TeradataAuth" TDPID=APROD MODE=Teradata;
PROC CONTENTS DATA=Tera.Hello; RUN;
This is what I mocked up from the information provided in your post.
Hope this helps.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.