Re: Stupid Database Tricks

From: --CELKO-- <jcelko212_at_earthlink.net>
Date: 20 Jun 2004 16:21:57 -0700
Message-ID: <18c7b3c2.0406201521.3ac8a66a@posting.google.com>

>> Less than two years ago, I was working for a major Dutch company.
There was only one way allowed to access the DB2 tables: through an interface module that read one row at a time and returned the results to the calling application. Updates had to be done row-by-row as well, through another
interface module. Joins were definitely not allowed!!! <<

Could have been worse; could have been one module for select, insert, update and delete on a row-by-row basis :) I wish I was joking about that.

The "Godzilla Module" had a flag as to what it was supposed to do. The update part of the code was done with a combination of insert and positioned delete statements and not even a positioned update statement. Well, how would you do it in COBOL?

Does anyone have a bottle of virtual Scotch? Single malt, until I cannot tell the difference, please. Received on Sun Jun 20 2004 - 18:21:57 CDT