使用脚本加速 DB2 存储过程的开发

                1.	@echo off
2.	if {%2} =={} goto setlog
3.	set LogFile=%2
4.	goto exe
5.	rem 如果没有指定输出文件，设置默认输出文件
6.	:setlog
7.	set LogFile=logs\run.log
8.	
9.	:exe
10.	echo %LogFile%
11.	echo --------------------- execute file:%1-------------------- >> %LogFile%
12.	db2 values(current time) >> %LogFile%
13.	db2 -td@ -f %1 -z %LogFile%
14.	db2 values(current time) >> %LogFile%
15.	pause

                1.	@echo off
2.	mkdir logs
3.	set logfile=logs\view_%2.txt
4.	db2 describe table %1.%2 show detail >%logfile%
5.	echo  -----------------------below is (are) pk-------------------------  >>%logfile%
6.	db2 "select substr(colname,1,30) as pk from syscat.columns 
where keyseq is not null and tabschema=upper('%1')
and tabname = upper('%2')" >>%logfile%
7.	echo  ---------------below are the fisrt 20 rows in the %1.%2 table----  >>%logfile%
8.	db2 select * from %1.%2 fetch first 20 rows only >>%logfile%
9.	echo  -----------------------below is the sql of the %1.%2 view ---------  >>%logfile%
10.	db2 "select varchar(text,32670) from syscat.views 
where viewschema=upper('%1')and viewname = upper('%2')" >>%logfile%
11.	echo  ---------------below are tables  of the %1.%2 view ---------  >>%logfile%
12.	db2 "select distinct bname from syscat.viewdep 
where viewname= upper('%1')  and btype='T'" >>%logfile%
13.	start %logfile%

                1.	@echo off
2.	set logfile=logs\view_%1.sql
3.	db2 select varchar(text,32670)  from syscat.routines 
where routinename=upper('%1') > %logfile%
4.	echo  -----------------------below are tables used by %1 ---------  >>%logfile%
5.	db2 select bname from syscat.packagedep 
where (btype='T' or btype='V') and pkgname in
(select bname from sysibm.sysdependencies where dname =upper('%1')) >> %logfile%
6.	
7.	start %logfile%