Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.


This article describes a software update that lets the Microsoft Service for Distributed Relational Database Architecture (DRDA) activate permissions that are associated with an application role that's defined in a SQL Server database.

Software update information

A supported feature that changes the product's default behavior is now available from Microsoft Support. However, this feature is intended to change only the behavior that this article describes. Apply it only to systems that specifically require it.

This update is included in Cumulative Update 1 for Host Integration Server 2013.

After you apply the update, the Microsoft Service for DRDA is updated to support calling SQL Server system stored procedures, such as sp_setapprole. To call a SQL Server system stored procedure, such as sp_setapprole, you have to use a COBOL program on an IBM mainframe that uses static SQL to call the remote SQL Server system by using a CALL statement with parameters. The following example contains COBOL code that shows how to call the sp_setapprole stored procedure by passing two required parameters:

01 ROLENAM1                       PIC X(8).
01 PASSWD1                        PIC X(9).

MOVE 'approle1' TO ROLENAM1.                                 
MOVE 'Password1' TO PASSWD1.

EXEC SQL                                                    
     CALL NWIND.SYS.SP_SETAPPROLE                            

More Information

An application role in SQL Server is used to let an application run under a specific set of permissions. For more information about application roles, see the Application Roles topic in the SQL Server 2012 documentation. You enable application roles in SQL Server by calling the sp_setapprole stored procedure.

Frequently, access to data in a SQL Server databases is enabled based on application roles. By calling the sp_setapprole stored procedure through the Microsoft Service for DRDA, you let customers who use application roles manage access to SQL Server databases when they are being integrated with IBM DB2 databases.

The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!