RE: Question about UDB on iSeries

I think I would still save the SQL source.  We have this library that 
would not restore to another machine.  We let it slide for a few years. 
Every year or so it would pop up.  Never a big priority - this library. 
Did a save and sent it off to IBM.  They could never restore it either. 
They suggested rebuilding the files.  We don't have the source and 
retrieving the definitions from iSeries Navigator doesn't seem to be 
working.  RCLSTG, etc aren't the answer here either.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Reinardy, James" <jreinardy@xxxxxxxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
12/02/2004 06:46 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
cc

Subject
RE: Question about UDB on iSeries






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.


--
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.