PowerBuilder

Download from an SFTP Server Using an Open Handle

Demonstrates the Chilkat SFtp.DownloadFile method, which streams a remote file identified by an open handle to a local path. The first argument is the handle (from OpenFile) and the second is the local file path. Close the handle with CloseHandle when done.

Note: This example uses relative local paths, which are resolved against the application's current working directory. Absolute local paths may also be used. Supply the paths appropriate to your own environment.

Background: The handle-based counterpart to DownloadFileByName. Opening the file yourself lets you set read options — such as requesting exclusive read access — that the convenience method does not expose, and it separates the open step from the transfer so the handle can be used for more than one operation. As with any handle, close it when finished to release the server-side resource.

Chilkat PowerBuilder Downloads

Download Chilkat for PowerBuilder

PowerBuilder

integer li_rc
integer li_Success
oleobject loo_Sftp
integer li_Port
string ls_Password
string ls_Handle

li_Success = 0

//  Demonstrates the SFtp.DownloadFile method, which streams a remote file identified by an open
//  handle to a local path.  The 1st argument is the handle and the 2nd is the local file path.

loo_Sftp = create oleobject
li_rc = loo_Sftp.ConnectToNewObject("Chilkat.SFtp")
if li_rc < 0 then
    destroy loo_Sftp
    MessageBox("Error","Connecting to COM object failed")
    return
end if

//  Connect, authenticate, and initialize the SFTP subsystem.
li_Port = 22
li_Success = loo_Sftp.Connect("sftp.example.com",li_Port)
if li_Success = 0 then
    Write-Debug loo_Sftp.LastErrorText
    destroy loo_Sftp
    return
end if

//  Normally you would not hard-code the password in source.  You should instead obtain it
//  from an interactive prompt, environment variable, or a secrets vault.
ls_Password = "mySshPassword"

li_Success = loo_Sftp.AuthenticatePw("mySshLogin",ls_Password)
if li_Success = 0 then
    Write-Debug loo_Sftp.LastErrorText
    destroy loo_Sftp
    return
end if

li_Success = loo_Sftp.InitializeSftp()
if li_Success = 0 then
    Write-Debug loo_Sftp.LastErrorText
    destroy loo_Sftp
    return
end if

//  Open the remote file for reading.  OpenFile returns a handle string.
ls_Handle = loo_Sftp.OpenFile("subdir/report.pdf","readOnly","openExisting")
if loo_Sftp.LastMethodSuccess = 0 then
    Write-Debug loo_Sftp.LastErrorText
    destroy loo_Sftp
    return
end if

//  Stream the remote file to the local filesystem.  The transfer is not limited by memory.
li_Success = loo_Sftp.DownloadFile(ls_Handle,"qa_output/report.pdf")
if li_Success = 0 then
    Write-Debug loo_Sftp.LastErrorText
    destroy loo_Sftp
    return
end if

//  Close the remote handle when the download is complete.
li_Success = loo_Sftp.CloseHandle(ls_Handle)
if li_Success = 0 then
    Write-Debug loo_Sftp.LastErrorText
    destroy loo_Sftp
    return
end if

Write-Debug "Downloaded."

loo_Sftp.Disconnect()


destroy loo_Sftp