Hi, I have been trying to run a query that uses WITH Recursive Clause from Teradata SQL Assistant. The query runs fine but i am not able to see the result set.
It just says "WITH Complete. 253 rows processed" but the result window does not come up. I tried using the Export results but no results are exported.
However when I run the same query from BTEQ, the result rows are displayed.
I looked at all the options in Teradata SQL Assistant but not able to figure why the Answer set does not come up only for the "WITH clause" queries. When i run any other query the answerset window shows the result. Would appreciate any kind of information on this.
The sql assistant i have right now is of Version 13.0.0.01
Databse Version: Teradata 12.00.0331
WITH and WITH BY do not produce true relational output like COUNT function. That is the reason you cannot see the same output in SQL assistant as BTEQ.
"I have been trying to run a query that uses WITH Recursive Clause"
If you actually use the Standard SQL WITH (i.e. at the beginnig of your select) you should see the result, but if it's old Teradata WITH (special clause for calculating aggregates) then only BTEQ will show the full result as WAQ already explained.
More current releases of SQLA should return an answer set but discard the intermediate rows produced by WITH.
A connection using .NET will return an error message indicating that WITH is not supported.
Could you please give me some more notes about "Standard SQL WITH (i.e. at the beginnig of your select) you should see the result"?
Thanks in advance,