PowerBuilder

Upload to an SFTP Server Using an Open Handle

Demonstrates the Chilkat SFtp.UploadFile method, which streams a local file to a remote file identified by an open handle. 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: This is the lower-level upload, useful when you need control that UploadFileByName does not offer — for example choosing the exact create disposition (create-new versus truncate versus append) via OpenFile, or reusing a handle across operations. The transfer itself is streamed and unbounded by memory. The trade-off is that you own the handle's lifetime and must close it explicitly.

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.UploadFile method, which streams a local file to a remote file that is
//  identified by an open handle.  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 (creating/truncating) the remote file for writing.  OpenFile returns a handle string.
ls_Handle = loo_Sftp.OpenFile("subdir/report.pdf","writeOnly","createTruncate")
if loo_Sftp.LastMethodSuccess = 0 then
    Write-Debug loo_Sftp.LastErrorText
    destroy loo_Sftp
    return
end if

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

//  Close the remote handle when the upload 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 "Uploaded."

loo_Sftp.Disconnect()


destroy loo_Sftp