Re: [EXTERNAL] records between two dates

"Main point -- Why the view which is created on a physical file(physical file which itself is created by joining two or more files like i shared in my last post with SQL queries examples) shows much more records than the file(file1 in my SQL queries examples 1.,2.,3,,4.)"

Doesn't matter how the PF was created. The consensus of those who have commented here is that:

1) SQL on a view created over a PF

and

2) SQL on the PF using the same criteria you used to create the view

should give the same results.

If not then you must have an error (maybe a typo) in the SQL creating the view or in the SQL using the view. But since you won't or can't show the code, then there is no help we can give.


On another front, I don't know how QRY/400 will treat a view as input, which is why I pointed you to the "Define result fields" approach for verification. if you are required to verify with QRY/400.


"Also how would IBM i ACS be superior to traditional STRSQL here , I mean what I can't do in STRSQL can do using IBM i ACS here?"

STRSQL is old and it is difficult to make changes to what you've keyed. And easy to pick the wrong SQL when you go back to the history. That's why I suggest you delete everything and start again.

With iACS you have the benefit of a GUI editor and is easier to change code, you can easily save and reload code to files on your PC or on the IBM i. It can have multiple panes open, each with a separate SQL statement. It can also reformat code. And it has a lot of examples. It leaves STRSQL in the dust.

But to each his own...


>On 7/4/2022 7:56 AM, jerry ven wrote:

Also how would IBM i ACS be superior to traditional STRSQL here , I mean
what I can't do in STRSQL can do using IBM i ACS here?



Main point -- Why the view which is created on a physical file( physical
file which itself is created by joining two or more files like i shared in
my last post with SQL queries examples) shows much more records than the
file(file1 in my SQL queries examples 1.,2.,3,,4.)

is there a difference in a Physical file which is traditionally created by