Path: ...!news.mixmin.net!news.swapon.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: rbowman <bowman@montana.com>
Newsgroups: comp.os.linux.misc
Subject: Re: The joy of FORTRAN
Date: 28 Feb 2025 07:56:27 GMT
Lines: 17
Message-ID: <m2d8haFnv00U2@mid.individual.net>
References: <5mqdnZuGq4lgwm_7nZ2dnZfqnPSdnZ2d@earthlink.com>
	<vd6vto$r0so$1@dont-email.me> <iJEJO.198176$kxD8.81657@fx11.iad>
	<3hOdnWpQ649QMGr7nZ2dnZfqnPidnZ2d@earthlink.com>
	<vd8doi$15q07$1@dont-email.me> <vd8eg7$15v1j$2@dont-email.me>
	<cxicnVzg_cn_eGX7nZ2dnZfqnPadnZ2d@earthlink.com>
	<vdapbn$1kp35$5@dont-email.me> <lltpunF4fseU2@mid.individual.net>
	<1smdnSjX3YoxgWf7nZ2dnZfqn_idnZ2d@earthlink.com>
	<llv30aFa6uvU3@mid.individual.net> <vde4b8$268qv$22@dont-email.me>
	<1396870532.749421730.052473.peter_flass-yahoo.com@news.eternal-september.org>
	<wrapper-20241001111737@ram.dialup.fu-berlin.de>
	<vpl5uk$hhk$3@reader1.panix.com>
	<c4acndn4jJXKwCP6nZ2dnZfqnPSdnZ2d@giganews.com>
	<1214951717.762291306.657281.peter_flass-yahoo.com@news.eternal-september.org>
	<gIUvP.1415795$21T3.138928@fx18.iad> <vpp6b0$31cet$2@dont-email.me>
	<5DWdnXyIYo7er136nZ2dnZfqnPednZ2d@giganews.com>
	<vppkbv$33b82$6@dont-email.me> <vpqm2d$39d65$1@dont-email.me>
	<-ducnbYn4JrmyFz6nZ2dnZfqn_idnZ2d@giganews.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
X-Trace: individual.net Erf3f51X3BjDrpicUYUFaA9dTnyOtqMsC5Wzbhp0RnbQ4JWbwb
Cancel-Lock: sha1:1x/xeynG09LL1tPnet70O79qeyM= sha256:Xgg1of4kRS6NmYNbxJrMJHhcooiSKCDvzsy1nkceI+o=
User-Agent: Pan/0.160 (Toresk; )
Bytes: 2630

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.