如何在IBM System i Access for Windows GUI Tool中调用存储过程 [英] How to call a stored procedure in IBM System i Access for Windows GUI Tool

问题描述

我想测试在AS400系统上运行的DB2存储过程。

我已经安装了IBM System i Access for Windows，并可以运行SQL命令DB2数据库。

我的问题是：执行存储过程的语法是接收参数并返回结果作为输出参数，并将值打印到屏幕？

只是为了澄清：我不是问如何在代码中调用proc。我想执行proc并在gui工具中看到结果（类似于SQL企业管理器）。

解决方案

使用关键字调用并传入参数。

 调用myStoredProc（parm1 ，parm2，？）; 
  

有关详细信息，请参阅这里 http://www.ibm.com/developerworks/data/library/techarticle/dm-0503melnyk/ 。有趣的部分是图5.使用命令编辑器调用SQL过程

I would like to test a DB2 stored procedure running on an AS400 system.

I have the IBM System i Access for Windows installed and can run SQL commands against the DB2 database.

My question is: What is the syntax to execute a stored procedure that takes in a parameter and returns a result as an output parameter and print the value to the screen?

Just to clarify: I am not asking how to call the proc in code. I want to execute the proc and see the results in the gui tool (which is similar to SQL Enterprise Manager).

解决方案

use the keyword call and pass in the parameters.

call myStoredProc(parm1, parm2, ?);

for more details see here http://www.ibm.com/developerworks/data/library/techarticle/dm-0503melnyk/. The interesting part is Figure 5. Using the Command Editor to call an SQL procedure

这篇关于如何在IBM System i Access for Windows GUI Tool中调用存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！