このプロシージャは、ファイルをSFTP サーバーにアップロードします。

CREATE VIRTUAL PROCEDURE upload_sftp(
IN sftp_user string OPTIONS (ANNOTATION 'username'),
IN sftp_password string OPTIONS (ANNOTATION 'password ( not needed if key based auth is used )'),
IN sftp_server string OPTIONS (ANNOTATION 'hostname or IP-address of the sftp server'),
IN sftp_port integer OPTIONS (ANNOTATION '[OPTIONAL] if NULL or omitted it defaults to 22'),
IN file_datasource string OPTIONS (ANNOTATION 'the datasource name which holds the files to upload'),
IN file_source_name string OPTIONS (ANNOTATION 'filename of the file to upload'),
IN file_dest_directory string OPTIONS (ANNOTATION 'destination folder, where the files should be uploaded to'),
IN file_dest_filename string OPTIONS (ANNOTATION '[Optional] destination filename ( if NULL, or omitted the source filename is used)'),
IN sftp_private_key string OPTIONS (ANNOTATION 'private key ( not needed password auth is used )')
)
RETURNS ( "status" string OPTIONS (ANNOTATION 'upload status') )