Run Stored-Proc statement execution using the send-sql-statement option

ABL also allows you to use stored-procedure syntax to send SQL statements and their native language extensions directly to a data source. The DataServer uses the RUN STORED-PROCEDURE statement with the send-sql-statement option to pass SQL statements to the data source. This option gives you access to Transact-SQL, providing you access to business logic for MS SQL Server. For example, you can issue Data Definition Language (DDL) statements from within OpenEdge procedures. You can send multiple SQL statements by concatenating them and passing the string as a single parameter to the send-sql-statement option.

Like the option to define a RUN STORED-PROC statement either with or without the LOAD-RESULT-INTO options, you can define a send-sql-statement with or without the LOAD-RESULT-INTO option. The following section presents and briefly describes a sample use of each technique.