DB2编程序技巧 (七)(db2入门视频教程)

编辑：rootadmin

正在看的db2教程是:DB2编程序技巧 (七)。3.4 查看sp使用了哪些表 select bname from syscat.packagedep where btype='T' and pkgname in(select bname from sysibm.sysdependencies where dname in (select specificname from syscat.procedures where procname='PR_CLEAR_MATCH_DIVIDE_SHA')) 3.5 查看function被哪些sp使用 select PROCNAME from SYSCAT.PROCEDURES where SPECIFICNAME in(select dname from sysibm.sysdependencies where bname in ( select PKGNAME from syscat.packagedep where bname in (select SPECIFICNAME from SYSCAT.functions where funcname='GET_CURRENT_DATE'))) 使用function时要注意，如果想drop 掉该function必须要先将调用该function的其它存储过程全部drop掉。必须先创建function，调用该function的sp才可以创建成功。 3.6 修改表结构一次给一个表增加多个字段 db2 "alter table tb_test add column t1 char(1) add column t2 char(2) add column t3 int" 4 DB2系统管理 4.1 DB2安装在Windows 下安装db2 7.1 或其他版本，如果有Jdbc错误或者是Windwos 不能启动，则将autoexec.bat 中的内容用如下内容替换： C:PROGRA~1TRENDP~1PCSCAN.EXE C: C:WINDOWSCOMMAND /NS /WIN rem C:WINDOWSCOMMAND.COM /E: REM [Header] REM [CD-ROM Drive] REM [Miscellaneous] REM [Display] set PATH=%PATH%;C:MSSQLBINN;C:PROGRA~1SQLLIBBIN;C:PROGRA~1SQLLIBFUNCTION;C:PROGRA~1SQLLIBSAMPLESREPL;C:PROGRA~1SQLLIBHELP IF EXIST C:PROGRA~1IBMIMNNQIMQENV.BAT CALL C:PROGRA~1IBMIMNNQIMQENV.BAT IF EXIST C:PROGRA~1IBMIMNNQIMNENV.BAT CALL C:PROGRA~1IBMIMNNQIMNENV.BAT set DB2INSTANCE=DB2 set CLASSPATH=.;C:PROGRA~1SQLLIBjavadb2java.zip;C:PROGRA~1SQLLIBjavaruntime.zip;C:PROGRA~1SQLLIBjavasqlj.zip;C:PROGRA~1SQLLIBbin set MDIS_PROFILE=C:PROGRA~1SQLLIBMETADATAPROFILES set LC_ALL=ZH_CN set INCLUDE=C:PROGRA~1SQLLIBINCLUDE;C:PROGRA~1SQLLIBLIB;C:PROGRA~1SQLLIBTEMPLATESINCLUDE set LIB=C:PROGRA~1SQLLIBLIB set DB2PATH=C:PROGRA~1SQLLIB set DB2TEMPDIR=C:PROGRA~1SQLLIB set VWS_TEMPLATES=C:PROGRA~1SQLLIBTEMPLATES set VWS_LOGGING=C:PROGRA~1SQLLIBLOGGING set VWSPATH=C:PROGRA~1SQLLIB set VWS_FOLDER=IBM DB2 set ICM_FOLDER=信息目录管理器 win

推荐整理分享DB2编程序技巧 (七)(db2入门视频教程)，希望有所帮助，仅作参考，欢迎阅读内容。