RE: OPNQRYF on a SQL created file

Thanks for the verification.
I'll need to investigate it more. The program we're having an issue with is being set aside while we implement everything else for a file change. I'll take a look at it again in a bit and see what's going on. The only thing we noticed is that the OPNQRYF didn't seem to be doing its job, which was to provide sorting. Again, some old program where nothing really changed, so I was trying to identify what did change (how the file was created, and size of amount fields) so I was doing a quick grasp at straws.

-Kurt

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jeff Crosby
Sent: Tuesday, April 20, 2010 6:53 AM
To: Midrange Systems Technical Discussion
Subject: Re: OPNQRYF on a SQL created file

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.