Archives of the TeradataForum
Message Posted: Fri, 23 Mar 2001 @ 21:05:40 GMT
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)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|