从列表文件读取待处理元素依次处理的脚本

myproc="Proc.jar"
echo $myproc;

for schema in `cat ./schema.lst`
do
	echo $schema
#	java -jar $myproc -env ./tdEnv.ini -schema $schema -table % -tablist ./tablelist/${schema}.lst
done

for schema in `cat ./schema.lst`
do

for table in `cat ./tablelist/${schema}.lst`
do
curtable=`echo $table|awk -F '\\\\.' '{print $2}'`
ddlfile=./ddl/${table}.ddl
#if file not exists then do the process for the table
if [ ! -f "$ddlfile" ]; then 
	java -jar $myproc -env ./tdEnv.ini -schema $schema -table $curtable -gensql $ddlfile
fi
done

done