Tips

Tips

Physical connections to iSeries

• "Time" saving programming tips for iSeries

  Do you want to know how to synchronize your iSeries' clock to NIST standards and have distributed PCs synch up to your iSeries? This tutorial on iSeries clock managment shows you how.  Continue Reading

• Take control of your iSeries network security -- Part 2

  In his previous tip, Rich Loeber told you how to use the Job Action network attribute to help control network security. This week he shows you how Client Request Access and DDM Request Access control PC access and remote access to your iSeries.  Continue Reading

• Microsoft computing: Integrating the iSeries and Microsoft Office

  Traditionally, IBM and Microsoft have not been the best of friends, but ironically their respective business platforms make pretty good partners. Chris Peters, co-author of the i5/OS and Microsoft Office Integration Handbook, reviews the benefits of...  Continue Reading

• i5/OS and Microsoft Office Integration Handbook, Third Edition -- Chapter 3

  Search400.com members are entitled to a complimentary copy of Chapter 3 of i5/OS and Microsoft Office Integration Handbook, Third Edition written by Chris Peters and Brian Singleton and published by MC Press. This chapter, "Retrieving iSeries Data ...  Continue Reading

• Download your entire source to your PC

  Here is a quick way to download the entire source from a file in a given library. Just call the bat file GETALLSRC with the parms. You will need a user profile that has FTP access to the system you want to download from.  Continue Reading

• How to diagnose iSeries Access connection problems -- Part 2

  When last we heard from Andrew Borts he was trying to figure out why his iSeries Access connection kept dropping. After many checks, tests and updates, he was still stumped and ended up turning to his network administrators for help. Find out what ...  Continue Reading

• How to use Java to integrate Excel worksheets

  If you want to integrate Excel with relational data on any platform, Java Database Connectivity support allows you to use simple, dynamic SQL to do this easily.  Continue Reading

• How to diagnose iSeries Access connection problems -- Part I

  What do you do when your laptop won't keep its connection to your iSeries? Andrew Borts walks you through some steps you can take to figure out what the problem is.  Continue Reading

• Encrypt communication between iSeries and desktops

  What do you do when you need to encrypt information flowing between iSeries servers and desktops? Here are a couple ideas.  Continue Reading

• Set your iSeries to synchronize time with the U.S Naval Observatory

  Set your iSeries to synchronize time with the U.S Naval Observatory by using the iSeries command CHGNTPA.  Continue Reading

• Save time and aggravation -- automate FTP data transfers

  Automate the transfer of libraries from one iSeries to another using batch files and your PC as an immediate host.  Continue Reading

• PC FTP scripting

  Here's a trick to try if you use a PC and FTP to exchange files between a PC and any other system.  Continue Reading

• Character conversion with FTP

  When transferring textual data to a PC with FTP you can control CCSID conversion with command QUOTE TYPE C .  Continue Reading