Typos – bad field names, transposed characters.
Proof of concept? … everything you have written should work – so if it isn’t working then you have some bad code somewhere.
SQL works fine. QRY works fine.
From: jerry ven <jerryven95@xxxxxxxxx>
Sent: Friday, July 1, 2022 2:33 PM
To: Therrien, Paul <ptherrien@xxxxxxxxxxx>
Cc: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: [EXTERNAL] records between two dates
Hi,
But how would it make a difference? I just want to make a proof of concept for this. How does it matter whether the field name is field1 or 'x','y' 'z' etc.
Thanks
On Fri, 1 Jul 2022 at 23:56, Therrien, Paul <ptherrien@xxxxxxxxxxx<mailto:ptherrien@xxxxxxxxxxx>> wrote:
You need to share the actual code and the actual file layouts.
From: jerry ven <jerryven95@xxxxxxxxx<mailto:jerryven95@xxxxxxxxx>>
Sent: Friday, July 1, 2022 2:24 PM
To: Therrien, Paul <ptherrien@xxxxxxxxxxx<mailto:ptherrien@xxxxxxxxxxx>>
Cc: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>>
Subject: Re: [EXTERNAL] records between two dates
Hi,
I just changed field names and file name and library name here but on the actual file and field names when I replace these SQL queries with the actual file and field names then getting the same kind of results as I shared here.
Thanks.
filiate link:
https://amazon.midrange.com
As an Amazon Associate we earn from qualifying purchases.