Re: File Info Data Structure contents

[Peter Dow <petercdow@xxxxxxxxx>]

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.




On 10/10/2017 12:33 PM, Justin Taylor wrote:
> If you're talking RPG, it's in the "Programming IBM Rational Development Studio for ILE RPG Reference".
>
>
>
> -----Original Message-----
> From: Peter Dow [mailto:petercdow@xxxxxxxxx]
> Sent: Tuesday, October 10, 2017 2:27 PM
> To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> Subject: File Info Data Structure contents
>
> 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.
>
> 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.
>
> --
> *Peter Dow* /
> Dow Software Services, Inc.
> 909 793-9050
> petercdow@xxxxxxxxx <mailto:petercdow@xxxxxxxxx>
> pdow@xxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxx> /