"In maintenance departments".

I rest my case
Serge


"Heijer Rob den "
<db2udbdba-ezmlmshield-x30224312.[Email address protected] wrote on
09/24/2005 02:58:54 AM:

>
> 'Fraid not. In maintenance departments, you will find the Cobollers
> doing their jobs. Often for multiple companies.
> Writing (and maintaining) is, on paper, my job. In practice, it
> amounts to 20% of my time - tops.
> But do not underestimate the staying power of Cobol.
>
> Mind you: I am not exactly a Cobol-lover. But (no sarcasm!) I have
> done some amazing things with it.
> Rob.
>
> -----Oorspronkelijk bericht-----
> Van: Serge Rielau [mailto:db2udbdba-ezmlmshield-x85557182.[Email
> address protected]
> Verzonden: za 24-9-2005 3:13
> Aan: LazyDBA Discussion
> Onderwerp: RE: Writing db2 procedures in cobol
>
> I hope that I'm just missing the sarcasm here.
> If not: How many years is it that you tried to hire someone? These days
> it's hard to get good C/C++ skills. COBOL? You gotta be kidding.
>
> Cheers
> Serge
>
> PS: What is BAL?
>
> Serge Rielau
> DB2 Solutions Development
> DB2 Universal Database for Linux, Unix, Windows
> IBM Toronto Lab
>
> "Abel Mike J " <db2udbdba-ezmlmshield-x16032317.[Email address
protected]
> wrote on 09/23/2005 04:36:52 PM:
>
> > Exotic? I would say procedures written in BAL would be exotic, but not
> > cobol. You can do so much more in a 'real' language than you can ever
do
> > in the pseudocode world of SPL. Since almost everyone knows cobol, it
> > seems like a perfect fit to me.
> >
> > -----Original Message-----
> > From: Serge Rielau
> > [mailto:db2udbdba-ezmlmshield-x86353675.[Email address protected]
> > Sent: Thursday, September 22, 2005 5:49 AM
> > To: LazyDBA Discussion
> > Subject: Re: Writing db2 procedures in cobol
> >
> > Which version of DB2 are you on?
> > An external procedure can beat an SQL Procedure in V8 and V8.2 only if
> > it runs UNFENCED.
> > I doubt the gain will be significant in V8.2.
> > Also note that COBOL stored procedures nowadays are rather exotic,
> > albeit supported.
> > I have yet to come across a warehousing procedure (batch procing of the
> > staging table????) which can't be significantly improved by fixing the
> > algorithm.
> > Take a look at this article:
> >
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0501rie
> > lau/
> > and
> >
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0411rie
> > lau/
> >
> > There is also a tracer and profiler you can find under my name at the
> > same site.
> >
> > Cheers
> > Serge
> >
> >
> > "Ritesh" <db2udbdba-ezmlmshield-x26008834.[Email address protected]
> > wrote on
> > 09/22/2005 03:07:12 AM:
> >
> > > Hi DBAs,
> > > We are using UNIX AIX system with DB2 as its database. This project
is
> >
> > > a datawarehousing project and we have got procedures( written in DB2)
> > > which normally take around 10-12 hours to run.
> > > Is that possible to rewrite these procedures in COBOL which can help
> > > in performance improvement?
> > >
> > >
> > > Regards,
> > >
> > > Ritesh Sinha
> > >
> > >
> > > Whilst this email has been checked for all known viruses, recipients
> > > should undertake their own virus checking as Xansa will not accept
any
> >
> > > liability whatsoever.
> > >
> > > This email and any files transmitted with it are confidential and
> > > protected by client privilege. It is solely for the use of the
> > > intended recipient.
> > > Please delete it and notify the sender if you have received it in
> > > error. Unauthorised use is prohibited.
> > >
> > > Any opinions expressed in this email are those of the individual and
> > > not necessarily the organisation.
> > > Xansa, Registered Office: 420 Thames Valley Park Drive,
> > > Thames Valley Park, Reading, RG6 1PU, UK.
> > > Registered in England No.1000954.
> > > t +44 (0)8702 416181
> > > w www.xansa.com
> > >
> > >
> > > ---------------------------------------------------------------------
> > > PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> > > website: http://www.LazyDBA.com
> > > To unsubscribe: http://www.lazydba.com/unsubscribe.html
> > >
> >
> >
> >
> > ---------------------------------------------------------------------
> > PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> > website: http://www.LazyDBA.com
> > To unsubscribe: http://www.lazydba.com/unsubscribe.html
> >
> >
> >
> > ---------------------------------------------------------------------
> > PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> > website: http://www.LazyDBA.com
> > To unsubscribe: http://www.lazydba.com/unsubscribe.html
> >
>
>
>
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>


DB2 & UDB email list listserv db2-l LazyDBA home page