Re: Corrupted SQL View

"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 05/03/2016
11:11:42 AM:

What release of the OS?
There was a PTF for 6.1 in which... oh you can read it here
http://www-912.ibm.com/a_dir/as4ptf.NSF/

b3cb9d42f672b70f86256739004afa0f/13bc165631ca9774862573f7000bad26?OpenDocument

We are at v7r1 plus several TR's.

Did you do a recent run and have the same message before you recreated

it?

Basically what I am asking is perhaps it wasn't the function that

changed

but maybe the data being processed by it?

The programmers ran into the problem on the 28th and I was able to
reproduce the problem yesterday and then today just before I finally
recreated the SQL view today. I spent the better part of yesterday going
over the data thinking that was the issue -- like you -- but I could not
find any bad data nor could I get it to fail using iNav with native SQL
statements that did not reference the view itself.

Sincerely,

Dave Clark
int.ext: 91078
direct: (937) 531-6378
home: (937) 751-3300

Winsupply Group Services
3110 Kettering Boulevard
Dayton, Ohio 45439 USA
(937) 294-5331



*********************************************************************************************
This email message and any attachments is for use only by the named
addressee(s) and may contain confidential, privileged and/or proprietary
information. If you have received this message in error, please
immediately notify the sender and delete and destroy the message and all
copies. All unauthorized direct or indirect use or disclosure of this
message is strictly prohibited. No right to confidentiality or privilege
is waived or lost by any error in transmission.
*********************************************************************************************