#!/bin/sh

db2 connect to cacm

db2 load from '/scratch/new_cacm_data/UserVisits.dat' of del modified by anyorder NOCHARDEL COLDEL\| terminate into UserVisits\(sourceIPAddr, destinationURL, visitDate, adRevenue, UserAgent, cCode, lCode, sKeyword, avgTimeOnSite\);

db2 disconnect cacm

