描述非表对象 [英] Describe non-table objects
问题描述
大家好，
如何使用db2的普通命令行界面描述非表对象，如UDF函数和
过程？b / b
数据库服务器= DB2 / LINUX 9.1.0在Linux 2.6上运行的Express-C
Intel-32。
问候，
Serman D.
-
Hi all,
How do I describe non-table objects, like UDF functions and
procedures, using db2''s normal command line interface?
Database server = DB2/LINUX 9.1.0 Express-C running on Linux 2.6
Intel-32.
Regards,
Serman D.
--
推荐答案
2月19日晚上7点35分，Serman D. < serma ... @ hotmail.comwrote：
On Feb 19, 7:35 pm, "Serman D." <serma...@hotmail.comwrote:
大家好，
如何描述非表对象，像UDF函数和
程序，使用db2的正常命令行界面？
数据库服务器= DB2 / LINUX 9.1.0 Express-C运行在Linux 2.6上
Intel-32。
问候，
Serman D.
-
Hi all,
How do I describe non-table objects, like UDF functions and
procedures, using db2''s normal command line interface?
Database server = DB2/LINUX 9.1.0 Express-C running on Linux 2.6
Intel-32.
Regards,
Serman D.
--
从syscat.functions中选择body（funcschema，funcname）=（？，？）
选择文本fropm syscat .procedures where（procschema，procname）=
（？，？）
HTH
/ Lennart
select body from syscat.functions where (funcschema, funcname) = (?,?)
select text fropm syscat.procedures where (procschema, procname) =
(?,?)
HTH
/Lennart
Lennart写道：
Lennart wrote:
2月19日下午7:35，Serman D. < serma ... @ hotmail.comwrote：
On Feb 19, 7:35 pm, "Serman D." <serma...@hotmail.comwrote:
>大家好，
如何描述非表格对象，如UDF函数和程序，使用db2的正常命令行界面？
数据库服务器= DB2 / LINUX 9.1.0在Linux 2.6上运行的Express-C
Intel-32 。
>Hi all,
How do I describe non-table objects, like UDF functions and
procedures, using db2''s normal command line interface?
Database server = DB2/LINUX 9.1.0 Express-C running on Linux 2.6
Intel-32.
从syscat.functions中选择body（funcschema，funcname）=（？，？）
选择文本fropm syscat .procedures where（procschema，procname）=
（？，？）
select body from syscat.functions where (funcschema, funcname) = (?,?)
select text fropm syscat.procedures where (procschema, procname) =
(?,?)
实际上，SYSCAT.FUNCTIONS和SYSCAT.PROCEDURES都已过时并且
不应再使用了。相反，请参阅SYSCAT.ROUTINES：
SELECT text
FROM syscat.routines
WHERE（routine_schema，routine_name）=（ ？，？）
-
Knut Stolze
DB2 z / OS实用程序开发
IBM德国
Actually, SYSCAT.FUNCTIONS and SYSCAT.PROCEDURES are both outdated and
should not be used any longer. Instead, refer to SYSCAT.ROUTINES:
SELECT text
FROM syscat.routines
WHERE ( routine_schema, routine_name ) = ( ?, ? )
--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
2月19日9:03 pm，Knut Stolze< sto ... @ de.ibm.comwrote：
[ ...]
On Feb 19, 9:03 pm, Knut Stolze <sto...@de.ibm.comwrote:
[...]
实际上，SYSCAT.FUNCTIONS和SYSCAT.PROCEDURES都已过时且不应再使用
了。相反，请参阅SYSCAT.ROUTINES：
SELECT text
FROM syscat.routines
WHERE（routine_schema，routine_name）=（ ？，？）
Actually, SYSCAT.FUNCTIONS and SYSCAT.PROCEDURES are both outdated and
should not be used any longer. Instead, refer to SYSCAT.ROUTINES:
SELECT text
FROM syscat.routines
WHERE ( routine_schema, routine_name ) = ( ?, ? )
Thanx，我当时并不知道。这是V9的新功能吗？
/ Lennart
Thanx, I wasn''t aware of that. Is this new for V9?
/Lennart
这篇关于描述非表对象的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
