Re: Brainstorming

["franz400" <franz400@xxxxxxx>]

Thomas,

I think you would have to be much more precise in your description for us to
consider your issue.
The phrase "selected data does not appear as expected in a subfile 
program..."
what does this mean?
Some data appears, just not all    or
No data appears                        or
Corrupted data appears

How are you selecting data - RPGLE  read or chain. SQL,  JDBC, ODBC,
OLEDB, OPNQRYF, ???

Even though you brought the programs & data lib to your own system, there
are many environment differences that might account for this.
Are there files on their system, in their library list, that are not part of 
your
test environment?
Are their exceptions occurring that are covered up by monmsg or pssr
routines, or ignoring sql codes?
Depending upon OS and cume differences, there have been several  sql
updates by IBM that can change expected results (documented in places
like the V6R1 Memo to Users - to read before installing 6.1 (and there are
others, but we're just guessing here...
more details please
Jim Franz

----- Original Message ----- 
From: "Thomas Garvey" <tgarvey@xxxxxxxxxx>
To: "'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
Sent: Wednesday, June 05, 2013 3:28 PM
Subject: Brainstorming


> We have a program that is apparently failing at a user site, but not on 
> our
> test and development systems.  The nature of the failure is that selected
> data does not appear as expected in a subfile program.
>
> To test it we had the object library and data library from the user system
> saved and sent to our test system.  We restored the objects and tested the
> process here.  It works just fine.
>
> So, what could be different at the user site and our site that would 
> change
> whether records are displayed in a subfile?
>
> My first (and only) thought was in regards to authority to either the file
> and/or the program.  We've tried all the permutations we could think of
> (owner of program object, adopt authority yes/no, ownership and authority 
> to
> files, etc.) and it still works on our system.
>
> Any other ideas that would make something work on one system and not
> another?  Remember, both the program object and data files libraries from
> the user site were restored to the test system.
>
> Thanks for any advice.
>
> Tom Garvey
>
> --
> 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.