Multiple commands in HDBSQL

[former_member212706]

Dear Experts,

     Does HDBSQL support multiple commands to be executed sequentially, as in CMD where we would go for multiple commands seperated by '&' so that all commands are executed sequentially without the need of executing the statements individually by the user himself

Thanks in advance!!!

Happy new year and have a great day !!!!

Regards,

Rajesh.

[lbreddemann]

Rajesh,

you can just put the commands into a file, one after the other, delimited by semicolon ; as the default command separator.

Once you have this file, you can simply call it with

hdbsql -I <filename>

All hdbsql features are documented in the command line help:

hdbsql --h

cheers,

Lars

[subith_balakrishnan2]

The hbdql -I file is working great. But in that file if don't want to execute certain statements for now, is there a way to comment out that line. I tried the "- -" and it gives me the error * 257: sql syntax error: invalid SQL type SQLSTATE: HY000.

thanks in advance !