Can I capture an application name with SQL???

[hopper]

I'm new to DB2 so if this is obvious please forgive me...

I have several .NET application that will be accessing our DB2 v7 mainframe database (more specifically a view). I have the authorized application names stored in another table. I need to see if it is possible to capture the calling application name using SQL. Something like this:

SELECT AppName FROM tblAuthorizedApps WHERE AppName = <???>

where <???> is some sort of system variable that holds the calling application name.

Is something like this possible or am I just dreaming?

Thanks,

Scott

 

[sathyarams]

See if this link helps

http://www-106.ibm.com/developerworks/db2/library/techarticle/0302stolze/0302stolze.html

For db2 resoruces visit

http://www.db2click.com

More DB2 questions answered at

http://www.dbforums.com/f8

 

[hopper]

Thank you, that helps very much!!!!!