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




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