Stored procedure definitions

You can access data in a database using a stored procedure, if required.

To do so, you use an ODBC stage in a server job, or the STP stage in a server or parallel job (the STP stage has its own documentation, which is available when you install the stage).

A stored procedure can:

• Have associated parameters, which might be input or output
• Return a value (like a function call)
• Create a result set in the same way as an SQL SELECT statement
  Note: ODBC stages support the use of stored procedures with or without input arguments and the creation of a result set, but do not support output arguments or return values. In this case a stored procedure might have a return value defined, but it is ignored at run time. A stored procedure might not have output parameters.

The definition for a stored procedure (including the associated parameters and metadata) can be stored in the Repository. These stored procedure definitions can be used when you edit an ODBC stage or STP stage in your job design.

You can import, create, or edit a stored procedure definition using the Designer.