RE: [SYSTEM21] V5R2

[Dan Thomas <dthomas@xxxxxxxxxxx>]

We are on v3.5.0 (heavily modified) and are going through a migration from a
620 v4r5 to an 810 v5r2.  We are in test mode at this time.  So far
everything is working fine (and very fast).  My understanding of the SQL
problem is that it will make affected programs run slower, but they will
still run.  I am not an RPG techie, but I believe programs with embedded SQL
code are identified as SQLRPG instead of just RPG.  Shouldn't be that hard
to find affected programs and make the change...assuming of course you have
source code.  A consulting firm quoted us two weeks to handle this for us,
and we may still use them, but two weeks did seem high to me.

We'll share with the group what we find and hope everyone else will do that
same.

Dan Thomas
Director of Information Technology
MDI
4500 Progress Blvd
Louisville, KY  40218
(502) 318-1208

This message is a privileged and confidential communication protected by the
Electronic Communications Act and is intended for the designated recipients
only.  Duplication or distribution of this email beyond the intended
recipients without prior written consent of the sender is strictly
prohibited.


-----Original Message-----
From: Prill, Steve [mailto:sprill@xxxxxxxxxxxxx]
Sent: Tuesday, September 23, 2003 8:43 AM
To: System 21 Users
Subject: FW: [SYSTEM21] V5R2


Kevin,

I don't believe anyone provided any details on what exactly needed to be
changed if someone wants to move to OS400 V5R2 from a system 21 version
prior to SP4.

Ram and I are both interested in getting this information.  I submitted this
to Answerlink yesterday and if I get any details I will provide it to this
group.

Below is the response from Teri Willoughby.

Steve


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