RE: Question about UDB on iSeries -- MIDRANGE-L

The development we do is generally SQL based, so we have the option of
saving scripts right out of the editor onto a PC drive.  However, I have
never been too crazy about maintaining SQL source, since it can be
easily extracted from the database.  

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rick baird
Sent: Thursday, December 02, 2004 9:47 AM
To: Midrange Systems Technical Discussion
Subject: 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.
> 
>
--
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.