HANA: Split string?

HANA: Split string?

By : LovingBird Whisper
Date : November 21 2020, 07:31 AM
will be helpful for those in need Try this,
Refer Here
code :
  declare _items nvarchar(100) ARRAY;
  declare _text nvarchar(100);
  declare _index integer;
  _text := :TEXT;
  _index := 1;

  WHILE LOCATE(:_text,',') > 0 DO
  _items[:_index] := SUBSTR_BEFORE(:_text,',');
  _text := SUBSTR_AFTER(:_text,',');
  _index := :_index + 1;
  _items[:_index] := :_text;

  rst = UNNEST(:_items) AS ("items");
  SELECT * FROM :rst;


Share : facebook icon twitter icon
HANA Studio locks DB user when accessing HANA in the cloud via database tunnel

HANA Studio locks DB user when accessing HANA in the cloud via database tunnel

By : Ibrahim Salih
Date : March 29 2020, 07:55 AM
With these it helps if you use the new SDK from the SAP HANA Cloud Platform you no longer have a changing password. Once you open the tunnel you'll get an initial password for your HANA instance in the cloud. After changing it to your needs you can always use that database password to connect your HANA Studio to the HANA instance on your account.
But be aware that you have always 2 passwords. The one you use to create the tunnel and the other one that you use in your HANA Studio to connect to your HANA instance in the cloud.
How to deal with odata service created with 1000 rows of hana table in SAP hana XS app

How to deal with odata service created with 1000 rows of hana table in SAP hana XS app

By : Kobert ThyFirsteth
Date : March 29 2020, 07:55 AM
hop of those help? Good for you: Lazy loading is a built-in feature of SAPUI5 :)
Just add some extra properties to your list
code :
<List id="contractList"

    <StandardListItem title="{MyTitle}" description="{MyDescription}" press="onPress" />

HANA procedure for CONDENSE and SPLIT

HANA procedure for CONDENSE and SPLIT

By : Rahul Gondole
Date : March 29 2020, 07:55 AM
I wish this helpful for you To filter out a flexible number of whitespace characters, you can use REPLACE_REGEXPR:
code :
select 'A     B C' as orig,
        replace_regexpr ( '[[:space:]]+' 
                        IN  'A     B C'
                        WITH ' ') as repl
from dummy;

ORIG     |  REPL 
A     B C|  A B C
Split delimited string in SAP HANA

Split delimited string in SAP HANA

By : Sunny Gupta
Date : March 29 2020, 07:55 AM
this one helps. I am using HANA 1.0 SPS12. Is there a way to split delimited string in SAP HANA. , Yes, You can try the following SUBSTRING_REGEXPR()
code :
SELECT SUBSTRING_REGEXPR('[^|]+' IN '1111|2222|3333|44|555' FROM 1 OCCURRENCE 4) from dummy;

SELECT SUBSTRING_REGEXPR('[^|]+' IN '1111|2222|3333|44|555' FROM 1 OCCURRENCE 2) from dummy;
Boost Hana : Convert Hana Types to std::string's

Boost Hana : Convert Hana Types to std::string's

By : user995228
Date : March 29 2020, 07:55 AM
seems to work fine If you are using Clang, Hana has an experimental feature hana::experimental::type_name. This can be used to get the type-names of the members of the struct:
code :
#include <boost/hana.hpp>
#include <boost/hana/experimental/type_name.hpp>

namespace hana = boost::hana;

template <typename Struct>
auto member_type_names() {
    constexpr auto accessors = hana::accessors<Struct>();

    return hana::transform(
            [](auto get) {
                using member_type
                    = std::decay_t<decltype(get(std::declval<Struct>()))>;

                return hana::experimental::type_name<member_type>();
#include <iostream>
#include <string>

struct MyType {
    int a;
    std::string b;
    float c;


int main() {
    hana::for_each(member_type_names<MyType>(), [](auto name) {
        // Note that the type of `name` is a hana::string, not a std::string
        std::cout << name.c_str() << '\n';
Related Posts Related Posts :
  • Exception while returning an empty Associative array from PLSQL function
  • How to create a database snapshot in SQL Server 2008 R2
  • Query speed and expressions with constant value
  • How to do a complex calculation as this sample
  • Passing a ResultSet into a Postgresql Function
  • Netsuite custom formula field using a CASE statement with multiple WHEN conditions returning "invalid expression&qu
  • Execute query command (dynamic sql) runs faster than ordinary query
  • How to extract only numbered rows from a column
  • INSTEAD OF DELETE trigger (Postgresql)
  • Oracle Apex, when a report with sql is created, how do i get it return after entering in to a text box?
  • Select records based on two tables where one column in one table starts with the records from another tables column usin
  • How to write select using two ids combination in Oracle 11g
  • Frequently use of 'UPDATE STATISTICS WITH FULLSCAN' is normal?
  • need query for this simple pulling data sql server
  • Sql query by using decode to show grades of employee
  • Not a single function error in Oracle
  • Oracle SQL optimizer's behavior when dealing with ORs and row-independent predicates (such as functions returning same v
  • Combining output of two or more select statement
  • Must Declare Scalar Variable Exception
  • Postgres Calculate Difference Using Window Functions
  • SQL Server : unsure how to retrieve selected records
  • SQL unique field: concurrency bugs?
  • Query to get the next identity?
  • SQL Server Adding summing values based on the month
  • Join on month if available else join on latest month
  • How to solve error: ORA-01406 fetched column value was truncated?
  • Selecting Field Multiple Times using OR
  • Which SQL datatype can be used to store mobile numbers in numeric forms, without including characters like brackets and
  • Oracle SQL - "Not a group by expression" after adding CASE statements
  • Runnning total of unique string values in column over days
  • VB.Net to AccessDB by SQL - INSERT INTO with parameters error
  • SQL/Excel/VBA - UPDATE query: 'Syntax Error (missing operator) in query expression'
  • Code to combine two sql queries
  • Setting SQL Date field value based off Week Number and Day Number Field
  • SQL query to find matching records but with differences in case sensitivity?
  • How to sort record inside views in SQL Server 2008
  • How to link the output of teradata sql query to an excel sheet?
  • Matching sets in SQL when cross-referencing
  • error even after following Microsoft format in SQL
  • Increase price by percentage, results rounded
  • Can we Use "Case" in a ColdFusion Query-of-Query
  • displaying 'Active' for a row which has 'A' as value
  • Using pattern search in SQL Server Query
  • SQL - how to group transactions for a certain date pattern?
  • How to Index SQL with multiple AND conditions nested inside OR
  • SQL rank with priority
  • Does BigQuery support SubQueries?
  • Any ideas for persisting H2 Database In-Memory mode transaction?
  • How to improve SQL query performance (correlated subqueries)?
  • Filter repeated columns in Oracle
  • SQL Server join on whichever column has value populated
  • use sql stored procedure to insert data which is returned from a query stored in a table
  • Query not working1
  • SQL - using an alias in a where clause in a subquery
  • How to search for a whole word with special char using oracle contains?
  • Production Perfomance of using SELECT * statements?
  • String concatenation not working as expected in SELECT statement
  • How to detect which stored procedures UPDATE or INSERT into a certain TABLE?
  • Select statement inside CASE - SQL
  • .Net Float error 4 - float(4) = 4.44089209850063E-16
  • shadow
    Privacy Policy - Terms - Contact Us © ourworld-yourmove.org