ODBC PTF Defect

["Jeffrey M. Carey" <jeffreycarey@xxxxxxx>]

We recently came across a problem with the ODBC PTF's on both V3R2 and
V3R7 (presumably on V3R1 as well, but haven't tested that).
In V3R2, PTF SF38338 (on cume 7126) and its superceed SF41227 cause this
problem with ODBC - when trying to update an AS/400 table, the operation
will fail unless the logical over the file has a UNIQUE key. 
Previously, we could update with a non-unique key (which should be the
case, as AS/400 SQL allows updates top tables with non-unique keys).  
We found the same problem on our V3R7 system (which is at cume 7161),
but not on our V3R1 system (which is still back at 7044).  
To get around this until a fix is developed, we had to remove SF41227
(note that removing SF38338 wasn't enough - we removed that, then
applied SF41227 and a few other PTF's IBM recommended, then removed
SF41227).
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *