5 Simple AS/400 Data Download Techniques
One of the most common questions I get is how do I get the data from my AS/400 or iSeries onto my computer or Excel spreadsheet program so I can manipulate it using PC programs and spreadsheets. Now back in the old days this used to be a daunting task, but now in modern times with database tools and ODBC drivers that come bundled with your system downloading any data you need over to a PC can be done in a snap.
The first tool for making your data transfer life easier is the Excel Add-in that is included with your Client Access software licenses, and most systems come with Client Access. The Excel add-in tool allows you to query, sort, order and more data requests to your system using SQL like syntax and dump those results directly into your beloved Excel spreadsheet without any hassle. If you have Excel downloads you routinely use you can even save the configuration for later use.
Along the same lines as the Excel add-in is the Data Transfer portion of the 5250 emulator program included with Client Access. This program functions identically to the AS/400 Excel Add-in except that it returns the query results to a plain text data file instead of a spreadsheet.
Now if you are building an MS Access database program or coding another Windows based program that can't use a download but will need access to your AS/400 data in real time there is an available ODBC driver that comes with your Client Access licenses, or if you are using Java you can use JDBC.
An older set of commands available from within the AS/400 allow you to copy entire physical files and tables over to the Integrated File System where you can then access and download the file using Operations Navigator or through a network share. To use this method you simply issue the one of the commands Copy to PC Document- CPYTOPCD or Copy to Import File with the command CPYTOIMPF. For either of these commands you simply specify the IFS path and file name in the stream file parameter field. It should be noted that both of these options copy the physical file over verbatim, you can't use constraints.
Getting network shares working takes a little effort and configuration but once complete the AS/400 acts just like another file server on your Windows network so you can retrieve files. So after using the Copy to PC Document or Copy to Import File programs you simply download the file to your PC like you would from another Windows file server.
Finally you may need to copy over your printable reports and spool files to a computer and fortunately Operations Navigator has you covered as well. Simply open up operations navigator, click on basic operations then click on printer output to display a list of spool files you can download to your computer. To download you can simply click and drag the file to your desktop and it will automatically be converted to a plain text document or if you right click on the document there is an option to convert it to an Adobe pdf document.
Questions and Answers
In 1988, IBM introduced the AS400® as a server solution for midsize businesses and departments within larger enterprises. Over time, IBM realized that in order to fulfill their vision of replacing PC and Unix servers throughout organizations worldwide, the AS400 would need to be easily integrated with distributed networks and...
How does RPG AS400 address the internet? Has it moved on from the green screen? Is it really going anywhere or has it anywhere left to go? Well they said it was dead twenty years ago but it's still going strong and I guess as long as there's life in the Series i or whatever that morphs into then there will be life in RPG.
Understanding how the printer systems flow on the AS/400, iSeries and System i is a basic system administration function. Typically most of the issues that occur from day to day either have to do with jobs or printers, so it's important to be able to do basic troubleshooting of printing. Now...
There is a large misconception running about the user community these days that the AS/400 and iSeries platform are old antiquated machine as scarce as the dinosaurs and just as hard to use with its crummy looking text only interface commonly known as the green screen. This is a major...
The AS/400 and iSeries systems are essentially command driven operating systems. There are definite advantages to a command line driven environment but nowadays with the widespread popularity of GUIs people seem to recoil when talking about anything command driven. The good news is that the native command set available on...
The operating system that natively runs on the AS/400 and iSeries platform is a command and menu driven system, so it's important that you have a good understand of how to use commands and in particular become familiar with commands you will use regularly. For some people the command driven...
An in depth look at the new MMORPG from Blizzard Entertainment known as Diablo III, a long awaited release for Diablo fans.
Most small businesses take advantage of computer technology, and it certainly can make things a lot easier for everyone within the business when you do so properly. Unfortunately, there are also a number of different problems that can occur as a result of the technology that you are using.
The remote desktop software is quite an amazing type of software with plenty of features that can come in handy at work or even at home. The feature lets you obtain remote access to an assortment of other computers, directly from the computer that you are using at the moment. This software is often used by people who work in an office or business setting.
Remote desktop software is a type of software that allows users to get access to a remote computer. Basically, if you have this software, you will have the ability to view the remote computer and also control it with the mouse you are using. A number of these software programs will also enable you to send documents to and from one computer to another.
The second selection of pc ink cartridges is the compatible low-priced cartridges.
When it comes to reporting tools for the AS/400, iSeries and IBM i platform there are many products to pick from. In fact a whole cottage industry has sprang up over the years with a myriad of different data tools for reviewing and extracting data from the OS/400 integrated DB2...
One of the more commonly asked questions I see in forums and by end users is how do you get your data from the AS400 down to the PC in a text file format or as an Excel based spreadsheet. And fortunately with modern tools and software this is a...
Whenever I start working on an AS/400, iSeries or Power System box at a new company there are a few key areas I like to be sure of. These areas include ensuring basic system level security, job configuration and process management. Let's take a fast look at how you can...
One of the nice features of the AS/400 and iSeries platform is it's reliability and administrative requirements. But even in light of this as a system administrator you should also be looking and monitoring key data elements to create a baseline of performance metrics. This data can then be used...
Having worked on and administered IBMs midrange AS/400, iSeries and System i platforms for the better part of ten years I have found that you can boil down the essential administrative functions to a few select commands available from one primary command. Let me explain. One of the major functions of...
Discuss this Article
