您的位置:程序门 -> db2 -> 基础类



如何在java代码中执行db2 load命令导入数据!


[收藏此页] [打印本页]选择字色:背景色:字体:[][][]


如何在java代码中执行db2 load命令导入数据!
发表于:2007-12-14 21:51:08 楼主
如何在java代码中执行db2   load命令导入数据!
发表于:2007-12-17 10:15:301楼 得分:0
需要用java执行外部命令,jdbc应该不支持直接用load
发表于:2007-12-17 14:56:582楼 得分:0
调用存储过程sysproc.db2load
其定义:
sql code
create procedure sysproc.db2load ( in version_number integer, in cursor_statement varchar32672), in load_command varchar32672), out sqlcode integer, inout sqlmessage varchar2048), 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 varchar32672) ) 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);
发表于:2007-12-17 16:43:373楼 得分:0
标记一下,学习。
发表于:2007-12-29 16:07:084楼 得分:0
学习.....


快速检索

最新资讯
热门点击