Re: DSPFD and the QDBRTVFD API

["Carsten Flensburg" <flensburg@xxxxxxxxxx>]

Hello Nelson,

- From somewhere else: The QUSRMBRD (Retreive Member Description) API has a
return format named MBRD0300 at the end of which you will find the "Record
format and based-on file list" array (as well as the "Constraint indexes
information" array).

The "Record format and based-on file list" contains an 4-byte signed integer
at decimal offset giving you the current number of records - if less than
2147483647 records. Larger counts are returned at decimal offset 96 in an
4-byte unsigned integer.

Here's the manual's description of "Current number of records":

The number of records that currently exist in this member.
A keyed logical file member returns the number of index entries.
A nonkeyed logical file member returns the number of records in the based-on
physical file member.
If the requested physical file member is suspended, the value 0 is returned.

I have an old RPG/IV example of the QUSRMBRD API and it's various return
formats. Let me know if you want a copy.

Best regards,
Carsten Flensburg

----- Original Message ----- 
From: "Nelson Smith" <ncsmith@xxxxxxxxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Friday, January 20, 2006 3:16 AM
Subject: Re: DSPFD and the QDBRTVFD API


> I have used the QDBRTVFD API to get (programatically) most of the data
> that is presented in the DSPFD screens.  However, there is one field I
> have just not been able to find in the API (not the easiest thing to
> wade through).  That is the field shown under the BASED ON section when
> the file in question is a logical.  In addition to the based on
> physical, library, and format name, it also shows the field "Number of
> Index Entries".  When the logical has Select/Omit criteria, the number
> is a subset of the number of records in the physical file.
>
> Does anyone know where this field is located in the formats in the
> QDBRTVFD API or is it coming from somewhere else?