Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the provider beyond simple SELECT/INSERT/UPDATE/DELETE operations with SFTP.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from SFTP, along with an indication of whether the procedure succeeded or failed.
CData ADO.NET Provider for SFTP Stored Procedures
| Name | Description |
| DeleteFile | Deletes a specified file from the remote SFTP server. This is useful for removing outdated or unneeded files from a given directory. |
| Download | Transfers files from a remote SFTP server to the local system, allowing both individual file retrieval and larger workflows for synchronizing remote data locally. |
| MoveFile | Moves a file from one directory to another on the remote SFTP server, preserving the file but changing its location. |
| RenameFile | Renames a file on the remote SFTP server without altering its contents or location. |
| Upload | Transfers a file from the local system to the remote SFTP server, making it available for downstream processes or users. |