Re: File Info Data Structure contents

On 10/10/2017 3:26 PM, Peter Dow wrote:

Specifically what I'm looking for is a way to determine
if the file just opened is an SQL view, not a DDS logical
file. It turns out that the number of records on open
(pos.156-159 of the INFDS) is incorrect if the
SQL view was created with a WHERE clause.

I don't think that information is in the Open Feedback area. Perhaps
you could exchange the INFDS for a SELECT COUNT(*) INTO... for all file
types?


The following is how I came to that conclusion. Feel free to delete now.

I'm trying to find a description of the contents of the file information
data structure contents.

IBM's Knowledge Center helpfully tells me "A description of the contents
of the open feedback area, and what file types the fields are valid for,
can be found in the iSeries Information Center."

And the iSeries Information Center says its contents have been moved to
the Knowledge Center.

I'm guessing it's RPG you're looking for?
Programming > ILE languages > RPG > ILE RPG Reference > RPG IV Concepts

File and Program Exception/Errors > File Information Data Structure

https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/rzasd/filinda.htm

The Open Feedback does indeed tell me that the description is in the IBM
i Information Center. Pity there's no link; not even IBM can maintain
all those moving parts. Searching for 'Open Feedback' did return this
helpful link: 'Monitoring file status with the open and I/O feedback
area'
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/dm/rbal3openiofba.htm
Which has the link to the Open Feedback structure:
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/dm/rbal3feedb.htm
The path to that is Files and file systems > Database file management >
Reference > Feedback area layouts > Open feedback area

--buck