Re: OPNQRYF on a SQL created file

[Jeff Crosby <jlcrosby@xxxxxxxxxxxxxxxx>]

Ditto to what Scott said.  I'm on V6R1, but it also worked fine on V5R4.


On Tue, Apr 20, 2010 at 12:17 AM, Scott Klement
<midrange-l@xxxxxxxxxxxxxxxx> wrote:
> Hi Kurt,
>
> I use OPNQRYF with files that were created from SQL... haven't had
> problems.  Of course, I haven't tried using OPNQRYF with any files that
> have "SQL-only" features like LOBs, so I don't know about that..?
>
> What problem are you having?
>
> Kurt Anderson wrote:
> > Should this work ok?
> >
> > I'm asking because we changed a file to be created via SQL vs DDS and a program that runs after an OPNQRYF is acting like the OPNQRYF isn't working.  Although there is no message telling us it's not working.  And a quick browse of IBM's info on OPNQRYF didn't tell me it wouldn't work.  Of course searching on OPNQRYF and SQL is giving me a lot of "replace OPNQRYF with..."
> >
> > Thoughts?
> >
> > At v5r4.
> >
> > Thanks,
> >
> > Kurt Anderson
> > Sr. Programmer/Analyst
> > CustomCall Data Systems
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.