Skip to Content
avatar image
-1
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 08, 2017 at 12:21 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded