We teach C, C++, C#, Java, .Net, SQL, PL/SQL, T-SQL, and yes: COBOL!
-----Original Message-----
From: Sobocinski Ken
[mailto:db2udbdba-ezmlmshield-x73070711.[Email address protected]
Sent: Monday, September 26, 2005 9:52 AM
To: LazyDBA Discussion
Subject: RE: Writing db2 procedures in cobol
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