# FLTWFDISC -  worke  Root Name for wfdisc Table
# ROOT      - site worke Root Name for site,instrument,sensor Tables
# ORIGIN    - origin worke Table Name
# After Quit dbe all FmtTemporaryworking file will be deleted

set FLTWFDISC=$1
set ROOT=$2
set ORIGIN=$3
echo Filtering wfdisc    = $FLTWFDISC
echo Site Table          = $ROOT
echo Origin Table        = $ORIGIN
cp ${FLTWFDISC}.wfdisc    @FmtTemporarywork.wfdisc
cp ${ROOT}.site           @FmtTemporarywork.site
cp ${ROOT}.sensor         @FmtTemporarywork.sensor
cp ${ROOT}.instrument     @FmtTemporarywork.instrument
cp ${ORIGIN}.origin       @FmtTemporaryDb.origin
dbjoin -n zzz @FmtTemporarywork.wfdisc site sensor instrument
dbunjoin -o @FmtTemporaryDb @FmtTemporarywork.zzz
dbe @FmtTemporaryDb
\rm  @*
