Email Alerts
-
The iSeries and MS Office make good partners
Microsoft may be IBM's arch nemesis, but in most cases iSeries users still need to use PCs and Microsoft software. Fortunately, the i5/OS and Microsoft Office work well together. Interaction between two computers -- like an iSeries system and a PC --... Learning Center
-
How to: Transfer unlimited data to Excel from AS/400
Using the data transfer from iSeries utility in Client Access allows you to transfer data from the AS/400 to Excel. By setting up the worksheet type and optional setting for Excel to start a new worksheet you can avoid running out of room on a single... News | 11 Sep 2008
-
Modern System i reports using Client Access
Creating reports on the IBM System i no longer has to be a headache. You can use the CPYTOIMPF command and then open the file into a spreadsheet or use Client Access. Computer-savvy users can then manipulate the reports to their liking, taking the fo... Tip
-
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 ... Tip
-
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 wi... Tip
-
Transfer iSeries files into Excel using Client Access
Learn how to transfer iSeries files to Excel using Client Access with this Search400.com member submitted tip. Tip
-
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 th... Tip
-
Proper IFS security setting
How do you set the IFS security so a manager can access the IFS files from her PC applications but none of the clerks can? Security expert Carol Woodbury has a suggestion. Tip
-
iSeries Access Family -- A good product you may not need
The Value Manager looks at the choices for accessing iSeries apps and data from Windows clients and the Web. As you might suspect, iSeries Access isn't always the best option. Tip
-
Understanding and taking advantage of the IFS
You need a comprehensive understanding of the IFS to perform routines saves and restores. Tip
-
Ten things to remember when using the IFS
Using the IFS can be a little tricky. Ron Turull gives you 10 things to keep in mind. Tip
-
How to print RPG output using iSeries Access
Use work station customize object or printer type in iSeries Access to print the output of an RPG file from the AS/400 to an HP printer. Ask the Expert
-
Saving multiple sessions on IBM iSeries Client Access when using Vista
When working with Vista on a PC, install service pack si27741 to solve emulation issues. Ask the Expert
-
Automate Client Access to find files on Windows scheduler
Use the RTOPCB command to transfer files from the AS/400 to the PC when automating file transfers. Ask the Expert
-
Running a job on the iSeries after it has been transferred to a PC
The REXEC command on a PC or the RMTCMD within iSeries Access allows you to call a program on the iSeries from a Windows PC. Ask the Expert
-
SQL7008 error in iSeries Access and journals
SQL7008 error in iSeries Access is most frequently caused by trying to update a file that is not journaled or when a user lacks authority to the journal. Ask the Expert
-
Converting and transferring AS/400 packed decimal fields to ASCII systems
You can send a physical file with packed decimal fields to an ASCII system via iSeries Access or via the CPYTOIMPF command and then send the file with FTP. Ask the Expert
-
Copying the spool file stream to IFS
Instead of printing the spool file to a PC, an easier approach is to copy a spool file to IFS, which makes it available on the PC. Ask the Expert
-
Automating data transfer to iSeries using Client Access
To automate data transfer through a command instead of GUI, run the RFROMPCB.EXE from an AS400 command line. Ask the Expert
-
IBM AS/400 client access and Windows Vista
ISeries PC/Windows connectivity expert Shahar Mor discusses client access support for Windows Vista. Ask the Expert
-
Error while connecting Client Access v4r5 to to an AS/400 on v4r5
Expert Shahar Mor explains why a user receives an error message while trying to connect Client Access v4r5 to to an AS/400 on v4r5. Ask the Expert
- See More: Expert Advice on iSeries Access (Client Access)
-
How to print RPG output using iSeries Access
Use work station customize object or printer type in iSeries Access to print the output of an RPG file from the AS/400 to an HP printer. Ask the Expert
-
Modern System i reports using Client Access
Creating reports on the IBM System i no longer has to be a headache. You can use the CPYTOIMPF command and then open the file into a spreadsheet or use Client Access. Computer-savvy users can then manipulate the reports to their liking, taking the fo... Tip
-
Saving multiple sessions on IBM iSeries Client Access when using Vista
When working with Vista on a PC, install service pack si27741 to solve emulation issues. Ask the Expert
-
Automate Client Access to find files on Windows scheduler
Use the RTOPCB command to transfer files from the AS/400 to the PC when automating file transfers. Ask the Expert
-
Running a job on the iSeries after it has been transferred to a PC
The REXEC command on a PC or the RMTCMD within iSeries Access allows you to call a program on the iSeries from a Windows PC. Ask the Expert
-
SQL7008 error in iSeries Access and journals
SQL7008 error in iSeries Access is most frequently caused by trying to update a file that is not journaled or when a user lacks authority to the journal. Ask the Expert
-
Converting and transferring AS/400 packed decimal fields to ASCII systems
You can send a physical file with packed decimal fields to an ASCII system via iSeries Access or via the CPYTOIMPF command and then send the file with FTP. Ask the Expert
-
Copying the spool file stream to IFS
Instead of printing the spool file to a PC, an easier approach is to copy a spool file to IFS, which makes it available on the PC. Ask the Expert
-
How to: Transfer unlimited data to Excel from AS/400
Using the data transfer from iSeries utility in Client Access allows you to transfer data from the AS/400 to Excel. By setting up the worksheet type and optional setting for Excel to start a new worksheet you can avoid running out of room on a single... News
-
Automating data transfer to iSeries using Client Access
To automate data transfer through a command instead of GUI, run the RFROMPCB.EXE from an AS400 command line. Ask the Expert
- See More: All on iSeries Access (Client Access)
About iSeries Access (Client Access)
null