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 wrote:

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

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:

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:

how can i use this in dynamic SQL ?

jefftyzzer wrote:

jefftyzzer wrote:
APPL.APPL_ID = APPLICATION_ID() ??

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/

Doh! Nothing speaks against it--I just like to waste keystrokes :-).
Good catch.

-- Jeff

Serge Rielau wrote:

thanks guys
i got it

here it what i did

db2 -x "SELECT APPL.AGENT_ID FROM TABLE(SNAPSHOT_APPL_INFO('PROD1',-2))
AS APPL WHERE APPL.APPL_ID = (VALUES APPLICATION_ID())" | read agent_id
echo ${agent_id}




jefftyzzer wrote:

are there more functions like this
i know there must not be function like AGENT_ID() otherwise you guys
must have mentioned but i am curious if there are more functions like
this which could be useful





crazy_jutt wrote:

First thing: as Serge pointed out, you don't need "= VALUES(...", just
call the function directly as he illustrated--my mistake. As to your
question, I wouldn't say there are many functions like that, but there
is a lot of information available in snapshot table functions like
SNAPSHOT_APPL and SNAPSHOT_APPL_INFO.

--Jeff

crazy_jutt wrote: