[Omaha.pm] Another 20s hack

["Jay Hannah" <jhannah@omnihotels.com>]

Given a list of tables, kick out a bunch of SQL statements.

j


while (<DATA>) {
   chomp;
   #print "select count(*) from $_ where prop = 'NYCCAR';\n";
   #print "unload to $_.unl select * from $_ where prop = 'NYCCAR';\n";
   print "delete from $_ where prop = 'NYCCAR';\n";
}

__DATA__
resfile1
resfile1_ar
resfile_comment
resfile_comment_ar
resfile_conf
resfile_gtd
resfile_gtd_ar
resfile_lookup
resfile_master
resfile_master_ar
resfile_rates
resfile_rates_ar
resfile_sh_rate
resfile_sh_rate_ar
resfile_smaster
resfile_smaster_ar
resfile_srq
resfile_srq_ar
resfile_ta
resfile_ta_ar