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.