Skip to Content
0

SAP DBTech JDBC: [12]: cannot open file:

Aug 09, 2017 at 02:09 PM

157

avatar image
Former Member

I have created a procedure to export a hana studio table data into a CSV file .

CREATE PROCEDURE EXPORTTABLE

AS

BEGIN

DECLARE QUERY NVARCHAR(500);

QUERY = 'EXPORT "MYschema"."TEST_IMPORT" as CSV INTO ''C:\Windows\Temp'' WITH REPLACE';

EXEC (:QUERY);

END;

Call EXPORTTABLE;

But on calling this procedure I am getting the below error:

Could not execute 'CALL EXPORTTABLE' in 39 ms 465 µs . SAP DBTech JDBC: [12]: cannot open file: "MYschema"."EXPORTTABLE": line 5 col 2 (at pos 174): [12] (range 3): cannot open file: Cannot open the path C:\Windows\Temp

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers