Deferred Name Resolution for User-Defined Stored Procedures

Deferred name resolution lets you create a stored procedure before referenced objects exist.

In versions of Adaptive Server earlier than 15.5, referenced objects were required to already exist before the stored procedure using them could be created. The deferred name resolution feature now allows objects, except for user-defined datatype objects, to be resolved when the stored procedure is executed for the first time.

This feature uses the deferred name resolution configuration parameter, which operates at the server level, or a new set command, set deferred_name_resolution, which operates at the connection level.

See the Transact-SQL Guide, the System Administration Guide: Volume 1, and the Reference Manual: Commands.