1

Is it possible to invoke an SQL file from another file in SAP HANA?

edit

• hana
• sap
• sql

asked 2023-07-19 23:51:27 +0000

pufferfish
41 ●3 ●2

edit retag flag offensive close merge delete

add a comment

0

answered 2023-07-20 00:14:01 +0000

nofretete
31 ●3 ●5

Yes, it is possible to invoke an SQL file from another file in SAP HANA using the statement:

DO 'path/to/sql/file.sql';

Where path/to/sql/file.sql is the path to the SQL file that you want to execute. You can include this statement in a SQL file or in a stored procedure to execute the SQL statements in the target file.

edit flag offensive delete link more

add a comment

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss