RE: DB and App Agnosticism on the iSeries (thinking about: Questi on about UDB on iSeries)

Pete,

All of the above,

We have applications that use bog-standard DDS defined Pf's and LF's, SQL
defined views, 
Native RPG, Stored Procedures and Functions defined in the database but
written in RPG, so accessible both from 
RPG CGI, net.data and Java Web Applications native RPG applications.

Why would you stick to native RPG for everything? Use whats most appropriate
to what your trying to do.

Eg theres no point in doing hefty batch updates in Java,
Theres no point trying to write web screens in RPG, when its so easy to do
with jsp's,

If you don't try them all, how do you know whats best for each situation?

cheers
Colin.W

http://as400blog.blogspot.com
 
Extension   5800
Direct dial   0870 429 5800


-----Original Message-----
From: Pete Helgren [mailto:pete@xxxxxxxxxx] 
Sent: 30 November 2004 16:19
To: 'Midrange Systems Technical Discussion'
Subject: DB and App Agnosticism on the iSeries (thinking about: Question
about UDB on iSeries)


I started with "RE: Question about UDB on iSeries" but this takes the
discussion off thread so I'll start another:

I am going to extend the conversation to help satisfy some of my questions
about DB2 UDB on the iSeries as well. I wonder how many of us folks are
running the iSeries solely as a DB server and only running the DB using SQL
tables rather than physical files ( I know they are similar but there are
also some fundamental differences between CRTLIB/CRTPF and CREATE
COLLECTION/CREATE TABLE).  How many folks are running iSeries that may serve
applications and those apps are either 100% SQLRPG or 100% Java (that is, no
"native" DB I/O)?

Things get fuzzy in this iSeries world precisely because OS and DB are so
tightly coupled so it is difficult to treat this box solely as a DB server
or an application server.  I know nothing about mainframes but are DB and
applications separate in that world?

My curiosity here stems from the fact that we have raging debates within the
company about developing our apps using a cross platform orientation
(agnostic as to DB and application serving) vs. sticking to what we know and
use RPG and native I/O in our app design.  I love the iSeries for it's
stability and ease of management but I think it is short sighted to write
applications that only run on the iSeries.  Again, I LOVE this box, but the
world out there, as indicated by many of the conversations in this forum,
ain't "iSeries centric" and there is a much bigger market for us to tap into
if we design the software to run on the iSeries AND another platform that
can run Java and a DB like DB2 or mySQL or MSSQL or....

Just wonder what the rest of you thought.

Peter Helgren
Value Added Software, Inc
801.581.1154 x202

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.
This e-mail has been sent by a company of Bertram Group Ltd, whose registered 
office is 1 Broadland Business Park, Norwich, NR7 0WF. 
This message, and any attachments, are intended solely for the addressee and 
may contain privileged or confidential information.  If you are not the 
intended recipient, any disclosure, copying, distribution or any action taken 
or omitted to be taken in reliance on it, is prohibited and may be unlawful.  
If you believe that you have received this email in error, please contact the 
sender immediately. Opinions, conclusions and statements of intent in this 
e-mail are those of the sender and will not bind a Bertram Group Ltd company 
unless confirmed in writing by a director independently of this message. 
Although we have taken steps to ensure that this email and any attachments are 
free from any virus, we advise that in keeping with good computing practice the 
recipient should ensure they are actually virus free.