Syntax Rules for Stored Procedures

Use of parentheses and quotes in stored procedure calls varies, depending on whether you enter the procedure name directly, as you can in Interactive SQL, or invoke it with a CALL statement.

Some variations are permitted because the product supports both Sybase IQ SQL and Transact-SQL syntax. If you need Transact-SQL compatibility, be sure to use Transact-SQL syntax.

Stored Procedure Syntax Variations

Syntax

Syntax type

Explanation

procedure_name ('param')

Sybase IQ

Quotes are required if you enclose parameters in parentheses.

procedure_name 'param'

Sybase IQ

Parentheses are optional if you enclose parameters in quotes.

procedure_name param

Transact-SQL

If you omit quotes around parameters, you must also omit parentheses.
Note: Quotes are always required around parameters when the owner is specified. For example, assuming the owner is dba,
sp_iqtablesize 'dba.emp1'
requires quotes around the parameters.
sp_iqtablesize emp1
does not.
procedure_name

Sybase IQ IQ or Transact-SQL

Use this syntax if you run a procedure with no parameters directly in Interactive SQL, and the procedure has no parameters.

call procedure_name (param=’value’)

Sybase IQ

Use this syntax to call a procedure that passes a parameter value.

When you use Transact-SQL stored procedures, you must use the Transact-SQL syntax.