Skip to Content
avatar image
Former Member

Starting scrpts in HANA studio or hdbsql

Hi all,

I'm looking for a solution or an idea how to run scripts. My idea is to compile different stored procedures or functions by script from file system.

So I logged on to HANA studio or hdbsql and want to execute many files.

i.e.

HDBSQL>run myfile1.sql

myfile1 successfully compiled.

HDBSQL>run myfile2.sql

myfile2 successfully compiled.

HDBSQL>run myfile3.sql

myfile3 successfully compiled.

Currently I found only the way to start the HDBClient with a parameter to execute a file, but I can't run a script after loggin in.

Any ideas?

Thanks a lot

Carsten

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 02, 2017 at 02:14 PM

    Hi, I found this question, which is a bit similar to yours:

    https://archive.sap.com/discussions/thread/3657055

    Please check it out and see if it is helpful what other Community members had provided.

    Regards, Mynyna

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 06, 2017 at 08:01 AM

    By using \h in hdbsql you can display the available commands.

    Once of them is

    \i[nput]       <filename> read input from file, double quotes around filename are allowed

    should do the trick.

    Add comment
    10|10000 characters needed characters exceeded