These syntactical rules apply to CSPs:
Arguments can be delimited with commas and identified by position:
sp_columns parm1,parm2
Arguments can be identified using the keyword NULL:
sp_columns NULL, NULL, parm3
Empty arguments can be identified using empty strings:
sp_columns ’ ’,’ ’,smith
Arguments can be named using the syntax @name=parm:
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 Adaptive Server Enterprise Reference Manual.
