Archives of the TeradataForum

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

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

<-- 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.

Thanks

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