#!/bin/sh

target=$1
table=$2
db2 connect to tpcd
date
echo db2 load from "/scratch/tpc-h/$target/$table.tbl"  of del modified by anyorder coldel\| fastparse messages /dev/null insert into TPCD.$table nonrecoverable
db2 load from "/scratch/tpc-h/$target/$table.tbl"  of del modified by anyorder coldel\| fastparse messages /dev/null insert into TPCD.$table nonrecoverable
date
db2 disconnect tpcd

