Archives of the TeradataForum

Message Posted: Fri, 23 Mar 2001 @ 21:05:40 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Frank,

as far as i know, ODBC can't deal with different record layouts in a single result set, i.e. the intermediate lines created by WITH. An older version of QueryMan didn't complain about WITH, but reported an error after receiving the first set of records.

Microsoft SQL Server has a similiar feature (if i remember correctly, it's called COMPUTE) and they 'solved' the problem: If you try to use a grid (instead of text) for the answer set (in ISQL), one grid for each part of the answer set and one for each intermediate line pops up. So it's more or less unusable (at least in SQL 7, didn't test it in SQL 2000)

Dieter

	<Prev	Next>		<<First	<Prev	Next>	Last>>