Question Re: hdbsql - inline command to import database in Technology Q&A

hdbsql - inline command to import database

chladek — Mon, 20 May 2024 10:24:30 GMT

Hello,
I would like to use bash script where beside other commands I have:

inline command:
./hdbsql -n localhost -u MYUSER -p <mypass> "IMPORT "SBODEMOCZ"."*" AS BINARY FROM '/mypath/SBODEMOCZ' WITH IGNORE EXISTING;"

but it returns:
* 257: sql syntax error: incorrect syntax near "*": line 1 col 18 (at pos 18) SQLSTATE: HY000

When I firstly login into hdbsql console:
./hdbsql -n localhost -u MYUSER -p <mypass>

then pass the command:
hdbsql NDB=>IMPORT "SBODEMOCZ"."*" AS BINARY FROM '/mypath/SBODEMOCZ' WITH IGNORE EXISTING;

it works properly.
Please how can I do it as inline command?

Thank You
Regards
Zdenek

Re: hdbsql - inline command to import database

mamartins — Mon, 20 May 2024 10:45:09 GMT

You need to escape the " from the IMPORT command, otherwise the HDBSQL will interpret the second " as the end of the command.

Also, you could store the commands in a file and call the HDBSQL (option -I <file>) to execute them. Official documentation here.

Re: hdbsql - inline command to import database

Vitaliy-R — Mon, 20 May 2024 16:07:48 GMT

I do not think escape matters (but maybe for the versions of hdbsql?) as I can execute on Mac's terminal following without the issues:

hdbsql -U TECHED_DEMO_VECTOR -j "SELECT "Current_User" FROM \"DUMMY\""

Re: hdbsql - inline command to import database

jyotsana_gupta — Wed, 22 May 2024 15:04:42 GMT

Hello Zdenek,

I tried your inline command on Windows and Linux and got the same syntax error, but, if I escape the quotes around *, the syntax error goes away on both platforms. Could you please try that and see if it works for you as well?
./hdbsql -n localhost -u MYUSER -p <mypass> "IMPORT "SBODEMOCZ".\"*\" AS BINARY FROM '/mypath/SBODEMOCZ' WITH IGNORE EXISTING;"

Best regards,
Jyotsana

Re: hdbsql - inline command to import database

chladek — Thu, 01 Aug 2024 15:04:19 GMT

Thank You with the escaping arround * it work.