PHP and iSeries

[Thad Rizzi]

My webserver is an iSeries and I want to run some PHP scripts on it
using SQL to access data on the iSeries. Does anyone have any
exapmles or resources on the most effective way to do this?

I am rather green with PHP.

Any help would be appreciated,
Thad Rizzi

[Michael Austin]

Re: PHP and iSeries

Thad Rizzi wrote:
[color=blue]
> My webserver is an iSeries and I want to run some PHP scripts on it
> using SQL to access data on the iSeries. Does anyone have any
> exapmles or resources on the most effective way to do this?
>
> I am rather green with PHP.
>
> Any help would be appreciated,
> Thad Rizzi[/color]

iSeries means nothing except that it is an IBM box. What OS - Linux,
AIX, WNT(hack,hack,c ough,cough,gag! !!!)? Do you have PHP installed? Are
you using Oracle, DB2 or MySQL, SQL Server(hack,hac k,cough,cough,g ag -
you're killing me here!!!!) ? Are they installed and configured?

If not, download and install PHP for your platform.
start at http://www.php.net
Download and install MySQL and configure it (create databases etc...)
start at http://www.mysql.com
Which web server - because there are lots of things that must be
changed/added to the web server configurations for PHP to work.

The web is full of examples - try google -- and BTW, the "box" you are
using in these searches is irrelavent.

Michael Austin

[Benny Hill]

Re: PHP and iSeries

On Fri, 25 Jun 2004 14:21:20 +0000, Michael Austin wrote:
[color=blue]
> Thad Rizzi wrote:
>[color=green]
>> My webserver is an iSeries and I want to run some PHP scripts on it
>> using SQL to access data on the iSeries. Does anyone have any
>> exapmles or resources on the most effective way to do this?
>>
>> I am rather green with PHP.
>>
>> Any help would be appreciated,
>> Thad Rizzi[/color]
>
> iSeries means nothing except that it is an IBM box. What OS - Linux,
> AIX, WNT(hack,hack,c ough,cough,gag! !!!)? Do you have PHP installed? Are
> you using Oracle, DB2 or MySQL, SQL Server(hack,hac k,cough,cough,g ag -
> you're killing me here!!!!) ? Are they installed and configured?[/color]

Hi Michael,

I'm not sure how familiar you are with iSeries (the box formerly known as
AS/400) but typically you're running OS/400 (which IBM is calling i5/OS
nowadays). I guess you might be able to put AIX on it but I personally
have never seen nor heard of that. If you have an AS/400 with an LPAR you
can run linux along side OS/400.

So... the original poster is almost certainly running OS/400 and a
bastardized version of Apache. He is also almost certainly talking about
pulling data from the DB2/DBUniversal databases.
[color=blue]
> The web is full of examples - try google -- and BTW, the "box" you are
> using in these searches is irrelavent.[/color]

On the contrary, SQL for DB2 is different than it is for MySQL et. al. so
what "box" you're doing this on is quite relevant (since it's far
more common for people to talk about AS/400 and SQL not DB2 and SQL and
that is what Google will index)

Thad - I've never used the Apache server that comes with the AS/400
but I have written several applications that pull data from an AS/400 to
an Apache server running on a separate linux machine. In my case though I
had to use Java because I was making program calls rather than just
pulling data.

Here are some links that might be helpful:

http://www.php-faq.com/as400.html

http://dns.celleweb.de/db2/db2howto.eng.html

http://www-1.ibm.com/servers/eserver/iseries/linux/odbc/index.html

and if you're dealing with RVI you may as well plan on figuring everything
out yourself 'cause you'll not get any help from ole Monty or his people.

[Thad Rizzi]

Re: PHP and iSeries

Benny Hill <benny_hill3@yo ur_rose_colored _glassesyahoo.c om> wrote in message news:<pan.2004. 06.26.03.12.05. 243537@your_ros e_colored_glass esyahoo.com>...[color=blue]
> On Fri, 25 Jun 2004 14:21:20 +0000, Michael Austin wrote:
>[color=green]
> > Thad Rizzi wrote:
> >[color=darkred]
> >> My webserver is an iSeries and I want to run some PHP scripts on it
> >> using SQL to access data on the iSeries. Does anyone have any
> >> exapmles or resources on the most effective way to do this?
> >>
> >> I am rather green with PHP.
> >>
> >> Any help would be appreciated,
> >> Thad Rizzi[/color]
> >
> > iSeries means nothing except that it is an IBM box. What OS - Linux,
> > AIX, WNT(hack,hack,c ough,cough,gag! !!!)? Do you have PHP installed? Are
> > you using Oracle, DB2 or MySQL, SQL Server(hack,hac k,cough,cough,g ag -
> > you're killing me here!!!!) ? Are they installed and configured?[/color]
>
> Hi Michael,
>
> I'm not sure how familiar you are with iSeries (the box formerly known as
> AS/400) but typically you're running OS/400 (which IBM is calling i5/OS
> nowadays). I guess you might be able to put AIX on it but I personally
> have never seen nor heard of that. If you have an AS/400 with an LPAR you
> can run linux along side OS/400.
>
> So... the original poster is almost certainly running OS/400 and a
> bastardized version of Apache. He is also almost certainly talking about
> pulling data from the DB2/DBUniversal databases.
>[color=green]
> > The web is full of examples - try google -- and BTW, the "box" you are
> > using in these searches is irrelavent.[/color]
>
> On the contrary, SQL for DB2 is different than it is for MySQL et. al. so
> what "box" you're doing this on is quite relevant (since it's far
> more common for people to talk about AS/400 and SQL not DB2 and SQL and
> that is what Google will index)
>
> Thad - I've never used the Apache server that comes with the AS/400
> but I have written several applications that pull data from an AS/400 to
> an Apache server running on a separate linux machine. In my case though I
> had to use Java because I was making program calls rather than just
> pulling data.
>
> Here are some links that might be helpful:
>
> http://www.php-faq.com/as400.html
> http://dns.celleweb.de/db2/db2howto.eng.html
> http://www-1.ibm.com/servers/eserver...dbc/index.html
>
> and if you're dealing with RVI you may as well plan on figuring everything
> out yourself 'cause you'll not get any help from ole Monty or his people.[/color]

Thanks for the info Benny. You were right on with what I was running
and trying to do. My mistake for assuming that everyone is familiar
with the iSeries platform. For the record, I am running V5R2 of
OS/400 as my operating system. I am running IBM's webserver, "powered
by Apache". I wish to connect to UDB (IBM's database on the iSeries)
using PHP which is installed and configured on the iSeries but for
which IBM offers no real support. As I mentioned in my earlier post,
I am rather new to PHP and hopefully will not kill anyone with my
posts.

Thad Rizzi

[Thad Rizzi]

Re: PHP and iSeries

Michael,

From here on I would appreciate it if you refrained from participating
in any threads initiated by me.

Thanks,
Thad Rizzi


Michael Austin <maustin@firstd basource.com> wrote in message news:<AxWCc.870 9$fY3.4702@news svr24.news.prod igy.com>...[color=blue]
> Thad Rizzi wrote:
>[color=green]
> > My webserver is an iSeries and I want to run some PHP scripts on it
> > using SQL to access data on the iSeries. Does anyone have any
> > exapmles or resources on the most effective way to do this?
> >
> > I am rather green with PHP.
> >
> > Any help would be appreciated,
> > Thad Rizzi[/color]
>
> iSeries means nothing except that it is an IBM box. What OS - Linux,
> AIX, WNT(hack,hack,c ough,cough,gag! !!!)? Do you have PHP installed? Are
> you using Oracle, DB2 or MySQL, SQL Server(hack,hac k,cough,cough,g ag -
> you're killing me here!!!!) ? Are they installed and configured?
>
> If not, download and install PHP for your platform.
> start at http://www.php.net
> Download and install MySQL and configure it (create databases etc...)
> start at http://www.mysql.com
> Which web server - because there are lots of things that must be
> changed/added to the web server configurations for PHP to work.
>
> The web is full of examples - try google -- and BTW, the "box" you are
> using in these searches is irrelavent.
>
> Michael Austin[/color]

[Benny Hill]

Re: PHP and iSeries

On Sun, 27 Jun 2004 20:51:15 -0700, Thad Rizzi wrote:
[color=blue]
> Thanks for the info Benny. You were right on with what I was running
> and trying to do. My mistake for assuming that everyone is familiar
> with the iSeries platform. For the record, I am running V5R2 of
> OS/400 as my operating system. I am running IBM's webserver, "powered
> by Apache". I wish to connect to UDB (IBM's database on the iSeries)
> using PHP which is installed and configured on the iSeries but for
> which IBM offers no real support. As I mentioned in my earlier post,
> I am rather new to PHP and hopefully will not kill anyone with my
> posts.
>
> Thad Rizzi[/color]

I'm afraid I don't have much else to add. I assume you are familiar with
the WRKLNK command so you can view/edit files in the IFS. The web stuff
is in /www/apachedft/htdocs/ (at least on the AS/400 I'm looking at right
now).

I was researching hosting companies recently and I remember that one of
them offered hosting on AS/400's (which I thought was really weird). You
might try Googling for "AS400 web hosting" or something. If you find a
place offering hosting they might have documentation that you can get to
that discusses getting access to the DB2 (or UDB or whatever IBM calls
their database nowadays) databases.

If you can't find the information you need as a last resort you could
consider running the webserver on a separate box running linux/apache.
Then you could use PHP/ODBC to connect to the AS/400 or JavaServer Pages
and JDBC (search for the IBM Java Toolbox or jt400).

Good luck!

[Michael Austin]

Re: PHP and iSeries

Thad Rizzi wrote:[color=blue]
> Michael,
>
> From here on I would appreciate it if you refrained from participating
> in any threads initiated by me.
>
> Thanks,
> Thad Rizzi
>
>
> Michael Austin <maustin@firstd basource.com> wrote in message news:<AxWCc.870 9$fY3.4702@news svr24.news.prod igy.com>...
>[color=green]
>>Thad Rizzi wrote:
>>
>>[color=darkred]
>>>My webserver is an iSeries and I want to run some PHP scripts on it
>>>using SQL to access data on the iSeries. Does anyone have any
>>>exapmles or resources on the most effective way to do this?
>>>
>>>I am rather green with PHP.
>>>
>>>Any help would be appreciated,
>>>Thad Rizzi[/color]
>>
>>iSeries means nothing except that it is an IBM box. What OS - Linux,
>>AIX, WNT(hack,hack,c ough,cough,gag! !!!)? Do you have PHP installed? Are
>>you using Oracle, DB2 or MySQL, SQL Server(hack,hac k,cough,cough,g ag -
>>you're killing me here!!!!) ? Are they installed and configured?
>>
>>If not, download and install PHP for your platform.
>>start at http://www.php.net
>>Download and install MySQL and configure it (create databases etc...)
>>start at http://www.mysql.com
>>Which web server - because there are lots of things that must be
>>changed/added to the web server configurations for PHP to work.
>>
>>The web is full of examples - try google -- and BTW, the "box" you are
>>using in these searches is irrelavent.
>>
>>Michael Austin[/color][/color]

My apologies if you were offended by my attempt to point you in the
right direction. I do know a bit about the iSeries, not only does it
run OS/400, but it also can run Linux and in the near future AIX.
(see << http://www-1.ibm.com/servers/eserver/iseries/linux/ >> for more
details). And a simple google search for "iseries aix" will yield this
quote "Adding to its list of supported platforms, the iSeries is slated
to announce support for AIX in iSeries logical partitions with the next
generation of iSeries" at:
http://www.iseries400experts.com/aiw/02-0204.jsp - granted I did not
read the whole article, but this seems to suggest that you will see it
in the near future... which is why it was included in my question of OS
type. Also, according to IBM's website AIX-5L is now available for the
iSeries.

When posting about a tool/language, it has always been proper netiquette
to provide at least some basic information regarding the operating
system and versions of the tools/languages in question as the answer may
differ from version to version.

Michael Austin.