Home

	Expand Search

Access Service User's Guide DirectConnect Anywhere

Chapter 2 Configuring the DirectConnect Access Service Library

Catalog Stored Procedures properties

Catalog Stored Procedures properties

These properties control the information an access service returns from catalog stored procedures.

Many of the properties in this group are not supported, nor do they affect the DirectConnect Anywhere Access Service. These properties are available for compatibility purposes only.

The subsection heading and configuration property list must appear in the service library configuration file as follows:

{Catalog Stored Procedures}
 CSPExclusions=
 CSPIncludeAlias=
 CSPIncludeSynonym=
 CSPIncludeSystem=
 CSPIncludeTable=
 CSPIncludeView=
 DatatypeInfo=
 SQLInformationFile=(not  supported)

CSPExclusions

Specifies that an access service limits access to information normally returned from sp_tables upon authorization.

Syntax

CSPExclusions=[ none | user | nonauth |nonauthpublic ]

Default

user

Values

• none specifies no exclusions, based upon authorization to information.

• user specifies exclusions, based upon specific user authorization to information.

• nonauth specifies that a user must be granted user or group authorization to access information.

• nonauthpublic specifies that a user must be granted user authorization, or PUBLIC is granted some authorization.

Comment

This property is not supported and does not affect the DirectConnect Anywhere Access Service. It is available for compatibility purposes only.

CSPIncludeAlias

Specifies that the access service returns information about aliases from sp_tables.

Syntax

CSPIncludeAlias=[no | yes]

Default

no

Values

• no specifies that the access service does not return alias information.

• yes specifies that the access service returns alias information.

Comment

This property is not supported and does not affect the DirectConnect Anywhere Access Service. It is available for compatibility purposes only.

CSPIncludeSynonym

Specifies that the access service returns information about synonyms from sp_tables.

Syntax

CSPIncludeSynonym=[no | yes]

Default

no

Values

• no specifies that the access service does not return synonym information.

• yes specifies that the access service returns synonym information.

CSPIncludeSystem

Specifies that the access service returns information about system tables from sp_tables.

Syntax

CSPIncludeSystem=[no | yes]

Default

no

Values

• no specifies that the access service does not return system table information.

• yes specifies that the access service returns system table information.

Comment

The user issuing sp_tables must be authorized to query these tables.

CSPIncludeTable

Specifies that the access service returns information about tables from sp_tables.

Syntax

CSPIncludeTable=[yes | no]

Default

yes

Values

• yes specifies that the access service returns table information.

• no specifies that the access service does not return table information.

CSPIncludeView

Specifies that the access service returns information about views from sp_tables.

Syntax

CSPIncludeView=[yes | no]

Default

yes

Values

• yes specifies that the access service returns view information.

• no specifies that the access service does not return view information.

DatatypeInfo

Specifies the type of datatype information returned from sp_datatype_info.

Syntax

DatatypeInfo=[transact | target]

Default

transact

Values

• transact specifies that sp_datatype_info returns the TSQL datatypes that map to the ODBC datatypes that the target supports.

• target specifies that sp_datatype_info returns target datatype names.

SQLInformationFile (not supported)

Specifies the file that contains extension information that cannot be derived from the SQLGetInfo function call.

Syntax

SQLInformationFile=filename

Range

0-128 characters

Default

odbc.sif

Value

filename is the file name or path and file name

Comments

Not supported