|
We are at 3.5.2B SP2 and plan to upgrade our AS/400 from V5R1 to V5R2 later this year. Is the SQL issue the only problem when moving to V5R2? Does anyone have a list of the programs that need the SQL statements changed? Does Geac have any documentation on this? Thanks, Steve Prill I.S. Project Manager Rexair, Inc. 3221 W. Big Beaver Rd. Suite 200 Troy, MI 48084 248-816-8686 x166 fax 248-614-0335 mail to: sprill@xxxxxxxxxxxxx -----Original Message----- From: Eva SooHoo [mailto:EvaS@xxxxxxxxxxxxx] Sent: Sunday, August 31, 2003 11:02 AM To: 'System 21 Users' Subject: RE: [SYSTEM21] V5R2 I recently heard that there have been less than one dozen programs found with this problem. Several of them in a 'banking' module and one or two in the manufacturing module. So what you are suggesting ma not be too simplistic. Although the info was too late for us, I hope it helps others. -----Original Message----- From: Brunk, Kevin [mailto:KBrunk@xxxxxxxxxxxx] Sent: Wednesday, August 27, 2003 9:13 AM To: System 21 Users Subject: RE: [SYSTEM21] V5R2 Maybe this is too simplistic, but couldn't a user who has source go find these programs and repair them by adding the "FOR UPDATE OF", recompile the program, and now be able to upgrade? -----Original Message----- From: Eva SooHoo [mailto:EvaS@xxxxxxxxxxxxx] Sent: Wednesday, August 27, 2003 11:59 AM To: 'System 21 Users' Subject: RE: [SYSTEM21] V5R2 This is the answer supplied to me by Teri Willoughby. (via my support liaison) The customer must be at v3.5.2 SP4 before moving to V5R2. There are issues with some SQL statements prior to SP4. When an SQL cursor is open for update, some of the previous versions of programs have left off the "FOR UPDATE OF". This causes problems with V5R2 as IBM is more stringent with SQL now. -----Original Message----- From: Glenn Schreiner [mailto:Gschrein@xxxxxxxx] Sent: Tuesday, August 26, 2003 7:56 AM To: 'system21@xxxxxxxxxxxx' Subject: [SYSTEM21] V5R2 We are currently running System 21 version 3.5.0 on V5R1, but will be upgrading to V5R2 very soon. Is anyone currently running System 21 version 3.5.0 on V5R2? If so, did you have any problems when you upgraded to V5R2? Thanks for the help. Glenn R. Schreiner Hach Company Sr. Programmer Analyst Email: gschrein@xxxxxxxx Phone: (970) 663-1377, ext. 2509 Fax: (970) 669-2932 _______________________________________________ This is the System 21 Users (SYSTEM21) mailing list To post a message email: SYSTEM21@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/system21 or email: SYSTEM21-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/system21. _______________________________________________ This is the System 21 Users (SYSTEM21) mailing list To post a message email: SYSTEM21@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/system21 or email: SYSTEM21-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/system21. ********************************************************************** CONFIDENTIALITY NOTICE: The information transmitted in this message is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and destroy all copies of this document. Thank you. The Butler Company ********************************************************************** _______________________________________________ This is the System 21 Users (SYSTEM21) mailing list To post a message email: SYSTEM21@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/system21 or email: SYSTEM21-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/system21. _______________________________________________ This is the System 21 Users (SYSTEM21) mailing list To post a message email: SYSTEM21@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/system21 or email: SYSTEM21-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/system21.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
