无法在Navigator中浏览存储过程 [英] Can't browse stored procedure in Navigator
问题描述
我根据CL / COBOL
程序创建了一个名为MANLIB.MAN535CL的存储过程。
我知道它的工作原理是因为我可以成功运行它。
但是，我真的不明白它在iSeries上的位置。
例如，如果我使用Navigator浏览数据库部分，那里
是一个数据库，s10cd4b。在那之下是模式。
的部分有QGPL和QTEMP，其下是程序。其中任何一个都没有
条目？
那么，IFS上的存储过程是什么？
或其他地方？
-
Texeme Construct
http://www.myspace.com/texeme
右键单击在Schemas上，单击选择要显示的模式。并添加
MANLIB。现在深入查看MANLIB存储过程，然后你就会看到
。
存储过程定义也可以通过以下方式看到：
SELECT * FROM SYSPROCS
John Bailo写道：
我创建了一个名为MANLIB.MAN535CL的存储过程基于CL / COBOL
计划。
我知道它有效，因为我可以成功运行它。
但是，我真的不明白它在iSeries上的位置。
例如，如果我使用Navigator来浏览数据库。部分，那里
是一个数据库，s10cd4b。在那之下是模式。
的部分有QGPL和QTEMP，其下是程序。其中任何一个都没有
条目？
那么，IFS上的存储过程是什么？
或其他地方？
-
Texeme Construct
http://www.myspace.com/texeme
John Bailo写道：
< blockquote class =post_quotes>
>
我根据CL / COBOL
程序创建了一个名为MANLIB.MAN535CL的存储过程。
我知道它有效，因为我可以成功运行它。
但是，我真的不明白它在iSeries上的位置。
例如，如果我使用Navigator浏览数据库部分，那里
是一个数据库，s10cd4b。在那之下是模式。
的部分有QGPL和QTEMP，其下是程序。其中任何一个都没有
条目？
那么，IFS上的存储过程是什么？
或其他地方？
如果你没有使用
CREATE PROCEDURE（EXTERNAL）语句向DB2注册你的程序，你就不会去
将其视为使用Navigator的程序。
John Bailo写道：
>
我根据CL / COBOL
程序创建了一个名为MANLIB.MAN535CL的存储过程。
我知道它有效，因为我可以成功运行它。
但是，我真的不明白它在iSeries上的位置。
例如，如果我使用Navigator浏览数据库，部分，那里
是一个数据库，s10cd4b。在那之下是模式。
的部分有QGPL和QTEMP，其下是程序。其中任何一个都没有
条目？
您需要将MANLIB添加到
数据库下的模式列表中。
1展开Databases文件夹，然后展开Schemas
（如果你是V5R2或更低版本，则称为Libraries）。
2.右键单击Schemas / Libraries，然后选择
选择要显示的新模式/库。
3.在输入模式/库中输入MANLIB和
单击添加，然后单击确定。
4. MANLIB现在应该出现在你的架构/
库列表中，你应该能够找到你的
程序。 />
那么，IFS上的存储过程是什么？
或其他地方？
I created a stored procedure called MANLIB.MAN535CL based on a CL/COBOL
program.
I know it works because I can run it successfully.
However, I don''t really understand where it is on the iSeries.
For example, if I use Navigator to browse the "Databases" section, there
is one database, s10cd4b. Under that is the "schemas" section which
has QGPL and QTEMP and under those is "Procedures". There are no
entries under either of those?
So, is the stored procedure on the IFS?
Or somewhere else?
--
Texeme Construct
http://www.myspace.com/texeme
Right-Click on Schemas and click on "Select schemas to display" and add
MANLIB to it. Now drill down to MANLIB Stored Procedures and you
should see it.
Stored procedure definitions can also be seen by doing:
SELECT * FROM SYSPROCS
John Bailo wrote:I created a stored procedure called MANLIB.MAN535CL based on a CL/COBOL
program.
I know it works because I can run it successfully.
However, I don''t really understand where it is on the iSeries.
For example, if I use Navigator to browse the "Databases" section, there
is one database, s10cd4b. Under that is the "schemas" section which
has QGPL and QTEMP and under those is "Procedures". There are no
entries under either of those?
So, is the stored procedure on the IFS?
Or somewhere else?
--
Texeme Construct
http://www.myspace.com/texeme
John Bailo wrote:>
I created a stored procedure called MANLIB.MAN535CL based on a CL/COBOL
program.
I know it works because I can run it successfully.
However, I don''t really understand where it is on the iSeries.
For example, if I use Navigator to browse the "Databases" section, there
is one database, s10cd4b. Under that is the "schemas" section which
has QGPL and QTEMP and under those is "Procedures". There are no
entries under either of those?
So, is the stored procedure on the IFS?
Or somewhere else?If you didn''t register your program to DB2 with the
CREATE PROCEDURE (EXTERNAL) statement, you''re not going
to see it as a procedure using Navigator.
John Bailo wrote:
>
I created a stored procedure called MANLIB.MAN535CL based on a CL/COBOL
program.
I know it works because I can run it successfully.
However, I don''t really understand where it is on the iSeries.
For example, if I use Navigator to browse the "Databases" section, there
is one database, s10cd4b. Under that is the "schemas" section which
has QGPL and QTEMP and under those is "Procedures". There are no
entries under either of those?You need to add MANLIB to the list of schemas under
Databases.
1. Expand the Databases folder, then the Schemas
(called Libraries if you''re a V5R2 or lower).
2. Right click on Schemas/Libraries, then select
Select New Schemas/Libraries to Display.
3. In the Enter Schemas/Libraries enter MANLIB and
click Add, then click OK.
4. MANLIB should now appear in your list of schemas/
libraries, and you should be able to find your
procedure.
So, is the stored procedure on the IFS?
Or somewhere else?
这篇关于无法在Navigator中浏览存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
