I made a stored procedure like this: CREATE PROCEDURE SP_EXEC_CREATE_SCRIPTLANGUAGE SQLSCRIPTASBEGINdeclare statement clob;SELECT STRING_AGG(TO_NVARCHAR(DEFINITION), '') FROM SYS.PROCEDURES WHERE SCHEMA_NAME='TEST_SCHEMA' AND PROCEDURE_NAME LIKE 'S...

I am having some difficulty trying to add multiple strings into a parameter field seperated by a line feed. So far I have come up with the following: SELECT STRING_AGG ('some varchar field', BINTOSTR( HEXTOBIN('0D0A') )) FROM table1 but that genera...

Hello, I want to have a report available in multiple company DB's containing data from all those company DB's. In the past (version 9.3) this was possible because in the end always the same database user would be used to connect to the database. ...

Hello, I have a question about the new feature for registering an external identity provider. When adding a new IDP service to the authentication service one can define a redirect url which is displayed as an internal redirect url in the configur...

Hello, When importing a schema I get the following error message in HANA studio: import failed: [30110] Unknown exception in import;exception 1000087: basic_ios::clear I did set the correct security on the directory where the data is imported f...