: !/bin/sh

dosum()
{
runisql <<SQLCMD0
begin work;
lock table groupsum in exclusive mode;
lock table trk_extsum in exclusive mode;
update groupsum
set groupid = "KDR01YHQ" where groupid = "KDM01YHQ" and sumdate = "$1";
update trk_extsum
set grid = "KDR01YHQ" where grid = "KDM01YHQ" and sumdate = "$1";
commit work;
SQLCMD0
}

dosum "01/02/2010"
dosum "02/02/2010"
dosum "03/02/2010"
dosum "04/02/2010"
dosum "05/02/2010"
dosum "06/02/2010"
dosum "07/02/2010"
dosum "08/02/2010"
dosum "09/02/2010"
dosum "10/02/2010"
dosum "11/02/2010"
dosum "12/02/2010"
dosum "13/02/2010"
dosum "14/02/2010"
dosum "15/02/2010"
dosum "16/02/2010"
dosum "17/02/2010"
dosum "18/02/2010"
dosum "19/02/2010"
dosum "20/02/2010"