Syntax

These syntactical rules apply to CSPs:

  1. Arguments can be delimited with commas and identified by position:

    sp_columns parm1,parm2
    
  2. Arguments can be identified using the keyword NULL:

    sp_columns NULL, NULL, parm3
    
  3. Empty arguments can be identified using empty strings:

    sp_columns ’ ’,’ ’,smith
    
  4. 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.