Basic Language Elements › SQL Parameters

SQL Parameters

An SQL parameter is a parameter that is passed to an SQL Procedure (a LANGUAGE SQL procedure). In SQL Procedures, SQL parameters can be used anywhere expressions are allowed. They cannot be used outside of procedures except as keyword parameters in the CALL and EXECUTE statements. When used in an SQL Procedure containing an SQL variable with a conflicting (matching) name, or in a statement containing a table or view reference where the table or view contains a conflicting column name, the name should be qualified using the procedure name. The syntax of an SQL parameter follows:

►►─┬──────────────┬─ SQL-parameter-name ──────────────────────────────────────►◄
   └─ proc-name. ─┘

Note: The proc-name is discussed further in the CREATE PROCEDURE section. The proc-name can be qualified by an authorization ID.

The SQL-parameter-name is discussed further in the CREATE PROCEDURE section.