#!/bin/sh

db2 connect to cacm
date
db2 load from '/scratch.1/arasin/MRData/UserVisits.dat' of del modified by anyorder NOCHARDEL COLDEL\| insert into UserVisits\(sourceIPAddr, destinationURL, visitDate, adRevenue, UserAgent, cCode, lCode, sKeyword, avgTimeOnSite\);
date
db2 load from '/scratch.1/arasin/MRData/UserVisits.dat' of del modified by anyorder NOCHARDEL COLDEL\| insert into UserVisits_c\(sourceIPAddr, destinationURL, visitDate, adRevenue, UserAgent, cCode, lCode, sKeyword, avgTimeOnSite\);
date
db2 disconnect cacm

