topic Re: ERROR: At least one of the columns in this DBMS table has a datatype that is not supported by th in New SAS User

ERROR: At least one of the columns in this DBMS table has a datatype that is not supported by this e

Sunboyss30 — Mon, 09 Dec 2019 11:31:46 GMT

Hi ,

When i am trying to fetch data from Teradata into SAS with a select * statement , I get the below error. I know it has to do with the format as SAS does not support the Teradata data types. But when I select all the fields with their names instead of * it doesn't give error. Please suggest.

ERROR: At least one of the columns in this DBMS table has a datatype that is not supported by this engine.

Re: ERROR: At least one of the columns in this DBMS table has a datatype that is not supported by th

tomrvincent — Mon, 09 Dec 2019 14:10:31 GMT

Doing a select * is almost never a good idea. Pick only the fields you need, which you've already proved works.

Re: ERROR: At least one of the columns in this DBMS table has a datatype that is not supported by th

Sunboyss30 — Tue, 10 Dec 2019 07:18:50 GMT

Hi tomrvincent,

Thanks for your reply. I agree with you but I need to consider all the fields in that table and if a pick it instead of * it makes the code go very long. And i was just trying avoiding that.

Re: ERROR: At least one of the columns in this DBMS table has a datatype that is not supported by th

tomrvincent — Wed, 11 Dec 2019 13:33:12 GMT

No idea with 'consider' means in this case, but I think I'd either be satisfied with long code or break up the task into smaller chunks, maybe 10 or 20 fields at a time.

Even with the dreaded 'select *' I suspect that you have to refer to individual field names later on so a long select statement shouldn't be a problem.

Re: ERROR: At least one of the columns in this DBMS table has a datatype that is not supported by th

Sunboyss30 — Wed, 11 Dec 2019 13:53:05 GMT

I agree. Thanks a lot for your inputs.