Archives of the TeradataForum
Message Posted: Thu, 15 Jul 2004 @ 16:26:40 GMT
<-- Anonymously Posted: Thursday, July 15, 2004 12:11 -->
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|