:	'(c) Copyright	Empress Software Inc.	1983, 2003'

USAGE="*** Usage ***  $0"

if test "$EMPRESSPATH" = "" 
then
	echo "EMPRESSPATH not set"
	exit 1

elif test ! -d $EMPRESSPATH
then
	echo "invalid EMPRESSPATH"
	exit 1
fi

MSTDBSPATH=`cd $EMPRESSPATH/rdbms/testdbs/$MSTCODESET; /bin/pwd`
MSTESTPATH=`cd $EMPRESSPATH/rdbms/testwork; /bin/pwd`
MSNETTESTDBPATH=`cd $MSTESTPATH/_nettmp; /bin/pwd`
MSTESTDBPATH=`cd $MSTESTPATH/_testtmp; /bin/pwd`

MSRMTTDBSPATH=`cd $EMPRESSRMTPATH/rdbms/testdbs/$MSTCODESET; /bin/pwd`
MSRMTTESTPATH=`cd $EMPRESSRMTPATH/rdbms/testwork; /bin/pwd`
MSRMTNETTESTDBPATH=$MSRMTTESTPATH/_nettmp
MSRMTTESTDBPATH=$MSRMTTESTPATH/_testtmp
MSRMTNETTESTDB=$MSRMTNETTESTDBPATH/testdb

case "$MSSAMEPATH" in
 "yes")
	MSTESTDB=$MSTESTDBPATH/testdb;;
 *)
	MSTESTDB=$MSRMTTESTDBPATH/testdb;;
esac

MSGLOBALDATADICTIONARY=$MSNETTESTDBPATH/_glbdd
MSRMTGLOBALDATADICTIONARY=$MSRMTNETTESTDBPATH/_glbdd

test "$MSSERVERNAME" = "" && MSSERVERNAME="_svruntest"

rm -f $MSGLOBALDATADICTIONARY

cat > $MSGLOBALDATADICTIONARY <<EOM

MSDBLOGICALNAME=$MSTESTDB
    MSDBLOCATION=$MSRMTNETTESTDB
    MSDBSERVERNAME=$MSSERVERNAME
MSDBLOGICALEND
MSDBLOGICALNAME=_db1
    MSDBLOCATION=$MSRMTNETTESTDBPATH/testdir/_db1
    MSDBSERVERNAME=$MSSERVERNAME
MSDBLOGICALEND
EOM

COUNT=1

while :
do
	cat >> $MSGLOBALDATADICTIONARY <<EOM
MSDBLOGICALNAME=$MSTESTDBPATH/_db$COUNT
    MSDBLOCATION=$MSRMTNETTESTDBPATH/_db$COUNT
    MSDBSERVERNAME=$MSSERVERNAME
MSDBLOGICALEND
EOM
	COUNT=`expr $COUNT + 1`
	test "$COUNT" = 5 && break
done

echo >> $MSGLOBALDATADICTIONARY

test "$MSTCODESET" = "" && MSTCODESET=ascii

if test -d $EMPRESSPATH/rdbms/testsrc/$MSTCODESET
then
	MSTSRCPATH=$EMPRESSPATH/rdbms/testsrc/$MSTCODESET
else
	MSTSRCPATH=$EMPRESSPATH/rdbms/test
fi

cd $MSTSRCPATH
MAJORLIST="[a-z]*"

for MSTMAJOR in $MAJORLIST
do
	MSTSRCMAJOR=$MSTSRCPATH/$MSTMAJOR
	MSTDBSMAJOR=$MSTDBSPATH/$MSTMAJOR
	MSRMTTDBSMAJOR=$MSRMTTDBSPATH/$MSTMAJOR
	DB=_db
	DB1=_db1

	cat >> $MSGLOBALDATADICTIONARY <<EOM
MSDBLOGICALNAME=$MSTDBSMAJOR/$DB
    MSDBLOCATION=$MSRMTTDBSMAJOR/$DB
    MSDBSERVERNAME=$MSSERVERNAME
MSDBLOGICALEND
EOM
	test -f $MSTSRCMAJOR/_db1.ex && cat >> $MSGLOBALDATADICTIONARY <<EOM
MSDBLOGICALNAME=$MSTDBSMAJOR/$DB1
    MSDBLOCATION=$MSRMTTDBSMAJOR/$DB1
    MSDBSERVERNAME=$MSSERVERNAME
MSDBLOGICALEND
EOM

done

if test "$MSNETTEST" != `$EMPRESSPATH/common/sys_bin/sysuname`
then
	rcp $MSGLOBALDATADICTIONARY $MSNETTEST:$MSRMTGLOBALDATADICTIONARY
fi

