RE: QDBRTVFD API

["Smith, Mike" <Mike_Smith@xxxxxxxxxxxxxxxx>]

Booth,
I am not using 'F' specs  The file is being used in an embedded SQL
application
Yeh, i know i can do a 'COUNT' in an sql statement, and it may be fine(just
not sure).  But i'm trying to take into account that i may have very large
files.  Not sure if there is a performance issue if i do 'select count(*)
from filea into :size'

-----Original Message-----
From: Booth Martin [mailto:booth@MartinVT.com]
Sent: Friday, February 08, 2002 1:55 PM
To: rpg400-l@midrange.com
Subject: Re: QDBRTVFD API


--
--
[ Picked text/plain from multipart/alternative ]
I keep seeing these sorts of questions where people want to use an API to
get information.  Yet the information seems to be pretty generally available
without an API.  What is it I am not understanding about the problem?


       * INFDS for database file. FileSize will contain the number
       * of records in the file when the file is opened.
      DINFDS            DS
      D FILESIZE              156    159B 0



--------------------------------------------
Booth Martin
MartinB@Goddard.edu
802-454-8315 x235
--------------------------------------------
-------Original Message-------

From: rpg400-l@midrange.com
Date: Friday, February 08, 2002 01:41:50 PM
To: 'RPG400-L@midrange.com'
Subject: QDBRTVFD API

Does anyone have an example of using this api, they would be willing to
share?
I need to determine the number of records in a file.

Thanks

Mike
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.


.
--
[ Content of type unknown/unknown deleted ]
--

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.