Some tips for the Enterprise HANA 2.0 Developer.

Scenario 1:  Always prefer HCP Cloud Foundry platform to Neo Platform. There are some drawback to using Neo Platform for your HANA application which is given below –

• Node.JS runtime will not be available by default.
• We are also not able to install Node.JS runtime using CLI interface.
• Some Important functionalities like http,net( email facility) will not work functionally. As a result,  FTP and other java script functionality will not work. These are given below –

1. $.net.http.writeFile().
2. ssh2-sftp-client
3. require() functions
4. fs.writeFileSync()
5. sftp.put()
6. fs.writeFileSync()
7. $.net.File()

• Using Java program you can also do FTP but can not schedule it on the HCP NEO platform.
• Scheduler is not available by default in HANA HCP neo-Platform and you can not install it.

Scenario 2:  Transpose and concept row values for a column and put it into a single line – Using the STRING_AGG() function we can achieve it.

SELECT "EMPID",STRING_AGG("REPORT_EMPLOYEE", ';') as "UNDER_EMPLOYEE" FROM EMPLOYEE;