topic Re: How can I view all column names from a tera data table in SAS Programming

How can I view all column names from a tera data table

Jeg123 — Mon, 17 Jun 2019 09:00:37 GMT

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?

Re: How can I view all column names from a tera data table

LinusH — Mon, 17 Jun 2019 09:13:43 GMT

Try the DBC tables:

http://teradata.iexpertify.com/2011/09/dbc-tables-or-system-tables-on-teradata.html

Re: How can I view all column names from a tera data table

tsap — Tue, 25 Jun 2019 13:43:54 GMT

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.