Archives of the TeradataForum
Message Posted: Fri, 18 Dec 2009 @ 10:54:15 GMT
| Subj: | | Re: Number of columns exceed the Database Limit |
| |
| From: | | Victor Sokovin |
Check the Teradata release you are using. The answer will depend on it:
"If the number of columns in the result set of a SQL Query exceeds the Teradata Database V2R4.x limit of 256, or the limit of 2048
for V2R5.1 and later, then the ODBC Driver for Teradata returns the following error: "Number of Columns Exceed the Database Limit""
The above is a quote from one of the latest ODBC driver user guides.
Solutions? Use less columns per statement, or check whether third-party vendors offer drivers supporting more columns.
Victor
| 
