Specify DBMS Type for the Output Library

To use a non-SAS database for the Profitability Management output library, you must specify its DBMS type, using SAS Management Console.

1. Open SAS Management Console.

2. Expand the SAS Libraries folder (under Environment Management Data Library Manager) and select your Profitability Management output library.

   

3. Right-click the library and select Properties.

4. Select the Extended Attributes tab.

5. Click New.

6. In the Field Name column, type DBMSType.

   

7. In the Value and Description columns, type one of the following pairs (the Description is optional):

   Value	Description
   MSSQL	Microsoft SQL Server
   Oracle	Oracle
   DB2	DB2
   MySql	MySql
   Jet	MS Access

   For example:

   

8. Click OK.