MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » September 2014

Re: Embedded SQL question



fixed

On Wed, Sep 3, 2014 at 1:11 AM, Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx> wrote:
Even though a view (any view) can be specified within the F-speca and read
with the READ Op-Code, it must be considered a view does not (never?) have
key.

True. I should have mentioned that the SYSCOLUMNS logical file has no
key (i.e. access path is arrival sequence). I was trying to make it
sound approachable for folks who aren't yet comfortable with SQL. But
if you want to use it in an RPG program without touching any SQL, then
probably a familiar way for "traditionalists" is to do something like
OPNQRYF and OVRDBF in a CLP wrapper.

John Y.





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact