Mobile Log In
       Building and Delivering
Quality Software Results


Soft-Coded Automation of Stream File Extracts with sftp over SSH (2014)

Soft-Coding sftp Transmits and Data Extracts to IFS on IBM i

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  (83 slides)

Soft-coded Automation 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

COMMON Annual Conference and Expo
Loews Royal Pacific Resort, Orlando, FL
Wednesday May 7th, 2014

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

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.

Soft-coded Automation 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 conditions at the end of any command of significance.

This presentation will touch upon aspects of a package-quality Positive Pay solution and a USPS transmit of customs data required for international mail.  Both create and archive files on the IFS (Integrated File System)

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 Tech Crystals     go to next series page Next in Presentations     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.