× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



I would be grateful if some one can help us also on this. We are at V351 and
I need the list of programs that need to be looked at. 
Thanks in advance 


Ram S. Hari
Information Services
Wasserstrom  
ramhari@xxxxxxxxxxxxxxx
Voice 614.737.8542


 -----Original Message-----
From:   Prill, Steve [mailto:sprill@xxxxxxxxxxxxx] 
Sent:   Wednesday, September 03, 2003 9:41 AM
To:     System 21 Users
Subject:        RE: [SYSTEM21]   V5R2

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.
_______________________________________________
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 thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.