














Copyright © 2004
by Polaris Computing.
All rights reserved.
| |
|
Browsing
the AS/400 Data Easily |
|
The AS/400 is widely regarded as a reliable database server in the business and IT
community. Unfortunately, browsing data on it is not easily done. To
help rectify this situation, we developed Polaris AS/400 Data Browser, a
program for Windows clients. If your business uses an AS/400
along with IBM's AS400 Client Access package, then you will find Data
Browser to be an invaluable tool. The
programs that come with Client Access do not provide good data browsing
functions.
The 5250 Emulator program simply moves the traditional green screen into the
Windows environment making the PC a terminal. The AS400 Operations Navigator provides numerous
powerful functions, but using it to
browse data takes far more time and resources than is necessary.
Furthermore, it is impossible to see the files in the libraries that do not
show in Navigator's libraries list.
Client Access does include a great ODBC driver that can be used to access the AS/400 data at
high speeds. However, this requires some programming, and we did just
that.
Polaris AS/400 Data Browser adds a user interface to the AS/400 ODBC driver
and turns it into a data browser that is both quick and easy to use.
|
|

Click on the picture to enlarge.
|
The picture
on the left side shows the main window of the program.
Select a database from the databases list to
initialize the program, and you are ready to see all the data on your
AS/400. Enter a library name and file name, and then click on the Open
button, you see the data. When the data shows, you can more the
columns, change their widths... Searching is easy. Simply pick a field from
the fields list, enter the data you are looking for, and click on the Go button. The program also provides a SQL statement editor that makes
it easy to enter SQL statements. If you know how to use SQL, you have
all the flexibilities in choosing your data.
|
Polaris AS/400 Data Browser
is available for free, and can be freely distributed. Click
[here] to download a copy of Polaris Word Count.
|
|