Run Stored-Proc statement execution using the send-sql-statement option
- Last Updated: January 17, 2024
- 1 minute read
- OpenEdge
- Version 12.8
- Documentation
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.