If a parameter value for a system procedure contains punctuation or embedded blanks,
or is a reserved word, you must enclose it in single or double quotes. If the parameter is an
object name qualified by a database name or owner name, enclose the entire name in single or
double quotes.
Note:
Do not use delimited identifiers as system procedure parameters; they may produce
unexpected results.
If a procedure has multiple optional parameters, you can supply parameters in the following
form instead of supplying all the
parameters:
@parametername = value
You can also use “null” as a placeholder for a parameter. Do not enclose “null” in quotes.
SQL has no rules about the number of words you can put on a line or where you must break a
line. If you issue a system procedure followed by a command, the SAP ASE server attempts to
execute the system procedure, then the command. For example, if you execute the following
command, the SAP ASE server returns the output from
sp_help, then runs
the
checkpoint
command:
sp_help checkpoint
If you specify more parameters than the number of parameters expected by the system
procedure, the extra parameters are ignored by the SAP ASE server.