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