I don't know if this is what you're looking but:
values (USER) will return the current authorization ID that is connected.
HTH,  Pierre.

"Stewart, Brian" wrote:

> Hello -
>
> Does anyone out there know how to determine the current user connected to
> DB2 from within an application connected to the database by that user. I
> know that you can use "select distinct user from tablename" but is there
> another way?
>
> Much TIA
>
> Brian
>
> =====
> To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
> For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
begin:vcard 
n:Saint-Jacques;Pierre
tel;cell:514-233-8679
tel;fax:514-737-1268
tel;work:514-737-4515
x-mozilla-html:FALSE
org:SES Consultants Inc.
adr:;;233 Simcoe Cr.;Mount-Royal;QC;H3P 1X1;Canada
version:2.1
email;internet:[EMAIL PROTECTED]
title:President
fn:Pierre Saint-Jacques
end:vcard

Reply via email to