: '
: *************************************************************************
:
:			   INFORMIX SOFTWARE, INC.
: 
:			      PROPRIETARY DATA
: 
:	THIS DOCUMENT CONTAINS TRADE SECRET DATA WHICH IS THE PROPERTY OF 
:	INFORMIX SOFTWARE, INC.  THIS DOCUMENT IS SUBMITTED TO RECIPIENT IN
:	CONFIDENCE.  INFORMATION CONTAINED HEREIN MAY NOT BE USED, COPIED OR 
:	DISCLOSED IN WHOLE OR IN PART EXCEPT AS PERMITTED BY WRITTEN AGREEMENT 
:	SIGNED BY AN OFFICER OF INFORMIX SOFTWARE, INC.
:
:	THIS MATERIAL IS ALSO COPYRIGHTED AS AN UNPUBLISHED WORK UNDER
:	SECTIONS 104 AND 408 OF TITLE 17 OF THE UNITED STATES CODE. 
:	UNAUTHORIZED USE, COPYING OR OTHER REPRODUCTION IS PROHIBITED BY LAW.
:
:
:  Title:	dbaccessdemo 
:  Sccsid:	@(#)dbaccessdemo	9.13	1/17/94  11:03:05
:  Description:	Demonstration Database Installation Script
: '

IDIR=${INFORMIXDIR-/usr/informix}
DEFAULT_HOSTS=$INFORMIXDIR/etc/sqlhosts
HOSTS="$INFORMIXSQLHOSTS"
DBPATH=.
export DBPATH
DBDATE=mdy4/
export DBDATE
DBMONEY=\$.
export DBMONEY
log=no
dbspaceopt=0
db=
dbspace=
err=no 
i=
count=0
create="create database"
wlog=""
in=""
 
# There are only 4 possible arguments : -log, dbname, -dbspace and dbspacename
 
if (test $# -gt 4)
then
        infxmsg 33410 $0
        exit
fi
#find out if logging or a specific dbspace or database name  is requested
for i in $*
do
    count=`expr $count + 1`
    case $i in
        -log)       if (test $log = no)
                    then
                        log=yes
                    else
                        err=wha
                    fi;;
        -dbspace)   if (test $dbspaceopt -eq 0)
                    then
                        dbspaceopt=`expr $count + 1`
                    else
                        err=wha
                    fi;;
        [a-zA-Z]*)  if (test x$dbspace = x -a $dbspaceopt -eq $count)
                    then
                        dbspace=$i
                    elif (test x$db = x)
                    then
                        db=$i
                    else
                        err=wha
                    fi;;
        -*)         err=wha
                    infxmsg 33408 $i
                    ;;
        *)          err=wha
                    infxmsg 33409
                    ;;
    esac
done   
 
if (test $err = wha)
then
        infxmsg 33410 $0
        exit
fi
 
# error if -dbspace w/o dbspacename
if (test x$dbspace = x -a $dbspaceopt -ne 0)
then
        infxmsg 33410 $0
        exit
fi

# supply default dbname
if (test x$db = x)
then
    db=stores7;
fi

if (test X$HOSTS = "X")
then
    HOSTS=$DEFAULT_HOSTS
fi

if (test X$INFORMIXSERVER = "X")
then
    infxmsg -33401
    exit 1
fi

#Demo installation script
infxmsg 33401

TYPE=`awk '{ if ($1 == host) print substr($2,1,2); }' host=$INFORMIXSERVER $HOSTS`

if (test $TYPE = "se")
then
    TURBO=0
    if test -d $db.dbs
    then
	DROPIT=1
     fi
else
    TURBO=1
    DROPIT=1
fi

if (test $DROPIT)
then
#dropping exiting database
   infxmsg 33402 $db

   dbaccess - - > /dev/null 2>&1 <<!
   drop database $db;
!
fi

#creating exiting database
infxmsg 33403 $db

if (test "$TURBO" -eq 1 -a $log = yes)
then
	wlog="with log"
elif (test $TYPE = "se" -a $log = yes)
then
	logpath=`pwd`
	wlog="with log in '$logpath/$db.log'"
fi

if (test "$TURBO" -eq 1 -a $dbspaceopt -ne 0)
then
	in="in"	
fi

# create database
dbaccess - - <<!
$create $db $in $dbspace $wlog;
!

(cd $IDIR/demo/dbaccess; cat c_custom.sql c_orders.sql c_manuf.sql c_stock.sql c_items.sql c_state.sql c_type.sql c_calls.sql c_index.sql c_view1.sql c_view2.sql c_trig.sql > /tmp/$$.sql)

if (test "$TURBO" -eq 1)
then
    cat $IDIR/demo/dbaccess/c_cat.sql >> /tmp/$$.sql
fi

dbaccess $db /tmp/$$.sql
rm -f /tmp/$$.sql

#loading data
infxmsg 33404

dbaccess $db - <<!

load from "$IDIR/demo/dbaccess/customer.unl"
   insert into customer;

load from "$IDIR/demo/dbaccess/orders.unl"
   insert into orders;

load from "$IDIR/demo/dbaccess/manufact.unl"
   insert into manufact;

load from "$IDIR/demo/dbaccess/stock.unl"
   insert into stock;

load from "$IDIR/demo/dbaccess/items.unl"
   insert into items;

load from "$IDIR/demo/dbaccess/state.unl"
   insert into state;

load from "$IDIR/demo/dbaccess/call_type.unl"
   insert into call_type;

load from "$IDIR/demo/dbaccess/cust_calls.unl"
   insert into cust_calls;

update statistics;

grant resource to public;
!

if (test "$TURBO" -eq 1)
then
    dbaccess $db - <<!
    load from "$IDIR/demo/dbaccess/catalog.unl"
       insert into catalog;
!
fi

#creation complete
infxmsg 33405

UKEY=`(read K; echo $K)`
Y_RESPONSE=`infxmsg 33484`
y_RESPONSE1=`infxmsg 33485`

if (test "$UKEY" != "$Y_RESPONSE" && test "$UKEY" != "$y_RESPONSE1")
then
   exit 0
fi

#now copying SQL command files
infxmsg 33406

cp $IDIR/demo/dbaccess/*.sql .


#End of script
infxmsg 33407