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