on 08-09-2017 3:09 PM
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
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.