1. Static versus dynamic SQL was OO and IBM z series COBOL was Discussions of COBOL philospphy
On Wed, 10 Oct 2007 16:35:49 -0600, "Frank Swarbrick" < XXXX@XXXXX.COM > wrote: >>>> On 10/9/2007 at 6:41 PM, in message >< XXXX@XXXXX.COM >, LX-i< XXXX@XXXXX.COM > >wrote: >> Frank Swarbrick wrote: >>> Neither is DB2 (EXEC SQL) supported inside of Cobol classes either. >>> Sheesh! >> >> Do they have other database access classes? I don't think I'd *want* to >> do EXEC SQL in a class unless I just had to... :) > >I don't know. I guess since they support instantiating Java objects from >within COBOL you could use JDBC. > >I don't understand the reasoning behind your second statement, though. It >seems to me (without having actual tried it!) that it would be desirable to >have a database access class containing EXEC SQL statements. That is if >you're stuck using static SQL, which I know Pete always comes out against. >(I don't have enough experience to have an opinion on that matter). Back in the 1998 - 1999 timeframe I was on a Year 2000 project. The client decided to move their ledger and other accounting to Oracle Financials on AIX boxes. Another group was working on that and an outsourcing company was involved. There were sever performance problems and when the consultants attached to the Year 2000 project investigated, they found dynamic SQL was being used. Switching to static SQL apparently got rid of much of the performance problem. Since this is second hand from one of those involved, I am sketchy on the detail but I suspect it may in part have to do with bind and parsing overhead. Those who are really into data base probably can explain the trade-offs and technical issues far better than I can. > >Assuming that you were working with mainframe COBOL and you, for whatever >reason, are not using JDBC for database access, what type of OO methodology >and database access would you use? I assume (perhaps erroneously!) that >coding EXEC SQL statements in the main body of each program is not the best >OO way to go. Then again, perhaps it is? > >Frank
2. OO and IBM z series COBOL was Discussions of COBOLphilospphy
3. IBM, OO COBOL and related IBM products(was: Reasonably priced COBOL products
4. IBM, OO COBOL and related IBM products (was: Reasonably priced COBOL products
5. TYPEDEF - Micro Focus and Starndard (was: Discussions of COBOL philospphy
Just wanted to point out (confirming somewhat what is below) that Micro Focus is QUITE clear that there definition of "TYPEDEF" is an extension and does NOT conform to the ISO 2002 Standard definition of such. (They don't even have a TYPE clause as specified in the '02 Standard). P.S. "Reading" the LRM of the compiler that you ARE using seems a good idea to me (and also one that I don't think has ever been very common). I do know of people who STILL make their livings training COBOL programmers in "new features" available in specific implementations. However, I would also agree that most shops to actively promote this and few programmers try and pursue it. -- Bill Klein wmklein <at> ix.netcom.com "Richard" < XXXX@XXXXX.COM > wrote in message news: XXXX@XXXXX.COM ... > On Sep 10, 1:42 pm, "Pete Dashwood" > < XXXX@XXXXX.COM > wrote: >> "Richard" < XXXX@XXXXX.COM > wrote in message >> >> news: XXXX@XXXXX.COM ... >> >> > On Sep 10, 6:01 am, Robert < XXXX@XXXXX.COM > wrote: >> >> >> Here's an example. I worked at a place where database types were >> >> abstracted into include >> >> files. For C programs, the include file contained typedefs; for Cobol >> >> programs, there was >> >> a copybook for each element containing only a picture e.g. pic x(10). >> >> This created >> >> thousands of copybooks. When asked why they didn't use typedefs for >> >> Cobol, they said there >> >> is no such thing, they'd never seen a typedef in a Cobol program. >> >> >> Sure, they could have read the Standard or compiler manual. They didn't. >> >> Their knowledge >> >> of Cobol capability was based on reading Old Style programs. They didn't >> >> need training in >> >> how to use typedef, they were already doing it in C. >> >> > You show your ignorance of the Cobol Standard once again. Typedef was >> > a MicroFocus extension until the 2002 standard and there are no 2002 >> > standard compilers. >> >> Not just a MicroFocus extension. Fujitsu NetCOBOL also implements TYPEDEF. >> (Maybe others do too?) I think Robert's ignorance of the standard can be >> forgiven in this instance; most programmers assume that what is in the >> manual they use daily, is in the COBOL standard, and really don't care >> whether it is or not. > > If it is MicroFocus then his ignorance cannot be 'forgiven'. The MF > manuals are quite explicit about what is in the standard and what is > an extension. All extensions are boxed and marked as to what set of > extensions it belongs to. In the case of TYPEDEF it is marked with > "MF". > > Fujitsu may well have copied some MicroFocus extensions. > >
6. RW error (was: Discussions of COBOL philospphy
7. Discussions of COBOL philospphy
Just wanted to say that this group has had a number of threads on
GO TO
versus
Perform
Of paragraphs (sections - another philosophical thread) that contain STOP RUN
(GOBACK, etc) - or "ABEND" routines - or EXEC CICS XCTL, etc.
I believe (but could be mistaken) that all (or close to all) programs that use
PERFORM for such paragraphs (sections) understand that control never comes
back - and that "GO TO" would do the same thing. However, I have (again
personally) never heard of a program "failing" - either in initial design or
maintenance because PERFORM was used instead of GO TO (or even "inline" code).
We can talk about this, but I can't imagine any individual programmer will
change their mind - or that any shop will change its internal standard on such.
--
Bill Klein
wmklein <at> ix.netcom.com
8. TYPEDEFs and Fujitsu (was: Discussions of COBOL philospphy