RE: Writing db2 procedures in cobol

RE: Writing db2 procedures in cobol

 

  

I wrote:
>> 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.
You wrote:
>Makes one wonder what the hell they are teaching
>in college now a days.
I see we agree on that one. What is the average age of a DB2 for LUW
developer at IBM given that
Lou cleansed IBM out in the early nineties and DB2 for LUW was born at
about that time?
Hint: I started University in 1990 and learned Modula, Lisp and C. I could
have learned Prolog via the AI track..
I joined DB2 for LUW development at V5.

Note that I'm not questioning that COBOL rules in legacy applications.
I do very much question, however, that COBOL is the most used language in
the world.
Likely that is Visual Basic :-(. The server side is just blessed to never
see VB.
There is a lot more new code than old code out there, part of the IT
explosion.

Either way I positively do not recomend COBOL for new applications on DB2
for LUW
Now people can take my advise or not.

Cheers
Serge



"Sobocinski Ken "
<db2udbdba-ezmlmshield-x73070711.[Email address protected] wrote on
09/26/2005 09:51:52 AM:

> Are you kidding? Sarcasm? COBOL is most likely the most in-use language
> in the world. Additionally, I am in a shop where some brain-dead
> executive decide to convert from mainframe and COBOL to servers and Java
> and C++. SO far, this 18 month conversion has become a 5 year 30 million
> dollar white-elephant. Makes one wonder what the hell they are teaching
> in college now a days.
>
> EBCIDC is a much better than ASCII. But ASCII requires much less thought
> on what is happening under the hood.
>
> BAL = Basic Assembler Language. A very good version of the language.
> Based on Hexadecimal. (Base 16)
> TAL = Tandem Assembler Language. A not so good but functional version of
> the language. Based on Octal. (Base 8)
>
> Have a Great Day!
>
> Ken
>
> -----Original Message-----
> From: Serge Rielau
> [mailto:db2udbdba-ezmlmshield-x85557182.[Email address protected]
> Sent: Friday, September 23, 2005 8:13 PM
> To: LazyDBA Discussion
> Subject: 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
>
>
>
> ATTENTION: This electronic document and associated attachments (if
> any) may contain confidential information of the sender (SHAZAM
> Network) and is intended solely for use by the addressee(s). Review
> by unintended individuals is prohibited. If you are not the intended
> recipient: (i) do not read, transmit, copy, disclose, store or
> utilize this communication in any manner; (ii) please reply to the
> sender immediately, state that you received it in error and
> permanently delete this message and any attachment(s) from your
> computer and destroy the material in its entirety if in hard copy
> format. If you are the intended recipient, please use discretion in
> any e-mail reply to ensure that you do not send confidential
> information as we cannot secure it through this medium. By
> responding to us through internet e-mail, you agree to hold SHAZAM,
> Inc. and all affiliated companies harmless for any unintentional
> dissemination of information contained in your message. Thank you.
>
>
>
> ---------------------------------------------------------------------
> 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