Events Calendar Print Email help
Previous month Previous day Next day Next month
See by year See by month See by week See Today Search Jump to month
IBM i Data Transfers - New Feature
Tuesday, November 13 2012, 07:30 - 09:30
Central Timeby  This e-mail address is being protected from spambots. You need JavaScript enabled to view it Hits : 324

OCEAN User Group Meeting


Craig Pelkie will be explaining the latest technique for IBM i Data Transfers, the annual OCEAN board elections will be taking place, plus we'll have lots of fun and Thanksgiving- themed door prizes!


Tuesday, November 13

5:30 PM - Dinner & Networking with Your Peers

6:30 PM - IBM i Data Transfers - New Feature - Important information for IBM i Users! 


Please click here to make a reservation so we can plan seating and dinner: 2012 November Meeting


Please note the early start time (5:30 PM) plus the location is National University in Costa Mesa.


Meeting Location:

National University - 3390 Harbor Blvd.

Second Floor - Room 201

Costa Mesa, CA  92626  - Plenty of free parking.




IBM i Data Transfers - Craig Pelkie

In June, 2012, IBM introduced the IBM i   Access Client Solutions product (beta edition) as a no-charge download on the   IBM web site. IBM i Access Client Solutions (IACS) provides a Java-based 5250   emulation program, data transfer, and other features. Because IACS is   Java-based, it can be installed on a PC running Windows, Linux, or on a Mac   running iOS.

  Although IACS is intended to be used on client operating systems, it is   possible to run the Data Transfer (download and upload) programs on your IBM   i. IBM does not mention this capability in their documentation for IACS, but   by making use of Java and other IBM provided software, you can install and   run the Data Transfer programs on your IBM i. You don't need to write any   Java programs yourself to use this technique, you'll be using Java programs   that IBM provides.
  This means that the same features that you use with the desktop Data Transfer   are now available directly on your IBM i. You can download from IBM i   database files to Excel, CSV, and OpenDocument files. You can upload from   Excel, CSV, and OpenDocument files to IBM i database files.
  You don't need to use complicated RPG and Java techniques to create Excel   files, you don't need to use the cumbersome IBM CPYTOIMPF command, and you   don't need to create rickety RUNRMTCMD configurations to kick off data   transfers on a PC. You can run all of the Data Transfer downloads and uploads   directly from your IBM i, using simple CL commands. You can easily create   batch applications to perform data transfer operations.
  In this session, Craig Pelkie provides an overview of how you can configure   the IBM i Access Client Solutions code on your IBM i. Craig describes the   additional IBM i software that you'll need (available at no-charge from IBM),   and shows how you can use CL commands to run the data transfers. In addition   to the handout that you'll be provided with at the meeting, you'll get a link   to a step-by-step document that shows you exactly how to configure and work   with the IACS Data Transfer programs on your IBM i.
  This technique is available for IBM i servers that are using V5R4 or above,   and that have a license to the IBM System i Access Licensed Program Product.



Craig Pelkie has worked as a   developer/analyst with IBM midrange computers for many years. He has also   written and lectured extensively on IBM AS/400 and iSeries technologies,   including client/server programming, Client Access, Java, WebSphere,   MS.Net applications for the iSeries, and Web development. Craig has extended   his RPG skills by being an early adopter of Java, WebSphere, VB.Net and   MS-Sequel Server, mastering firewall issues, Web Services, exchanging data   from RPG to Sequel Server and from Sequel Server to update RPG and System i   files.

You can contact Craig Pelkie at