如何获得代理ID [英] how to get agent id
问题描述
你好,
当我连接到数据库并且运行一些sql时,我怎样才能检索代理ID?
>
我可以做点什么
db2连接数据库1
agent_id = db2" select * from abc"
hello,
How can i retreive agent id in return when i connect to database and
run some sql?
can i do something like
db2 connect to database1
agent_id = db2 "select * from abc"
推荐答案
crazy_jutt写道:
crazy_jutt wrote:
hello,
当我连接到数据库时,如何回复代理ID以及
运行一些sql?
我可以做类似的事情
db2连接数据库1
agent_id = db2" select * from abc"
hello,
How can i retreive agent id in return when i connect to database and
run some sql?
can i do something like
db2 connect to database1
agent_id = db2 "select * from abc"
您可以编写一个不带隔离的UDF来调用C函数getpid。并且
返回其结果。根据您的平台,您可能还需要线程ID
。
但真正的问题是:你想用这个号码做什么? ?
-
Knut Stolze
DB2信息集成开发
IBM德国>
我正在使用unix管道加载管道
有时加载失败并且导出仍然继续将数据推入管道
i想要加载失败时杀死导出,反之亦然
Knut Stolze写道:
I am doing load pipe using unix pipes
sometime load fails and export still keep on pushing data into pipe
i want to kill that export when load fails and vise versa
Knut Stolze wrote:
crazy_jutt写道:
crazy_jutt wrote:
你好,
当我连接到数据库并且运行某些sql时,我怎样才能检索代理ID?
我可以做点什么
db2连接数据库1
agent_id = db2" select * from abc" ;
hello,
How can i retreive agent id in return when i connect to database and
run some sql?
can i do something like
db2 connect to database1
agent_id = db2 "select * from abc"
您可以编写一个不带隔离的UDF来调用C函数getpid并且
返回其结果。根据您的平台,您可能还需要线程ID
。
但真正的问题是:你想用这个号码做什么? ?
-
Knut Stolze
DB2信息集成开发
IBM德国
You could write a not fenced UDF that invokes the C function "getpid" and
return its result. Depending on your platform, you may need the thread-id
as well.
But the real question is: what do you want to do with this number?
--
Knut Stolze
DB2 Information Integration Development
IBM Germany
如下所示:
SELECT
APPL.AGENT_ID
FROM
TABLE(SNAPSHOT_APPL_INFO(''<你的数据库名称>'', - 1))AS APPL
WHERE
APPL.APPL_ID =(VALUES APPLICATION_ID());
和扩展名
BEGIN ATOMIC
DECLARE AGNT BIGINT; -
SET AGNT =
(SELECT
APPL.AGENT_ID
FROM
TABLE(SNAPSHOT_APPL_INFO(''CSE1DV00'', - 1))AS APPL
WHERE
APPL.APPL_ID =(VALUES APPLICATION_ID())); -
结束;
HTH,
- 杰夫
crazy_jutt写道:
How about something like:
SELECT
APPL.AGENT_ID
FROM
TABLE (SNAPSHOT_APPL_INFO(''<YOUR DB NAME>'',-1)) AS APPL
WHERE
APPL.APPL_ID = (VALUES APPLICATION_ID());
and by extension
BEGIN ATOMIC
DECLARE AGNT BIGINT;--
SET AGNT =
(SELECT
APPL.AGENT_ID
FROM
TABLE (SNAPSHOT_APPL_INFO(''CSE1DV00'',-1)) AS APPL
WHERE
APPL.APPL_ID = (VALUES APPLICATION_ID()));--
END;
HTH,
--Jeff
crazy_jutt wrote:
hello,
当我连接到数据库时,如何回复代理ID以及
运行一些sql?
我可以做点什么
db2连接数据库1
agent_id = db2" select *来自abc
hello,
How can i retreive agent id in return when i connect to database and
run some sql?
can i do something like
db2 connect to database1
agent_id = db2 "select * from abc"
这篇关于如何获得代理ID的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!