Skip to Content
-1

How to Export table data into Desktop with changing delimiter symbol through Stored Procedure.

Aug 08, 2017 at 11:58 AM

95

avatar image
Former Member

Hi All,

Need to export table data into one location(desktop etc...), along with Delimiter change in stored procedure.

Tried below logic. but getting SAP DBTech JDBC:[258]: insufficient privilege.

CREATE PROCEDURE PROCEDURE_NAME AS
BEGIN
DECLARE QUERY VARCHAR(100);
QUERY := 'EXPORT "schema_name"."table_name" AS CSV INTO ''\\path.csv''';
EXEC (:QUERY);
END;

Can any one help me in this.

Thanks

Rajeswari A.

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

1 Answer

Lars Breddemann
Aug 08, 2017 at 12:21 PM
0

No stored procedure will be able to produce an export to your local desktop. This is a feature of the client program you're using, e.g. HANA Studio.

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Could you pleas let us know in which path we can use for export .

Thanks

Rajeswari A.

0

The documentation covers that quite well. I trust you can read that yourself.

1