Symptom
You will find new SQL syntax (functions and statements) for SAP HANA Platform SPS 09 in the attached document SAP_HANA_Platform_SPS_09_Syntax.pdf.
Other Terms
SAP HANA Database, SQL, hdb, SAP HANA platform, SAP HANA options
Reason and Prerequisites
A) SAP HANA Platform SQL Syntax
The SAP HANA Platform SPS 09 shipment offers new SQL syntax (functions and statements).
This includes: BITOR, BITXOR, BITNOT, BITCOUNT, REPLACE_REGEXPR, LOCATE_REGEXPR, SUBSTRING_REGEXPR, LIKE_REGEXPR, OCCURENCES_REGEXPR, and window functions.
The documentation for this new SQL syntax is attached to this note in the document SAP_HANA_Platform_SPS_09_Syntax.pdf.
Other new and changed SQL syntax for new SAP HANA platform features are included in guides on the following topics:
Hadoop SQL Syntax (included in the SAP HANA Administration Guide, Section Administration of SAP HANA Data Provisioning Technologies):
SAP HANA options offers new and changed SQL syntax in the various areas. For more information, see the specific option pages at http://help.sap.com/hana_options.
Caution
There are several types of licenses available for SAP HANA. Depending on the license type of your SAP HANA installation, some of the features and tools that are described in the SAP HANA platform documentation may only be available via the SAP HANA options, which may be released independently of an SAP HANA Platform Support Package Stack (SPS). Although various features included in SAP HANA options are cited in the SAP HANA platform documentation, customers who only purchased the license for the base edition of the SAP HANA platform do not have the right to use features included in SAP HANA options, because these features are not included in the license of the base edition of the SAP HANA platform. For customers to whom these license restrictions apply, the use of features included in SAP HANA options in a production system requires purchasing the corresponding software license(s) from SAP. The documentation for the SAP HANA optional components is available in SAP Help Portal at http://help.sap.com/hana_options. For more information, see also SAP Note 2091815 - SAP HANA Options. If you have additional questions about what your particular license provides, or wish to discuss licensing features available in SAP HANA options, please contact your SAP account team representative.
The SAP HANA Platform SPS 09 shipment offers new SQL syntax (functions and statements).
This includes: BITOR, BITXOR, BITNOT, BITCOUNT, REPLACE_REGEXPR, LOCATE_REGEXPR, SUBSTRING_REGEXPR, LIKE_REGEXPR, OCCURENCES_REGEXPR, and window functions.
The documentation for this new SQL syntax is attached to this note in the document SAP_HANA_Platform_SPS_09_Syntax.pdf.
Other new and changed SQL syntax for new SAP HANA platform features are included in guides on the following topics:
Hadoop SQL Syntax (included in the SAP HANA Administration Guide, Section Administration of SAP HANA Data Provisioning Technologies):
- CREATE VIRTUAL FUNCTION
- CREATE DATABASE
- DROP DATABASE
- ALTER DATABASE
- ALTER SYSTEM
- CREATE [RESTRICTED] USER
- ALTER [RESTRICTED] USER
- CORR
- CORR_SPEARMAN
- CREATE TABLE
- LINEAR_APPROX
- MEDIAN
- SERIES_DISAGGREGATE
- SERIES_GENERATE
- SERIES_ELEMENT_TO_PERIOD
- SERIES_PERIOD_TO_ELEMENT
- SERIES_ROUND
- BACKUP DATA
- BACKUP CATALOG DELETE
- BACKUP CHECK
- BACKUP CANCEL
- BACKUP CHECK ACCESS
- BACKUP LIST DATA
- RECOVER DATA
- RECOVER DATABASE
SAP HANA options offers new and changed SQL syntax in the various areas. For more information, see the specific option pages at http://help.sap.com/hana_options.
Caution
There are several types of licenses available for SAP HANA. Depending on the license type of your SAP HANA installation, some of the features and tools that are described in the SAP HANA platform documentation may only be available via the SAP HANA options, which may be released independently of an SAP HANA Platform Support Package Stack (SPS). Although various features included in SAP HANA options are cited in the SAP HANA platform documentation, customers who only purchased the license for the base edition of the SAP HANA platform do not have the right to use features included in SAP HANA options, because these features are not included in the license of the base edition of the SAP HANA platform. For customers to whom these license restrictions apply, the use of features included in SAP HANA options in a production system requires purchasing the corresponding software license(s) from SAP. The documentation for the SAP HANA optional components is available in SAP Help Portal at http://help.sap.com/hana_options. For more information, see also SAP Note 2091815 - SAP HANA Options. If you have additional questions about what your particular license provides, or wish to discuss licensing features available in SAP HANA options, please contact your SAP account team representative.
Solution
You will find the new SQL functions for SAP HANA Platform SPS 09 in the attached document SAP_HANA_Platform_SPS_09_Syntax.pdf.
Header Data
| Released On | 28.11.2014 11:59:12 |
| Release Status | Released for Customer |
| Component | HAN-AS-XS SAP HANA Extended Application Services |
| Priority | Correction with medium priority |
| Category | FAQ |
No comments:
Post a Comment