生成Informix数据库的所有表格

作者：shx  出处：

 

 

#copyright Clansoft studio
#create all forms for informix database

[ $# -lt 1 ] && { echo "Usage: creatform database"; exit; }
dbname=$1

echo "Get table information..."

isql -s $dbname << ! | grep "isql -s $dbname -fg" >/tmp/tabnames
select "isql -s $dbname -fg ",tabname[1,10],tabname,"-t" from \
systables where tabname matches "[a-z]*"
!

echo
echo "Creatting forms..."
. /tmp/tabnames

echo
echo "OK!"

# (End)