I want to create a trigger after the table is modified, I want to get the application name which modify the table in the trigger action, I know that there are function like application() in other database, what can I do in DB2? thanks in advance~

see : SELECT APPLICATION_ID() AS APPL_ID
FROM SYSIBM.SYSDUMMY1

Best regards, Guy Przytula

hi,przytula
when i use your sql,i got the wrong message like this:
##########
SQL0440N No function by the name "APPLICATION_ID" having compatible arguments
was found in the function path. SQLSTATE=42884
##########
both i have tried on v7 and v8,are u sure with your sql?
regards

Check out these special registers as documented in the SQL Reference, Vol 1:

CLIENT ACCTNG
CLIENT APPLNAME
CLIENT USERID
CLIENT WRKSTNNAME

The Application_id() seems to be a new function in 8.2