How-To use data from a dynamic SQL in a procedure
If you are using in your procedure a data load from the HANA model you may need to parametrize for example the Placeholders. I’m not aware about any possibility how to do that directly in the procedure but I may also be wrong, so if you know about the way, please leave the comment. Otherwise […]
How-To Create a temporary local table in a procedure
The temporary tables can be created at runtime and can be used for the same operations as the normal tables. But, based on the table types, the scope is limited. Temporary Tables lets you store and process intermediate results. Temporary tables only last as long as the session is alive. Data in temporary tables is […]
How-To SAP® HANA Procedures
Find Procedure To find procedure, standard HANA table: “SYS”.”PROCEDURES”, can be used. For example: Searching for Procedure, which contains specific code, the definition column can be used: select * from “SYS”.”PROCEDURES” where definition like ‘%???%’; Templates When creating SAP® HANA Procedures, I’m using SQL code and the following templates: Standard Procedure DROP procedure <procedure_name>; […]
How-To get metadata of HANA tables
Relevant useful links Selection example with CDATA search API to get the Metadata of the HANA view Columns for a specific table or model SELECT SCHEMA_NAME, TABLE_NAME, COLUMN_NAME, POSITION FROM SYS.COLUMNS where SCHEMA_NAME = ‘_SYS_BIC’ and TABLE_NAME = ‘???’ order by position; An alternative in case of authorization problems: SELECT SCHEMA_NAME, VIEW_NAME, POSITION, COLUMN_NAME, […]