Kontakt

Ansicht
Dokumentation

ABENSQL_SCRIPT - SQL SCRIPT

ABENSQL_SCRIPT - SQL SCRIPT

ROGBILLS - Synchronize billing plans   ABAP Short Reference  
This documentation is copyright by SAP AG.
SAP E-Book

Database Procedure Proxies for SQLScript Procedures in the SAP HANA Repository

When calling SQLScript procedures in the SAP HANA Repository, the Native SQL and AMDP methods exist alongside the special statement CALL DATABASE PROCEDURE, which can be used to access the database procedure using a database procedure proxy stored in the ABAP Dictionary. The database procedure proxy maps the database types of the interface parameters of the database procedures to ABAP data types. A database procedure interface is generated for these data types. The calling ABAP program can reference the types of this global interface.

Notes

  • ABAP Managed Database Procedures (AMDP) offers an alternative way of managing and calling database procedures in ABAP. It is far easier to handle database procedures using AMDP than with the calls using database procedure proxies described here, which is why AMDP is recommended whenever the standard database of the current AS ABAP is an SAP HANA database and no secondary connection to another SAP HANA database is needed.
  • SQLScript procedures in SAP HANA XSC are stored in the SAP HANA Repository and database procedure proxies can be used to call them from ABAP.

  • SQLScript procedures in SAP HANA XSA, the successor to SAP HANA XSC, are usually HDI objects for which no database procedure proxies can be created. Alternative methods such as AMDP or ADBC must be used for these calls instead.

SAP HANA XSC is not supported by a SAP HANA Cloud database and Database Procedure Proxies cannot be used there.





Addresses (Business Address Services)   BAL Application Log Documentation  
This documentation is copyright by SAP AG.

Length: 3728 Date: 20240423 Time: 080626     sap01-206 ( 66 ms )