当前位置：首页 -> 数据库 -> DB2 -> DB2编程序技巧 (七)

DB2编程序技巧 (七)

时间： 2021-08-13 作者：daque

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 98 下安置db2 7.1 或其余本子，即使有jdbc缺点大概是windwos 98不许启用，则将autoexec.bat 中的实质用如次实质替代： c:\progra~1\trendp~1\pcscan.exe c:\ c:\windows\command\ /ns /win95 rem c:\windows\command.com /e:32768 rem [header] rem [cd-rom drive] rem [miscellaneous] rem [display] set path=%path%;c:\mssql\binn;c:\progra~1\sqllib\bin;c:\progra~1\sqllib\function;c:\progra~1\sqllib\samples\repl;c:\progra~1\sqllib\help if exist c:\progra~1\ibm\imnnq\imqenv.bat call c:\progra~1\ibm\imnnq\imqenv.bat if exist c:\progra~1\ibm\imnnq\imnenv.bat call c:\progra~1\ibm\imnnq\imnenv.bat set db2instance=db2 set classpath=.;c:\progra~1\sqllib\java\db2java.zip;c:\progra~1\sqllib\java\runtime.zip;c:\progra~1\sqllib\java\sqlj.zip;c:\progra~1\sqllib\bin set mdis_profile=c:\progra~1\sqllib\metadata\profiles set lc_all=zh_cn set include=c:\progra~1\sqllib\include;c:\progra~1\sqllib\lib;c:\progra~1\sqllib\templates\include set lib=c:\progra~1\sqllib\lib set db2path=c:\progra~1\sqllib set db2tempdir=c:\progra~1\sqllib set vws_templates=c:\progra~1\sqllib\templates set vws_logging=c:\progra~1\sqllib\logging set vwspath=c:\progra~1\sqllib set vws_folder=ibm db2 set icm_folder=消息目次处置器 win

DB2编程序技巧 (七)

相关推荐

推荐下载

热门阅览

最新排行