Hi:
How to get the Login Id in Stored Procedure ?
I've tried to post this question several times but have not gotten any response!
I really need to get user's logon-id from DB2 Stored Procedure to do some table-joins to filter data before sending the data to the Crystal Reports.
So here is what I really need:
1) User logon the Crystal Enterprise with an Id such as X123456.
2) The user runs a report using a DB2 Stored Procedure to pull the data.
3) Inside the stored procedure I need to use the user's login-id part of the SQL to filter the data such as SELECT * from table1 where table1.user_id = login-id;
Hope some one can help!
IP Logged
