Skip to Content

Export Path issue

Hi there,

i want to export a table from SAP Hana Studio into a folder for example my program files. Therfore i use the simple expression:

EXPORT AL_ST_ODV_PARAMETERS AS csv INTO 'C:\Program Files (x86)' ;

however this doesnt work and causes the error:

Could not execute 'EXPORT AL_ST_ODV_PARAMETERS AS csv INTO 'C:\Program Files (x86)''

SAP DBTech JDBC: [12]: cannot open file: Cannot open the path C:\Program Files (x86) and also its parent directory C:

so there is something wrong with the path ! I tried several different paths none except this did work:

EXPORT AL_ST_ODV_PARAMETERS AS csv INTO '/tmp' ;

I want to address a specific Folder Location and not use a temporary file to store my Information, so my question is what did I do wrong with the path description and how can I solve that issue ?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Nov 07, 2019 at 03:38 AM

    This question has been asked many times over on this platform.

    The main point here is: EXPORT in SAP HANA Is a server-side command.

    It does not store data on your client machine (which is why your local path string leads to an error) but instead can only write into specific folders that are accessible to the HANA indexserver process (hdbindexserver).

    The documentation has the details on what folders are accessible and how to set up other folders, but the bottom line for your question is: EXPORT does not save any data on your local client computer.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.