Re: Problem with an SQL View that has selects/omits

James H. H. Lampert wrote:
> I'm guessing, from the lack of response to my question about
> resetting the error status without reopening the file, that I'm
> stuck with a reopen.

   Yep.  I was just slow to reply :-)

> Turned out that wasn't as painful as I'd feared (if anything,
> less painful than doing it in RPG!), and I've now got it working.
> For some reason, the total number of records isn't showing up,
> but I'm sure I can fix that.

   The open of a VIEW is a query for which a row count is not really 
established; for an *ALLIO implementation or implementation with a 
temporary file, the row count may be available.  Even with the DDS 
LF the count is not legitimate, as only reading every record and 
counting them can be trusted; i.e. rows may be added or deleted 
[without something like LOCK EXCLUSIVE preventing concurrent I\O].

Regards, Chuck
_______________________________________________
This is the MI Programming on the AS400 / iSeries (MI400) mailing list
To post a message email: MI400-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mi400
or email: MI400-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mi400.