| 发表于:2007-12-17 14:56:582楼 得分:0 |
调用存储过程sysproc.db2load 其定义: - sql code
create procedure sysproc.db2load
(
in version_number integer,
in cursor_statement varchar(32672),
in load_command varchar(32672),
out sqlcode integer,
inout sqlmessage varchar(2048),
out rows_read bigint,
out rows_skipped bigint,
out rows_loaded bigint,
out rows_rejected bigint,
out rows_deleted bigint,
out rows_committed bigint,
out rows_part_read bigint,
out rows_part_rejected bigint,
out rows_part_partitioned bigint,
inout mpp_load_summary varchar(32672)
)
specific db2load
language c
parameter style db2sql
not fenced
modifies sql data
program type main
external name 'system_routine~db2load!db2load'
- java code
callablestatement cs = connection.preparecall("{call sysproc.db2load(1,'','" + loadcommand + "',?,?,?,?,?,?,?,?,?,?,?,?)}");
cs.registeroutparameter(constants.num_1, types.integer);
cs.setstring(constants.num_2, "");
cs.registeroutparameter(constants.num_2, types.varchar);
cs.registeroutparameter(constants.num_3, types.bigint);
cs.registeroutparameter(constants.num_4, types.bigint);
cs.registeroutparameter(constants.num_5, types.bigint);
cs.registeroutparameter(constants.num_6, types.bigint);
cs.registeroutparameter(constants.num_7, types.bigint);
cs.registeroutparameter(constants.num_8, types.bigint);
cs.registeroutparameter(constants.num_9, types.bigint);
cs.registeroutparameter(constants.num_10, types.bigint);
cs.registeroutparameter(constants.num_11, types.bigint);
cs.setstring(constants.num_12, "");
cs.registeroutparameter(constants.num_12, types.varchar);
cs.EXECute();
sqlcode = cs.getint(1);
| | |
|