Mobile Log In
       Building and Delivering
Quality Software Results


Automating Delivery of Stream File Extracts with sftp over SSH (2013)

Soft-Coding Stream File Extracts and sftp Transmits

Table of Contents
sftp over SSH Client - Setup and Running it - the Essence
Soft-coding IFS Objects and CLP
DB2 Application and Extract File Formats, Defining and Populating
Using Exception Join for Net-Change Extracts

Bonus Sections
Positive Pay
IFS Security
Program Flow Appendix



Automating Delivery of Stream File Extracts with sftp over SSH  (73 slides)

Automating Delivery of Stream File Extracts
with sftp over SSH
sftp over SSH
Client

Soft-coding IFS Objects and CLP

DB2 Application
Files, Defining
and Populating

Using Exception
Join to Detect
New Trx(s)

Bonus Sections
Positive Pay
IFS Security
Program Flow Appendix


Copyright 2010-2014 by
Presentation Sponsor:
Tegratecs Development Corp.
1320 Tower Road
Schaumburg, IL 60173
800-739-3777

Presentation Author:
Rex Smith

The OMNI User Day of Education
September 17th, 2013, IBM Schaumburg, IL

COMMON Annual Conference & Exposition
April 10th, 2013, Austin Convention Center, Austin, TX

Please do not distribute a digital copy of this presentation.  We encourage you to register at www.tegratecs.com so that we can easily provide notice of updates.

Automating Delivery of Stream File Extracts with sftp over SSH
Learning Objectives
sftp over SSH
Client

Soft-coding IFS Objects and CLP

DB2 Application
Files, Defining
and Populating

Using Exception
Join to Detect
New Trx(s)

Bonus Sections
Positive Pay
IFS Security
Program Flow Appendix


Copyright 2010-2014 by
  • Understand how to automate secure and deterministic data transmission to any local TCP/IP or internet domain address using the sftp over OpenSSH client on IBM i

  • How to formulate re-usable components that create and manipulate stream files on the IFS using soft-coding techniques and external data structures

  • Envision development methods and techniques involving interaction between DB2 on i, CLP, high level language and the IFS
  • for cross-platform extracts in general
  • for potential productivity gains & support efficiencies







Presentation Author
Rex Smith
Sr. Developer
Tegratecs Development Corp.


     


Achieve automated, secure and deterministic transmission of IFS stream files and DB2 extracts
using OpenSSH on the IBM i platform

sftp over SSH client functions are now shipping standard with any IBM i OS, as a part of the OpenSSH implementation that started with i5/OS V5R4.  There are several excellent reasons for using this new client instead of FTP or FTPS, among them encrypted password transmission, transparent key pair exchange and feedback of error diagnostics right out of the box.
This presentation will touch upon aspects of a package-quality Positive Pay solution that creates and archives files on the IFS (Integrated File System), and includes an automated and secure internet transmission method using the sftp over SSH client.  Register with this website to see the whole presentation and find out about interesting technical tips and see soft-coded examples for interaction between DB2, CL programming and IFS files and directories.




        go to the home page Top of Presentations     go to next series page     Site Map     Mobile View
You are at the web site of Tegratecs Development Corp.  Click here to go to the home page of this site...
Integrity, Integration and ROI from Your Software
Our contact information:
Tegratecs Development Corp.
1320 Tower Road
Schaumburg, IL 60173
847-397-0088
( please register or sign-in )
© 2017 Tegratecs Development Corp.