Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: With statement
From:   Dieter Nöth


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)


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020