Thank you!  The array is working.  I put the array in a while loop wit
+h $i = 0 and I increment it.  I tried to pass the array to my query. 
+ The query will only read the first array index.  Each time it goes t
+hrough the loop, it will print the value for the next index.  But the
+ Oracle query will only return data for the first index.  Instead of 
+passing the array directly, I assigned it to a global value.  It also
+ prints the data, but only passes the first value.  How can I get the
+ query to reconize the value for each increment.
[download]

i.e.

use DBI;
use strict;
use vars qw($value);..........

while ($i<=2) 
{
print "$array[$i]\n";

$value = "$array[$i]";

print "$value\n".......


############################
#
#   Set up Query for Store
#
############################

my $stmt = "select 
                  week_end_date, SVP, RD,
                  DM, store, wtd_smrr_gain,QTD_SMRR_GAIN,
                  wtd_bor_gain,QTD_BOR_GAIN,
                  wtd_cust_gain,QTD_CUST_GAIN,
                  WTD_CARD_CLOSED,QTD_AVG_CARD_CL
             from 
                   bonus_4Q_store
             where
                   SVP <> 'RD' and RD = '$value'
             order by
                   svp,dm,store"; ......

$i++......
};
[download]