RE: [EXTERNAL] records between two dates

Without your code I cannot tell.
Something is not correct.



From: jerry ven <jerryven95@xxxxxxxxx>
Sent: Friday, July 1, 2022 3:00 PM
To: Therrien, Paul <ptherrien@xxxxxxxxxxx>
Cc: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: [EXTERNAL] records between two dates

Hi,

Ok, so if the record counts for (1. and 2. SQL Queries ( on file1) was too less than compared to record count for (3. and 4. (SQL queries for record count for view (V1) )
then is it fine or acceptable or is there any probability of Typos - bad field names, transposed characters here which might cause this imbalance in terms of record counts here?

I mean to ask, is it OK to say that a view can have more records compared to the file on which it is based ?

or conceptually it's wrong here? ( considering my SQL queries and Views for which I shared Queries in my last posts ( 1.,2.,3.,4.)

if it's right then I have equal records for my view and in the WRKQRY but if it's wrong then my view and WRKQRY has too many more records compared to the SQL queries ( on file1 SQL Queries 1. and 2.)


Thanks.





On Sat, 2 Jul 2022 at 00:05, Therrien, Paul <ptherrien@xxxxxxxxxxx<mailto:ptherrien@xxxxxxxxxxx>> wrote:
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<mailto:jerryven95@xxxxxxxxx>>
Sent: Friday, July 1, 2022 2:33 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,

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