Chapter 3: Querying and Setting Operating Values

Catalog Stored Procedure properties

The following table shows Catalog Stored Procedure (CSP) properties and associated global variables and set statements.

**Table 3-4: Catalog Stored Procedure 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}