Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 15 Jul 2004 @ 16:26:40 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Comparing output from two SQLs
From:   Anomy Anom

<-- Anonymously Posted: Thursday, July 15, 2004 12:11 -->

Hi All,

What is the best way to compare the output of two sqls returning ( same number of columns). As understood, the AMP might return rows in random order. The number of sqls in my case is more than 10K so I cannot do it manually.

Perhaps we can try using the following methods, is there anything trivial ?

1) use DBD:ODBC to submit sql & fetch rows and compare in memory. This will eat the CPU of the box.

2) Use DBD:ODBC to submit & fetch rows, store in flat files, sort & and then compare. This needs lot of resource.

3) Send the output to two tables and compare the rows. This needs away to capture the output rows from SQL and create tables. We are not sure that we will hit any limitations of "create table as <select>". Further the sqls may be updates or deletes too.

Please suggest.


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