Re: native PHP in V5R4???

["Dave Odom" <Dave.Odom@xxxxxxxxxxxx>]

Aaron,

To answer your first question...  Yes, as most of our applications are
RPG.   But that's not the point of the part of my statement you quoted. 
   The upshot of my point is... move away from native access and to SQL,
if you want to compete and be taken seriously in the RDBMS world.   

This same sort of conversation happened in the 1970's in the IBM
mainframe world [SQL and DB2 vs. DL/1 calls, VSAM, etc.], but they
realized that if they wanted to be a part of the RDBMS market place(and
they needed to in order to compete against ORACLE, etc.), they had to
standardize on SQL against DB2 and convert existing apps or move to SQL
with new.  

Single record access with SQL...  While you're correct about SQL being
good for set processing, single record processing is VERY fast, IF you
build the table and indexes AND application to maximize for transaction
processing; done all the time by VERY LARGE DB2 applications, at least
on the mainframe.   And, I know it can be true on the iSeries... all the
essential elements are there but the faithful have to move in the modern
direction.   IBM realizes this and is on a campaign to move the faithful
to SQL and the real DB2 world (no more files and fields and non-SQL
access. Mainly, Tables and Columns and SQL).

But, again, my major point is... to compete, the iSeries and its
followers have to become devotes and practitioners of really using DB2
and SQL or it the iSeries WILL fade away to, at best, a LINUX box
running utility apps or an AIX box with ORACLE.  At worst, it will be
out the door, replaced by Microsoft and SQL Server or some UNIX-flavor
with ORACLE.   If that is the case, just about everyone that likes the
iSeries, loses.

Take care,

Dave     

>>> albartell@xxxxxxxxx 2/23/2006 15:00:04 >>>
 > move to using mainstream languages (SQL for sure) and programming
methodologies.   

This statement leads me to believe that you have not used RPG native
DB
access. Have you? With RPG, SQL can enhance native DB access, but it
is
definitely not a replacement.

>Not true about SQL being slower access than RPG.
SQL works great for result sets but I would have a hard time believing
that
single record SQL access is as fast as RPG native DB access.  Maybe
things
have changed and my brain data is old though.

Aaron Bartell

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On
Behalf Of Dave Odom
Sent: Thursday, February 23, 2006 3:34 PM
To: web400@xxxxxxxxxxxx 
Subject: Re: [WEB400] native PHP in V5R4???

Not true about SQL being slower access than RPG.   But the bigger
picture is if the platform is to compete seriously in the market place
against other DBMS platforms it is imperative those using legacy
programming
languages (RPG, CL, etc.) move to using mainstream languages
(SQL for sure) and programming methodologies.   

Sincerely,

David Odom  

>>> MCUNNING@xxxxxxx 2/23/2006 12:31:30 >>>
Explain the easier comment for accessing DB2 ?  CGIDEV uses native RPG
Database IO that in my opinion is faster and easier and gives you more
control that other methods like SQL. 

>>> gmagnuson@xxxxxxxxxxxxx 2/23/2006 2:07:21 PM >>>
Eric Kempter wrote (in part...)
>>  Are we in effect asking for a native version of UNIX rather than
just >>PHP?  I look forward to reading everyone's opinion.



I see PHP as a form of DDS-5250 replacement...
(yes, it is so much more...)  I see that PHP pushes And pulls from the
DB2
database so much easier than CGIDEV.

My $.02 worth

Gerald






--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list To
post a
message email: WEB400@xxxxxxxxxxxx To subscribe, unsubscribe, or change
list
options,
visit: http://lists.midrange.com/mailman/listinfo/web400 
or email: WEB400-request@xxxxxxxxxxxx 
Before posting, please take a moment to review the archives at
http://archive.midrange.com/web400.


--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list To
post a
message email: WEB400@xxxxxxxxxxxx To subscribe, unsubscribe, or change
list
options,
visit: http://lists.midrange.com/mailman/listinfo/web400 
or email: WEB400-request@xxxxxxxxxxxx 
Before posting, please take a moment to review the archives at
http://archive.midrange.com/web400.