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

[former_member374631]

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.

[lbreddemann]

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.

[former_member374631]

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

Thanks

Rajeswari A.

[lbreddemann]

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