Sitting at the airport again. Wondering more about the latest SQLScript problem than one of my troublesome projects. Now that the solution is there for the complex inner join query, it won’t work too well with HANA’s column store; there are plenty of dos and donts for this. So the research is going on into making some stored procedures. Haven’t done these procedures in ages, so struggling to find some clues. BO is not connecting properly to HANA. Best part is that the error its not reproducing for the Basis team. Read plenty of pdfs on SQLScript. After reading the SQLScript developers guide on service.sap.com/hana, the three different HANA views make sense. To bring the business logic closer to the database engine, SAP is rolling out SQLScript big time. Most of my ABAP team members are shocked they have to jump so much into another version of SQL. That bring said, I like all the flexibilities provided by SQLScript over regular SQL.
Till next time!