Chapter 11: Accessing Catalog Information with CSPs

Syntax

The following syntactical rules apply to CSPs:

Arguments can be delimited with commas and identified by position, as shown:
```
sp_columns parm1,parm2
```
Arguments can be identified using the keyword NULL, as shown:
```
sp_columns NULL, NULL, parm3
```
Empty arguments can be identified using empty strings, as shown:
```
sp_columns ’ ’,’ ’,smith
```
Arguments can be named using the syntax @name=parm, as shown:
```
sp_columns @table_owner=smith
```

The positional forms (1, 2, and 3) cannot be mixed with the named form (4).

The Access Service Library does not support the TABLE_QUALIFIER or PROCEDURE_QUALIFIER parameters. For all CSPs, leave the parameter empty or set it to NULL.

The argument syntax for most of the CSPs referenced in this chapter is contained in the Sybase Adaptive Server Reference Manual, v 2.

View this book as PDF