Re: File Info Data Structure contents

[Peter Dow <petercdow@xxxxxxxxx>]

Yes, and in that manual it says

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

The example

DCL-DS OPNFBK;
 ODP_TYPE CHAR(2) POS(81); // ODP Type
 FILE_NAME CHAR(10) POS(83); // File name
 LIBRARY CHAR(10) POS(93); // Library name
 SPOOL_FILE CHAR(10) POS(103); // Spool file name
 SPOOL_LIB CHAR(10) POS(113); // Spool file lib
 SPOOL_NUM_OLD INT(5) POS(123); // Spool file num
 RCD_LEN INT(5) POS(125); // Max record len
 KEY_LEN INT(5) POS(127); // Max key len
 MEMBER CHAR(10) POS(129); // Member name
 TYPE INT(5) POS(147); // File type
 ROWS INT(5) POS(152); // Num PRT/DSP rows
 COLUMNS INT(5) POS(154); // Num PRT/DSP cols
 NUM_RCDS INT(10) POS(156); // Num of records
 SPOOL_NUM INT(10) POS(160); // 6 digit Spool Nbr
 ACC_TYPE CHAR(2) POS(160); // Access type
 DUP_KEY CHAR(1) POS(162); // Duplicate key?
 SRC_FILE CHAR(1) POS(163); // Source file?
 VOL_OFF INT(5) POS(184); // Vol label offset
 BLK_RCDS INT(5) POS(186); // Max rcds in blk
 OVERFLOW INT(5) POS(188); // Overflow line
 BLK_INCR INT(5) POS(190); // Blk increment
 FLAGS1 CHAR(1) POS(196); // Misc flags
 REQUESTER CHAR(10) POS(197); // Requester name
 OPEN_COUNT INT(5) POS(207); // Open count
 BASED_MBRS INT(5) POS(211); // Num based mbrs
 FLAGS2 CHAR(1) POS(213); // Misc flags
 OPEN_ID CHAR(2) POS(214); // Open identifier
 RCDFMT_LEN INT(5) POS(216); // Max rcd fmt len
 CCSID INT(5) POS(218); // Database CCSID
 FLAGS3 CHAR(1) POS(220); // Misc flags
 NUM_DEVS INT(5) POS(227); // Num devs defined
END-DS;

has field NUM_RCDS which is the one that gives incorrect information for 
a view.

And there are 3 "Misc flags" fields. I'd like to know if the contents of 
one of those will tell me if it's a view, a DDS logical, or a physical.



On 10/10/2017 1:01 PM, Justin Taylor wrote:
> 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.