system_odbc.ini default parameters description as CatalogOptions and others in Policy Server

Products

• SITEMINDER

Issue/Introduction

What is the usage of the below Policy Server default parameters in use in the system_odbc.ini file while adding a DSN?

CatalogOptions=0
ProcedureRetResults=0
EnableDescribeParam=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1

Resolution

The parameters are from the Progress (DataDirect) driver, and descriptions come from the Progress (DataDirect) documentation (1)(2)(3)(4)(5).

Additional Information

1. Catalog Options
   
   
2. Procedure Returns Results
   
   
3. Enable SQLDescribeParam
   
   
4. Enable Static Cursors for Long Data
   
   
5. Application Using Threads