newbie question on AS/400 PRMS system
george
1. What database does the PRMS system use?
2. How to manage the database? Any tools in Microsoft Windows system?
Where to get them?
3. Can some views be created on the database(like in SQL server)?
4. Any ODBC driver for me to access the data? Where to get them?
I don't have any experience in the AS/400. So please forgive me for my
silly questions.
PGU
news:d0d57e39.04090...@posting.google.com...
> CA PRMS 8.3-9494
What's PRMS ?
Jack Kingsley
1. PRMS uses DB2400.
2. You would manage the database via AS/400 dumb terminals or telnet
sessions.
3. Views could probably be created, not sure of your exact question.
4. You could use Client Access ODBC driver. Client Access driver
would come with the client access software that you would install on a
PC.
5. I have worked with PRMS, if you want to call me to discuss further
here is my number 469.549.5150.
Kevin Barkmea
just like any other native iSeries database created using DDS.
Considering you seem to lack iSeries knowledge and you want to look at
data via Windows you are probably looking at some major $$$$$ for
another package. There are several PRMS consulting companies that
offer on site help and software to help you get where you want.
I really thing you need to get some iSeries veterans on your staff if
that is financially possible. Some seasoned Iseries people will be
able to look at the PRMS database and quickly created new programs to
slice/dispaly/modify the data anyway you can dream of. If iSeries
professionals are not available then pulling data via Query and SQL
may be enough for you and these tools are fairly easy to pick up. Use
PRMS helpdesk to answer all questions and don't modify anything.
Sriram
the company where its being used should be able to tell you more about it?
There's an overview at
http://www.homercomputer.com.au/homer_software_guide/PP/ssa_prms_pp1.htm
It uses the integrated DB2 database on IBM AS/400 servers.
The database can be managed from the native OS/400 (operating system)
command line or the Client Access graphical interface for Windows which is
offered along with the hardware system by IBM.
Views can indeed be created on the database.
There are ODBC drivers available (one comes with the Client Access Express
product from IBM) to query the database tables.
Depending on the installation, there might be authorisation issues which
might prevent you from directly accessing all database tables without using
the PRMS interface.
PRMS in your version also has some features allowing direct interaction with
the MRP II system through PC software.
"george" <lhi...@hotmail.com> wrote in message
news:d0d57e39.04090...@posting.google.com...
Jonas Temple
The database that's built into the OS. When PRMS was created it
didn't have a name but IBM branded it DB2/400 in the past.
>
> 2. How to manage the database? Any tools in Microsoft Windows system?
> Where to get them?
I would definitely look into iSeries Access (AKA Client Access).
There are also numerous OS/400 commands used to work with the
database, check out the iSeries Info Center:
http://publib.boulder.ibm.com/html/as400/infocenter.html. To be
honest, the database will need little administration on your part, it
takes care of itself quite well.
>
> 3. Can some views be created on the database(like in SQL server)?
Yes, if you have the SQL product installed you can issue the OS/400
command STRSQL and from the resulting screen you can run the CREATE
VIEW statement. There are other ways of creating a view without the
SQL product installed (see FROG below).
>
> 4. Any ODBC driver for me to access the data? Where to get them?
Yes, in iSeries Access for Windows (as mentioned above). There are
also 3rd party drivers available as well.
If you're comfortable with the Windows environment then you can try my
FREE Windows based database inquiry tool called FROG. It requires
iSeries Access. You can download at
http://www.yhti.net/~jktemple/frog.htm.
>
> I don't have any experience in the AS/400. So please forgive me for my
> silly questions.
Not silly questions! We'll be more than happy to give you info on the
BEST platform known to man. :)
Jonas
Denny Davis
That version is not Y2K compliant is not supported by the curent owner
of PRMS. 8.4 is the frist Y2K version and there are 8 subversions of
it.. Then there was 9.0, 9.1 and 9.2. Version 10.0 went GA in August
2004.
PRMS uses the native data base of OS/400, which IBM is currently
calling DB2 UDB.
What do you mean by manage? Maintenance for a PRMS data base is almost
zero. And the same for most AS/400 DBs.
If you are running V8.3 of PRMS, they you may be on an oboselete
version of OS/400. Hard to say what level of SQL support you have.
Current versions of OS/400 have the standard SQL sys tables . All
versions have the native data base information.
iSeries Navigator, a component of iSeries Access contains a data base
mapping function.
At 8.3 PRMS consisted of around 400 physical files (tables) and 1,300
logical files (views). A logical file is a hybrid of a SQL view and/or
a SQL index. When you use SQL to create a view or index, it actually
creates an OS/400 logical file. Check to see if there is an existing
logical before you start creating views.
You need to find a manual called the PRMS Database Reference Gude.
This documents the physical file layouts. I no logner have any 8.3
manuals, but in 8.4 it is slightly over 1,000 pages.
The bulk of this manual is generated directly from the OS/400 data
base. PRMS supplies the sofware to print this information. If this
software is installed, the ugly command name is PRTRCDLYT, Print
Record Layout. It is typically in the RMSTD library. The TD (Technical
Documentation) library is optional and frequently missing.
The IBM emulator product iSeries Access (old name Client Access)
includes an OBDC diver. No licence is required for this dirver. There
are numerous other ODBC and JDBC drivers available.
It should not take you more that a couple of years to get up to speed
on OS/400 and PRMS.
Denny
770 297 9929
Chuck Ackerman
It appears that you are trying to access an iSeries (aka AS/400 or i5) that
has a very expensive software package on it. Probably a combination of the
iSeries and PRMS would approach a half a million dollars. One must assume
that the purchaser of that system has some iSeries technical staff to
support such a package or they wouldn't have spent that kind of money.
So, I've gotta ask this direct question. Does the owner of the system know
that you, with no iSeries experience, are trying to get at the database?
Why aren't you asking the technical support staff how to get at the data
instead of us? Something seems a little fishy here.
chuck
Opinions expressed are not necessarily those of my employer.
"george" <lhi...@hotmail.com> wrote in message
news:d0d57e39.04090...@posting.google.com...
Robert Comer
> That version is not Y2K compliant is not supported by the curent owner
> of PRMS. 8.4 is the frist Y2K version and there are 8 subversions of
> it.. Then there was 9.0, 9.1 and 9.2. Version 10.0 went GA in August
> 2004.
It's possible -- we're using 8.2C here. It was modified locally to handle
Y2K. (by me)
- Bob Comer
"Denny Davis" <sp...@nowhere.com> wrote in message
news:ubl0k0tsm8ofsoua8...@4ax.com...
Chuck Ackerman
nothing like the version installed in 1988.
chuck
Opinions expressed are not necessarily those of my employer.
"Robert Comer" <bobcomer_...@mindspring.com> wrote in message
news:chq7vh$6ad8$1...@news3.infoave.net...