去门的另一边

环境为db2 8.2 中文版存储过程如下[code="java"]CREATE PROCEDURE PROC_HELLO_WORLD (OUT OUTARG VARCHAR(25), IN INARG VARCHAR(25)) LANGUAGE SQLBEGIN SET OUTARG = 'Hello ' || INARG;END[/code]调用方法...

一、加载数据： 1、 以默认分隔符加载,默认为“,”号    db2 "import from btpoper.txt of del insert into btpoper"2、 以指定分隔符“|”加载    db2 "import from btpoper.txt of del modified by coldel| insert into btpoper"二、卸载数据：...

--查询 表 tbl_demo 引用的表SELECT a.tabname, constrname, d.tabname FROM systables a, sysconstraints b, sysreferences C, systables d WHERE b.constrtype = 'R' AND a.tabid = b.tabid AND b....