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

[Sunboyss30]

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.

[tomrvincent]

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

[Sunboyss30]

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.

[tomrvincent]

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.

[Sunboyss30]

I agree. Thanks a lot for your inputs.