× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



"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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.