: !/bin/sh

outfile="$1"

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

tmpfile0="/tmp/tP0.$$"
tmpfile1="/tmp/tP1.$$"

rm -f "$tmpfile0"
rm -f "$tmpfile1"

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

gettbs tPerson "$tmpfile0"
#cp "$tmpfile0" tPerson.test.unl

# Testing
#cp tPerson.test.unl "$tmpfile0"

(
awk -F'|' '
{
	PersonID = $1
	Person = $2
	Active = $5
	EmailAddress = $6

	lowerEmailAddress = tolower(EmailAddress)
	if ( Active == "1" )
		print  PersonID "|" Person "|" lowerEmailAddress "|"
}
' < "$tmpfile0"
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


if [ -n "$outfile" ]; then
	cp  "$tmpfile1" "$outfile"
fi

#cp "$tmpfile1" 1

rm -f "$tmpfile0"
rm -f "$tmpfile1"

exit 0