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:
R. 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
R. 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.