Catalog Stored Procedure properties

Table 3-4 shows catalog stored procedure (CSP) properties and associated global variables and set statements.

Table 3-4: CSP properties

Configuration property

Global variable and set statement

CSPCatalogQualifier

select @@CSPCatalogQualifier

set CSPCatalogQualifier

CSPDBName

select @@CSPDBName

set CSPDBName {NULL |dbname}

CSPExclusions

select @@CSPExclusions

set CSPExclusions {none | user | nonauth | nonauthpublic}

CSPIncludeAlias

select @@CSPIncludeAlias

set CSPIncludeAlias {no | yes}

CSPIncludeSynonym

select @@CSPIncludeSynonym

set CSPIncludeSynonym {no | yes}

CSPIncludeSystem

select @@CSPIncludeSystem

set CSPIncludeSystem {no | yes}

CSPIncludeTable

select @@CSPIncludeTable

set CSPIncludeTable {yes | no}

CSPIncludeView

select @@CSPIncludeView

set CSPIncludeView {yes | no}

CSPQualByDBName

select @@CSPQualByDBName

set CSPQualByDBName {no | yes}

DatatypeInfo

select @@DatatypeInfo

set DatatypeInfo {transact | target}