Re: [EXTERNAL] records between two dates

Since you are getting different numbers you've got to do some debugging.

Maybe qry400 and sql handle bad data differently? Is all data in the 4 fields definitely valid decimal data?

You may also want to compare record by record the results of using the view vs using the file.

You are sure that the view is built over the correct physical file in the right library ? And it's not a logical?

And to repeat what others have said, without seeing actual code and results, we're kind of stuck.


On 7/1/2022 2:59 PM, jerry ven wrote:

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> 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>
*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> wrote:

You need to share the actual code and the actual file layouts.





*From:* jerry ven <jerryven95@xxxxxxxxx>
*Sent:* Friday, July 1, 2022 2:24 PM
*To:* Therrien, Paul <ptherrien@xxxxxxxxxxx>
*Cc:* Midrange Systems Technical Discussion <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