In SAS^® Fraud Management, you are unable to add or change LIBNAME and SQL pass-through options that the rule test and estimation use. Using various database options, for example, might improve rule test and estimation performance in certain scenarios. 

To address this issue, there are new environment variables that you can add to the PooledWorkspaceServer_usermods.sh file located in the following directory: <SASConfig>/Lev<n>/<impl-name>/PooledWorkspaceServer.  

For each environment variable that you want to use, add two lines of code to PooledWorkspaceServer_usermods.sh. The format of the lines is as follows:

<env-var>=”<db-options>”

export <env-var>

• Replace <env-var> with the environment variable name.  
• Replace <db-options> with the options that you want to use.

After you make the changes, restart the SAS servers.

The environment variables for PostgreSQL, Oracle, and IBM DB2 are listed below.

PostgreSQL

• POSTGRES_LIBNAME_OPTIONS
• POSTGRES_LIBNAME_OPTIONS_SOR
• POSTGRES_LIBNAME_OPTIONS_TDR
• POSTGRES_PASSTHRU_OPTIONS
• POSTGRES_PASSTHRU_OPTIONS_SOR
• POSTGRES_PASSTHRU_OPTIONS_TDR

Oracle

• ORACLE_LIBNAME_OPTIONS
• ORACLE_LIBNAME_OPTIONS_SOR
• ORACLE_LIBNAME_OPTIONS_TDR
• ORACLE_PASSTHRU_OPTIONS
• ORACLE_PASSTHRU_OPTIONS_SOR
• ORACLE_PASSTHRU_OPTIONS_TDR

IBM DB2

• DB2_LIBNAME_OPTIONS
• DB2_LIBNAME_OPTIONS_SOR
• DB2_LIBNAME_OPTIONS_TDR
• DB2_PASSTHRU_OPTIONS
• DB2_PASSTHRU_OPTIONS_SOR
• DB2_PASSTHRU_OPTIONS_TDR

Here are some examples:

PostgreSQL

POSTGRES_LIBNAME_OPTIONS="conopts='UseDeclareFetch=1;FetchSize=100000'"
export POSTGRES_LIBNAME_OPTIONS

Oracle

ORACLE_PASSTHRU_OPTIONS="dbmax_text=32767"
export ORACLE_PASSTHRU_OPTIONS

IBM DB2

DB2_LIBNAME_OPTIONS_SOR="dbmax_text=32767"
export DB2_LIBNAME_OPTIONS_SOR

See the SAS^® Fraud Management 6.1: SAS^® Rules Studio User’s Guide for more information. (Note that the new version of this documentation will be available after the hot fix is released.)