on 09-18-2023 12:54 PM
Hi,
I have one Windows server configured with SFTP.
I have already created a procedure to download files from this server to another using DPA (which was pretty straightforward with the help).
Now I need to delete some of the files from the server using the SFTP connection from the HANA cloud.
Any hints about a possible procedure to delete files from the SFTP server through a procedure or virtual procedure?
What I have already tried
-- delete_file_from_sftp.hdbprocedure
PROCEDURE "delete_file_from_sftp"()
LANGUAGE SQLSCRIPT
--DEFAULT SCHEMA "<MY_SCHEMA_NAME>" AS
BEGIN
EXEC 'sftp -o StrictHostKeyChecking=no <my_user>@<my_sftp_host> -P <my_password> "rm <MY_FILE>"';
END
The procedure was deployed successfully, but when I tried to execute, it returned:
Could not execute 'CALL "<MY_SCHEMA_NAME>"."delete_file_from_sftp"()'
Error: (dberror) [257]: sql syntax error: "<MY_SCHEMA_NAME>"."delete_file_from_sftp": line 10 col 4 (at pos 227): incorrect syntax near "sftp": line 1 col 1 (at pos 1)
User | Count |
---|---|
81 | |
11 | |
10 | |
8 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.