#!/bin/sh NOW=`date +"%C%y/%m/%d %H:%M"` cat >/tmp/$$.dbl <<__END__ set Patient $1; insert into AdmitWt with values realTime="$NOW", entryTime="$NOW", highlight=0, userId=0; insert into HeightEvent with values realTime="$NOW", entryTime="$NOW", highlight=0, userId=0; insert into BSAEvent with values realTime="$NOW", entryTime="$NOW", highlight=0, userId=0; __END__ dbload -l -w /tmp/$$.dbl