Re: File Info Data Structure contents -- MIDRANGE-L

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.