Thanks for the reply John
I haven't given up on SQL just yet
Just becoming exasperated because of what I don't know about SQL
Sent via the Samsung GALAXY S® 5, an AT&T 4G LTE smartphone
-------- Original message --------
From: John Yeung <gallium.arsenide@xxxxxxxxx>
Date: 9/23/20 00:23 (GMT-05:00)
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Cc: Alan Shore <ashore@xxxxxxxx>
Subject: Re: [EXTERNAL] Re: Need help on capturing data in a query
On Tue, Sep 22, 2020 at 5:37 PM Alan Shore via MIDRANGE-L
<midrange-l@xxxxxxxxxxxxxxxxxx> wrote:
Thanks for your reply Raul
Im beginning to think that you are right - RPG maybe the answer that I need for this next step
RPG is always *an* answer on the i, and usually a good one.
For something like this, Python is arguably even better because its
native data structures have variable size. You simply add more
elements to them as needed; you don't even declare a maximum size.
But, whether RPG or Python or some other language, the great thing
about doing SQL in a host language is that you don't have to contort
yourself into arbitrarily complex SQL statements. You can break down
difficult tasks into easier pieces, some of which are handled by
fairly simple SQL, some of which are handled by fairly simple
structures and logic in the host language.
John Y.
midrange.com
