From the viewpoint of an ODBC-compliant data source, a stored procedure is a predefined procedure or set of statements or program that is defined for a specific data source according to that data source's rules. By executing the stored procedure, you execute these statements or programs without having to enter their individual statements or code at each execution.
Note: Even for data sources that do not support stored procedures, you can send statements directly to your data source using the RUNSTORED–PROCEDURE send–sql–statement syntax. For more information on sending SQL statements to the data source, see Sending SQL statements directly to the data source.