 |
 |
Archives of the TeradataForum
Message Posted: Wed, 22 Oct 2003 @ 13:55:20 GMT
| Subj: | | Re: WITH clause not working |
| |
| From: | | David Wellman |
My understanding is that the ODBC standard requiresthat each row in the answer set has the same format and structure, e.g. same number of
columns and corresponding columns in each row have the same data type. Using the WITH clause obviously breaks this rule, hence it's not
allowed. Bteq accepts it because Bteq is Teradata only.
The equivalent to WITH can be coded into an SQL statement and run via Queryman (oops, sorry - SQL Assistant) by using the ANSI style SUM
syntax. You end up with the 'totals' figures added to every line of the output, but you do get the data.
Cheers,
Dave
| |
