Rocket® Enterprise Developer (formerly a product of Micro Focus or formerly a product of Open Text) documentation, created before Rocket Software acquired certain products from OpenText, may include outdated references to "Micro Focus" or "OpenText", both of which are trademarks of OpenText or its affiliates. Rocket Software is not affiliated with Micro Focus or OpenText and has since rebranded these products as Rocket® products. You may also encounter outdated links in this documentation. If you do, please contact Rocket Support (support@rocketsoftware.com) for assistance.
Embedding a TSQL Stored Procedure into a Program
This procedure is also similar to that of embedding a standard SQL query into a program.
OpenESQL Assistant generates statements for both client and server programs. You can delete the statements which are not needed. If your program is the client program, the DROP and CREATE PROCEDURE statements are not necessary.
Note: If you test the query as outlined above, you do not need to run either the DROP or
CREATE PROCEDURE statements in a program as the TSQL stored procedure has already
been created. If the stored procedure has not already been created, then you need
to either add an SQL COMMIT statement or add directive SQL(AUTOCOMMIT) to the program
that issues the CREATE PROCEDURE. Otherwise the stored procedure is not saved to the
data source.