Email Alerts
-
PC/Windows connectivity: Top 10 expert Q&As
Shahar Mor, iSeries/i5 PC/Windows connectivity expert, has been answering Search400.com's member questions for more than five years. Shahar has seen many of the same issues and concerns asked again and again. Therefore, we've compiled the top 10 ques... Learning Guide
-
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
-
Know-IT-All Chapter Quiz: i5/OS and Microsoft Office Integration Handbook, Third Edition
Think you know all there is about retrieving iSeries data with Microsoft Query? We challenge you to test your skills by taking our latest quiz. Share the results with us and get a chance to win a copy of i5/OS and Microsoft Office Integration Handboo... Quiz
-
Fast guide to PC/Windows connectivity resources
In an effort to save you time scouring the Web, we've pulled together a quick reference of PC/Windows connectivity resources to help make your iSeries connections run smoothly. Fast Lookup
-
"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. Tip
-
Invisible traffic that steals bandwidth
If you network is busy though you know it is empty you may be experiencing "phantom traffic." Here Loki Jorgeson takes the mystery out of of the sources of traffic-like behavior. Tip
-
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. 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
-
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. 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
-
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. Tip
-
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. Tip
-
Top five tips for improving network performance
Here are five things you can try to improve network performance without buying new hardware. Tip
- See more Tips on Physical connections to iSeries
-
Configure the iSeries v5r4 to open the HTTPS port for incoming connections
When the HTTPS 443 port is not accessible from interned but is open within the local network, open the port for incoming connections by recognizing the problem as a network firewall issue rather than an iSeries issue. Ask the Expert
-
Working with ODBC and dates
One Search400.com member writes, "I use Business Objects and Viewpoint to access DB2/400 via ODBC. Since the new year some PTF's were applied (I don't know which ones) and now any SQL that converts strings to dates fails. The iSeries is managed elsew... Ask the Expert
-
Run command on a PC
One Search400.com member writes, "I want to start a .Wav file from my iSeries. It works with the STRPCCMD but the length of the parameter is limited to 123, which is too small. Are there any alternatives?" PC/Windows connectivity expert Shahar Mor re... Ask the Expert
-
Why is my job taking twice as long?
We are running a series of overnight downloads from the iSeries using SQL server with ODBC connections. The job runs in subsystem QUSRWRK. The job, which once took two hours, leapt to a current five hours with no apparent changes to jobs, configurati... Ask the Expert
-
Problems with new server and PC
One user writes, "We have made some changes in our network. We added a new server, and a new PC was installed in the old V3R2 Client Access. We are still running OS/400 V3R7 on the iSeries. In the old network, which is still available, I can see in ... Ask the Expert
-
iSeries communication conflict
One Search400.com member writes, "We are running V5R2 and have a PC running Microsoft DOS that controls equipment through a C program and produces an export file that we need to access. Moving to Windows is problematic. " Thankfully, iSeries connecti... Ask the Expert
-
FTP to non QGPL
One user writes, "How can I send files from a PC running a VB program straight to a designated library within iSeries without going to QGPL? We have sales representatives that run Visual Basic (VB) programs to create orders from their laptops. Once t... Ask the Expert
-
Controlling time out for a socket connection
Ask the Expert
-
Sending files from the iSeries to Windows
Ask the Expert
-
Upload an ASCII file from a PC server to an iSeries
Ask the Expert
- See more Expert Advice on Physical connections to iSeries
-
Configure the iSeries v5r4 to open the HTTPS port for incoming connections
When the HTTPS 443 port is not accessible from interned but is open within the local network, open the port for incoming connections by recognizing the problem as a network firewall issue rather than an iSeries issue. Ask the Expert
-
"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. Tip
-
PC/Windows connectivity: Top 10 expert Q&As
Shahar Mor, iSeries/i5 PC/Windows connectivity expert, has been answering Search400.com's member questions for more than five years. Shahar has seen many of the same issues and concerns asked again and again. Therefore, we've compiled the top 10 ques... Learning Guide
-
Invisible traffic that steals bandwidth
If you network is busy though you know it is empty you may be experiencing "phantom traffic." Here Loki Jorgeson takes the mystery out of of the sources of traffic-like behavior. Tip
-
Working with ODBC and dates
One Search400.com member writes, "I use Business Objects and Viewpoint to access DB2/400 via ODBC. Since the new year some PTF's were applied (I don't know which ones) and now any SQL that converts strings to dates fails. The iSeries is managed elsew... Ask the Expert
-
Run command on a PC
One Search400.com member writes, "I want to start a .Wav file from my iSeries. It works with the STRPCCMD but the length of the parameter is limited to 123, which is too small. Are there any alternatives?" PC/Windows connectivity expert Shahar Mor re... Ask the Expert
-
Why is my job taking twice as long?
We are running a series of overnight downloads from the iSeries using SQL server with ODBC connections. The job runs in subsystem QUSRWRK. The job, which once took two hours, leapt to a current five hours with no apparent changes to jobs, configurati... Ask the Expert
-
Problems with new server and PC
One user writes, "We have made some changes in our network. We added a new server, and a new PC was installed in the old V3R2 Client Access. We are still running OS/400 V3R7 on the iSeries. In the old network, which is still available, I can see in ... Ask the Expert
-
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. Tip
-
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
- See more All on Physical connections to iSeries
About Physical connections to iSeries
Making physical connections between iSeries, printers and other IT hardware isn't always as straightforward as it sounds; especially when you have to create an iSeries network that meets every users' standards. Get news, tips and advice about physical connections to iSeries in this topic.