#!/bin/sh
destroydb stocks
creatdb stocks
ingres stocks <<EOF
create stocks (symbol=c5,type=c1,date=i4,last=f4,high=f4,low=f4,volume=i4)\g
copy stocks (
	symbol=c0sp,
	type=c0sp,
	date=c0sp,
	last=c0sp,
	high=c0sp,
	low=c0sp,
	volume=c0nl)
	from "/staff/bzs/stocks/scr/stox"
\g
\q
EOF
exit 0