Re: The joy of FORTRAN

On Fri, 28 Feb 2025 01:19:38 -0500, c186282 wrote:

   I only used SQL to do the initial selection - and then more custom
   code to go through/organize that. Table-joins and the rest are just
   too evil. No "simple" once you get to that junk (and it's SLOW too).
   Dump the initial find to a file and use 'C' to go on from there.

We had a person who handcrafted a query using a wide range of DB2 scalar
functions. I have no idea how many hours it took and it kept growing. I
don't remember the DB2 version but it broke on some sites where the DB2
version had a 4k limit rather than the later 8k.

I knew what it was supposed to do but I didn't have a clue how it did it.
The idea was to provide configurable queries that a user could modify for
their needs but that one got handed down to generations of support people
untouched.  That was the case for a lot of the 'configurable' reports. It
would have been easier to hard code the reports.