Has anyone been successful getting the QSYGETPH & QWTSETP APIs working in a service to swap user profiles on the IBM i?

We are implementing database field encryption and I need to be able to elevate the authority during certain SQL statements to return unmasked data.

Rick

Hi Rick,

I did a google search and found numerous hits, such as:

http://www.ibm.com/support/knowledgecenter/ssw_i5_54/apis/QSYGETPH.htm

http://www.ibm.com/support/knowledgecenter/ssw_i5_54/apiref/apiexushand.htm?lang=en

If that doesn't give you what you need, you could try opening a PMR against the iSeries DB2 group and ask about this.

I spoke with IBM JAVA support. 

You can't call the APIs directly because that runs in a different job on the server which is not the same one that database requests are processed in.

You have to either call a stored procedure or create a new connection with the user profile that has elevated authority.

I chose stored procedure because I did not want to have to code a password into the service.

That's good information. 

Thanks Rick for clarifying this.