How to chain HANA SQL input files in a HANA SQL Input file

[andreas_zigann]

Hello,

I would like to simplify my configuration. I have written several sql scripts to create users, roles, policies, set parameters etc. Now I would like to chain these scripts in an input file for hdbsql. 

The best way on my opinion:

loggin on with <sid>adm 

hdbsql -d SYSTEMDB -u SYSTEM

\i configure_hana.script

Content of configure_hana.script:

\i create_roles.sql;

\i create_users.sql;

\i set_parameters.sql;

hdbsql executes the first script, but stucks after this. There are ; at the end of each line in the sql script. 

I do not want to store a user with admin authorisation in hdbuserstore and I do not want to execute hdbsql with password in command line. Because of this, I would like to logon first and then call the input file. 

I can`t find a syntax to terminate the input file. 

Can you give me a hint to the solution.

Best Regards

Andreas

[Vitaliy-R]

Andreas, I was able to recreate the same situation, where HDBSQL switches to promptless command input after executing the first sql script from the list of scripts. You can even type `\q;` to get it exiting that "hanging" mode.

I am going to check that with the development team, but in the meantime would a shell script similar to this work for you?

#!/usr/bin/env bash
read -sp "Enter password: " pswd
echo
hdbsql -n b7c3ff95-9e0c-480d-9022-bfaa268f780.hna0.prod-us10.hanacloud.ondemand.com:443 -u DBADMIN -p ${pswd} -xaj -I step1.sql
hdbsql -n b7c3ff95-9e0c-480d-9022-bfaa268f780.hna0.prod-us10.hanacloud.ondemand.com:443 -u DBADMIN -p ${pswd} -xaj -I step2.sql
hdbsql -n b7c3ff95-9e0c-480d-9022-bfaa268f780.hna0.prod-us10.hanacloud.ondemand.com:443 -u DBADMIN -p ${pswd} -xaj -I step3.sql

Regards,
--Vitaliy

[Vitaliy-R]

I hope I have a solution for you @andreas_zigann , but I still would need to validate it with the engineering team. Please, try to change you `configure_hana.script` to:

\read create_roles.sql;
\read create_users.sql;
\read set_parameters.sql;

Regards,
--Vitaliy

[Vitaliy-R]

HDBCLI engineering team confirmed that READ should be used instead of the INPUT command.