DB2 WINDOWS脚本调用存储过程

1）存储过程

CREATE PROCEDURE TT()
 BEGIN
   insert into a values('a');
  END;
  

2）脚本,保存到C:\Users\Administrator\Desktop\db2_script.cmd

@echo off

db2 connect to sample user db2admin using db2admin
db2 call tt()
db2 select * from a
db2 terminate
echo       *                   10秒后自动退出                   *
ping -n 10 127.0.0.1>nul
exit

:end

3）调用脚本,保存为t.bat

db2cmd "C:\Users\Administrator\Desktop\db2_script.cmd"

4) 双击运行t.bat