When writing HANA SQL you sometimes need access to more advanced features in the SQL script.
To enable the features you will need to wrap your SQL with a DO BEGIN END statement. This feature has been available in SAP HANA since HANA SP10.
Below is a sample on how to use DECLARE in HANA SQL in a SQL report:
SQL for copy/paste :)
Declare StartDate DATETIME = [%0];
Declare EndDate DATETIME = [%1];
Where ORDR."DocDate" between StartDate and EndDate;
Thanks, a trillion mate!
It works like charm, saved a lot of energy & time.
I have a seldom problem. Just to give some back ground.
Here is the problem.
Here is my code approach.
I'm not sure how to approach the updating part. I cannot use MODIFY as I have to get the entire table data SAP HANA training USA (which is huge performance).
Just for Info we are using HANA DB.
Appreciate your effort for making such useful blogs and helping the community.
Please sign in to leave a comment.