avoid hdbsql prompt when running command line with userstore key

[Patrice1]

Hello Experts

i have define a userstore CLONE key like this :

hdbuserstore set CLONE host:30015 SAPSID password

below is the hdbuserstore LIST command output:

DATA FILE       : /usr/sap/TB1/home/.hdb/host/SSFS_HDB.DAT

KEY CLONE

  ENV : host:30015

  USER: sapschema

when i execute the hdbsql -U CLONE command to connect to sql i get :

Welcome to the SAP HANA Database interactive terminal.

Type:  \h for help with commands

       \q to quit

hdbsql=>

hdbsql TB1=>

i have to press enter key to get the hdbsql TB1 prompt???

my goal is to execute the command line below :

hdbsql -U CLONE -l exp.sql but it stop to the first prompt :"hdbsql=> "

can you tell me how to avoid it?

thank you for your help

regards

Patrice

[Former Member]

Sorry for the previous reply.

I am not sure if the below is possible

hdbsql -U CLONE -l exp.sql but it stop to the first prompt :"hdbsql=> "

i think, first you should connect to sql and then you can import the table.

Regards,

Pavan Gunda

[Former Member]

Hi Lenior,

Yes, you need to press enter

You need to execute the hdbsql connect in the following way

sidadm>hdbsql

hdbsql=> \connect -n <server name>  -i <instance number>  -u <user>  -p <password>

and execute the commands that you wnat to execute

Regards,

Pavan Gunda