× 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.



https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_72/rzasd/sc092508.pdf


-----Original Message-----
From: Peter Dow [mailto:petercdow@xxxxxxxxx]
Sent: Tuesday, October 10, 2017 2:46 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: File Info Data Structure contents

Hi Justin,

Yes, that's what I'm talking about. Do you have a link for that? I googled for it and found:

https://www.ibm.com/support/knowledgecenter/SS4QVT_8.5.1/com.ibm.etools.iseries.langref.doc/evfrilsh138.htm#opfeed

which says

"A description of the contents of the open feedback area, and what file types the fields are valid for, can be found in theiSeries Information Center."


Some additional information for those who are interested, I have an SQL view that joins 2 files and has a WHERE clause.

DSPFD shows it as having the number of records in the secondary join file.

SQL statement SELECT count(*) FROM lib/file shows the correct number of records.

My program's file INFDS open count shows the number of records from the primary join file.

I'm looking for a way to get the SQL count without having change the program to SQLRPGLE and run an SQL statement just to find the number of records in the file.





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.