Re: Stupid Database Tricks
Date: 20 Jun 2004 16:21:57 -0700
Message-ID: <18c7b3c2.0406201521.3ac8a66a_at_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 Mon Jun 21 2004 - 01:21:57 CEST