Re: Question about UDB on iSeries

Jim, 

when you use ops nav, how/where do you save your source?


On Thu, 2 Dec 2004 08:50:02 -0600, Reinardy, James
<jreinardy@xxxxxxxxxxxxxxx> wrote:
> Rick,
> 
> I generally do most things in Ops Nav, though my more experienced
> developers are more comfortable in the green screen environment.
> 
> 
> 
> Jim
> 
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rick baird
> Sent: Wednesday, December 01, 2004 8:11 PM
> To: Midrange Systems Technical Discussion
> Subject: Re: Question about UDB on iSeries
> 
> Jim,
> 
> That's good to hear.   Question:  do you develop your database
> exclusively via ops nav?
> 
> On Wed, 1 Dec 2004 17:00:57 -0600, Reinardy, James
> <jreinardy@xxxxxxxxxxxxxxx> wrote:
> > I am currently managing a corporate IS department that uses the
> > iSeries for its primary business application.  However, my background
> > is much more rooted in Sybase, SQL Server and in particular Oracle.
> > My experience with DB2/400 is that it now competes feature for feature
> 
> > with the other databases, but this may be a a recent development. I
> > believe that IBM has been playing catch up with the SQL functions of
> > DB2/400 compared to the competition, including its own UDB product,
> > but is just about there now with v5r2 and beyond.  I have been pretty
> > successful at introducing new techniques to my department by assuming
> > since Oracle has it, there is probably a similar feature in DB2/400.
> > We discovered SQL triggers, SQL views and the SQL tools in Operations
> Navigator that way.
> > I have yet to be disappointed to find that there was not a feature I
> > was looking for.
> >
> > I will admit to some misgivings about the proprietary nature of the
> > hardware and OS compared to the Oracle world I am used to, but I have
> > no complaints about the robustness of the software, including the
> database.
> >
> > Jim Reinardy
> >
> >
> >
> > -----Original Message-----
> > From: midrange-l-bounces@xxxxxxxxxxxx
> > [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Joe Pluta
> > Sent: Wednesday, December 01, 2004 4:35 PM
> > To: 'Midrange Systems Technical Discussion'
> > Subject: RE: Question about UDB on iSeries
> >
> > > From: Dave Odom
> > >
> > > UT the reality is, it and DB2 are not usually used in the same
> > > environments and for the same types of applications and reasons as
> > > the
> >
> > > mainframe.
> >
> > I'm interested in this statement!  Do mainframes not do CICS-type
> > applications anymore?  Because for the life of me I can't discern the
> > difference between CICS-based order entry in COBOL and green-screen
> > order entry in RPG IV (or NEP-MRT order entry in RPG II, for that
> > matter).
> >
> > If your contention is that mainframes are used more for data
> > warehousing on multi-terabyte databases, then I guess you're probably
> right there.
> > The iSeries is only just beginning to target that environment,
> > although from what I understand EVIs and the like make the iSeries a
> > pretty nice platform for those things.
> >
> > > There are reasons why mainframe shops and mid-range shops using
> > > RDMBs like DB2 and Oracle went with those
> > engines
> > > and platforms and not with the iSeries.
> >
> > What are the reasons?
> >
> > > In addition, most iSeries shops I know of, since they have been
> > > influenced by Rochester and tend to move only in that environment
> > > and have done so for decades, don't have an unbiased view of how
> > > different
> >
> > > the DB2/400 implementation is from the rest of IBM and why that is
> > > not
> >
> > > necessarily good.
> >
> > Actually, we didn't even know we were running DB2 until we were told
> > so by IBM.  Until then we were just running OS/400 (or CPF).  We just
> > knew we had the fastest database on the planet for the type of
> > navigational access that best describes business logic.
> >
> > > One of the questions that should be answered is, "but with all that,
> 
> > > can DB2/400 be used wisely and in keeping with the
> > tenets
> > > usually found in the rest of the RDBMs world and why is that
> > > important
> >
> > > to my business?"
> >
> > Can you provide these tenets?  Or better yet point out where they are
> > published.  Can I see them online somewhere?  Download them?
> >
> > Joe
> >
> > --
> > 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 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 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 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.
> 
>