Archives of the TeradataForum

Message Posted: Tue, 23 Dec 2008 @ 12:29:20 GMT

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

To add to Quincy Leslie�s post, a way to extract the count from a table is to write the results of a query using the BTEQ ".export" command.

     /*  BTEQ code  snippet */

     .export file=count_table1

     sel count(*) as recs from table1

     .export reset



     .export file=count_table2

     sel count(*) as recs from table2

     .export reset



     # KSH code snippet     "expression_to_get_table`_count that Quincy
     refers to"

     export CT1=`tail -1 count_table1 | awk '{print $1}'`

     export CT2=`tail -1 count_table2 | awk '{print $1}'`

At this point you may perform the unix shell comparisons described in Quincy�s post.

To compare the values then use the shell script comparison techniques, which which will be slightly different depending on whether you are using Korn Shell, Bourne Shell, or C Shell. A variation on Bourne & Korn C

     IF [ $CT1 > $CT2 ]      if [ $CT1 > $CT2 ]         if [ $CT1 > $CT2 ] then

           THEN                         then do_action

               Shell_action             do_action               endif

          FI                                    fi

Jim Summersgill

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