: !/bin/sh

#---------------------------------------------------------------------
# Victrack uses TBS tPerson table instead of t21 dir
# populate local informix copy

tmpfile1="/tmp/tP1.$$"

rm -f "$tmpfile1"

(
##tbssql 2>/dev/null <<SQLCMD0
#tbssql 2>/dev/null <<SQLCMD0
#select ID,Person,"dummy@email"
#from tPerson
#SQLCMD0

# Testing
cat tPerson.unl | awk -F'|' '{ print $1 "|" $2 "|" $6 "|" }'

cat <<ADDMORE
168701|BILMAX21 ADMIN|support@transmit.com.au|
168702|TEST VLP|support@transmit.com.au|
ADDMORE
) >"$tmpfile1"

# build tPerson table
#./buildtPerson

#runisql 2>/dev/null <<SQLCMD2
runisql <<SQLCMD2
delete from tPerson;
load from "$tmpfile1" insert into tPerson;
SQLCMD2

#cp "$tmpfile1" 1
rm -f "$tmpfile1"

exit 0