y2k code conversion tools
angela
Does anyone have any experience with or feedback on AS/400 code
conversion tools for Y2K? I have 200,000 lines of RPG38 and CL38 code
that is pretty straight forward, but I am hesitant to do the work
manually. In addition to the obvious century deadline, I have a baby
due in 2 months. Do these tools really do the job? Are they
reliable? Are they worth their HIGH ticket prices?
Thanks for your feedback.
Angela
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Tom Kennedy
I'm sorry, but this is going to be a very pessimistic reply. The date of
your post is 2nd September 1999 - you're at least a year late sending
this. You just don't have enough time to do this work before the
millennium rollover. I'm assuming that your AS/400 system is a "typical"
one, involving date storage in physical files in six-digit fields;
employing date arithmetic in your programs; using transaction files keyed
by date; and perhaps involving purging of data older than a given duration
etc.
I was involved with a major Y2k project, which took many man years (IT and
end user) to complete. Before we started, we evaluated several Y2k code
conversion tools. The leading ones are pretty similar - you tell them
which database fields are date fields (they'll make an educated guess for
you based on field name, text, size and contents) and they will then track
these fields throughout your programs, and will automate much of the
actual code conversion process for you - but this is the tip of the
iceberg in a Y2k project.
Firstly, they probably won't convert all of your code correctly. You will
have to step through each change and verify it. This takes time and is,
frankly, drudgery. No-one likes this job.
Secondly, testing the changed programs will be the real killer. In
addition to unit testing of converted programs, you will be planning and
executing a complete end-to-end test of your entire system. You will
probably need to use a separate AS/400 so you can play with the system
date. You may need to test data exchanges with other computers. You will
need to use tools to age your data to the date boundaries to be tested.
These tools are sometimes integrated with the code conversion software,
but may need to be evaluated and purchased separately. Depending on your
situation, they may or may not be ideal. You may need to age certain data
so that it always falls on a working day, for example. On the human front,
you will have limited time to develop a test plan which will involve your
end users in verifying and accepting the compliant system.
Thirdly, implementation is no easy feat. You must ensure that database
conversion and program installation go hand-in-hand. You will need to
ensure, perhaps, that Query/400 applications have been converted to use
the new file layouts. If users extract AS/400 data into spreadsheets then
these extract processes will need to be checked.
Finally, given your personal situation, you are not physically going to be
able to commit yourself 100% to this project.
Here's a quick run-through your critical path, based on extremely
optimistic timings. You didn't say how many programs were involved. So
I'll assume 200,000 lines of code = 400 programs.
And I'll assume there are no Query/400 objects, no external data exchanges
and no interfaces to Excel spreadsheets etc to worry about.
Two weeks to select, purchase, install and learn to use your code
conversion tool. (Mid-September)
Four weeks to convert and unit test 400 programs (Mid-October)
Six weeks to execute an integration test involving end users, including
database load/conversion/ageing (End-November)
One week to plan and execute go-live (End 1st week December)
Now this is *extremely* optimistic; assumes that you have up-to-date
source code for all of your programs; assumes that testing goes well; and
leaves no room for contingency. Throwing people at the problem will not
work - it will just make the project more complex to manage. Depending on
how your system has been written, you may already have started to
experience Y2k-related problems by start December. How will you manage to
deal with these?
You can always save time by neglecting to test - and I believe many
businesses are doing this. I wouldn't recommend it. You place your entire
organization at risk.
Frankly, I don't think you have enough time - you need to get radical. The
first thing you should do is to alert your senior managers to the
seriousness of the situation. You will then need to draw up a contingency
plan - and at this stage, it will most probably consist of a set of manual
procedures to run your business until you buy a replacement package or fix
your current systems.
If you do manage to fix your systems in time, then you should post again
to this newsgroup explaining how you did it. I'd be delighted, for your
sake, to admit I was wrong!
Regards,
Tom Kennedy
--
Walter
anyway. Tell your boss to stop dreaming and to prepare for working without
these programs for at least a year.
The only hope is that you find an existing standard software that fits your
needs.
Walter
Nick Roux
ready in two months.
In your situation I would get and external company to start the
conversion a.s.a.p.
This will cost a bit more than you might expect.
They will probably not be able to get it Y2K ready before Jan 1.
With the convestion off your shoulders you will then have time to
apply your knowledge of your business systems to ensure that the
disaster recovery and contingency plans are up to date and
feasible...you are most likely going to need them four months from
now.
Nick
On Thu, 02 Sep 1999 14:49:33 GMT, angela <ahgorm...@my-deja.com>
wrote:
>Greetings!
>
>Does anyone have any experience with or feedback on AS/400 code
>conversion tools for Y2K? I have 200,000 lines of RPG38 and CL38 code
>that is pretty straight forward, but I am hesitant to do the work
>manually. In addition to the obvious century deadline, I have a baby
>due in 2 months. Do these tools really do the job? Are they
>reliable? Are they worth their HIGH ticket prices?
>
>Thanks for your feedback.
>
>Angela
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
---------------------------------
mailto:Nick...@Bigfoot.Com
http://www.bigfoot.com/~nick.roux
./spam>/dev/null
---------------------------------
lars....@swipnet.se
This can't be true, I mean start an Y2K project in September 1999, what
kind of business are you in if you are not already using 2000-based dates
??
If you are not joking, give me a mail and I will arrange for 40 of my
collegues to come coding 4 U at some very nice rates . . .
angela skrev:
bob lukomski
which did a good job of both highlighting dates and adding code to expand
the data and window back the dates as 6. They have a Web site at
INTO2000.com. You better start right away you are running behind. If you
have any questions E-mail me back.
Bob Lukomski
LUCOM Technologies
Tom Kennedy
- each time without reply. Has she resigned her position? Or is she a time
waster?
Her only other post to this newsgroup referred to *PGM objects as 'files'
which does make me wonder:
> This is a true beginner's question. I am slowly learning the AS/40 system -
without
> any documentation.
>
> I have been assigned the task of cleaning up the system and archiving unused
files.
> With *files things have been fine. But, I have no idea how to move or
remove
> *pgm files. The libraries, files, folders menu doesn't handle *pgm.
"angela", if you read this, please reply to acknowledge.
Tom Kennedy
--
Tom Kennedy wrote:
> <snip wordy reply>
Peter R Rowley
As a general rule I tend to ignore email addresses from my-deja, yahoo
and all the other freebies. I don't consider them 'serious' email
addresses that would be used in the line of normal business.
Peter
--------------------------
In article <37DA183C...@dial.pipex.com>,
--
Peter R Rowley
Navan (UK) Limited
angela
where it was sent, but I did not recieve the messages. I guess I also
need to apologize for not knowing the lingo associated with the
AS/400. In general, replies to my deja queries have been incredibly
helpful in obtaining useful information.
You can e-mail me at ahgo...@hotmail.com or at dpgo...@att.net.
Thanks.
Angela
angela
actually work there). They are researching standard software as we
"speak".
In article <7qoccs$io$3...@euler.space.net>,
"Walter" <10045...@compuserve.com> wrote:
> >Do these tools really do the job?
> No. They help you doing the job. But it's impossible to do it in time
> anyway. Tell your boss to stop dreaming and to prepare for working
without
> these programs for at least a year.
> The only hope is that you find an existing standard software that
fits your
> needs.
>
> Walter
>
>
angela
feedback (and others) to the company.
Angela
In article <37d7c1d5...@news.icon.co.za>,
Nick...@Bigfoot.Com wrote:
> I'll try and be optimistic here: You are not going to get that box Y2K
> ready in two months.
>
> In your situation I would get and external company to start the
> conversion a.s.a.p.
> This will cost a bit more than you might expect.
> They will probably not be able to get it Y2K ready before Jan 1.
>
> With the convestion off your shoulders you will then have time to
> apply your knowledge of your business systems to ensure that the
> disaster recovery and contingency plans are up to date and
> feasible...you are most likely going to need them four months from
> now.
>
> Nick
>
> On Thu, 02 Sep 1999 14:49:33 GMT, angela <ahgorm...@my-deja.com>
> wrote:
>
> >Greetings!
> >
> >Does anyone have any experience with or feedback on AS/400 code
> >conversion tools for Y2K? I have 200,000 lines of RPG38 and CL38
code
> >that is pretty straight forward, but I am hesitant to do the work
> >manually. In addition to the obvious century deadline, I have a baby
> >due in 2 months. Do these tools really do the job? Are they
> >reliable? Are they worth their HIGH ticket prices?
> >
> >Thanks for your feedback.
> >
> >Angela
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Share what you know. Learn what you don't.
>
> ---------------------------------
> mailto:Nick...@Bigfoot.Com
> http://www.bigfoot.com/~nick.roux
>
> ./spam>/dev/null
> ---------------------------------
>
angela
that has a very desperate accounting department at the moment. From
many conversations around the small to mid-size manufacturing world,
they are not alone.
I realize there is no silver bullet, but am looking for realistic ways
to help this company while I can.
They have had Y2K problems already and I have been able to help them
with temporary fixes, but they now believe it's time to tackle the
job. I was just hoping someone had some experience with highend
conversion tools and could give some feedback. One reply mentioned
Into2000 - a highly regarded tool and we are currently trying to apply
it.
Angela
In article <37D03783...@swipnet.se>,
lars, rydell wrote:
> Clearly this has to be a joke right ??????
>
> This can't be true, I mean start an Y2K project in September 1999,
what
> kind of business are you in if you are not already using 2000-based
dates
> ??
>
> If you are not joking, give me a mail and I will arrange for 40 of my
> collegues to come coding 4 U at some very nice rates . . .
>
> angela skrev:
>
Tom Kennedy
> Hi Tom. Sorry for my failure to respond to your e-mail. I'm not sure
> where it was sent, but I did not recieve the messages. I guess I also
> need to apologize for not knowing the lingo associated with the
> AS/400. In general, replies to my deja queries have been incredibly
> helpful in obtaining useful information.
>
> You can e-mail me at ahgo...@hotmail.com or at dpgo...@att.net.
> Thanks.
>
> Angela
Thanks, Angela. My original E-Mail is on its way to your hotmail address.
Roger Williams
Can someone please list the steps to follow to manually ftp
to an NT server and then how do I this automatically.
/------------------------------------------------------------------\
| Roger Williams | Phone : 610-581-7691 |
| Dimensional Insight, Inc. | Fax : 610-581-7694 |
| 771 East Lancaster Avenue | E-Mail : ro...@dimins.com |
| Villanova, PA 19085-1519 | URL : http://www.dimins.com |
\------------------------------------------------------------------/
Roger Williams
Client Access Data Transfer. When I save the .tto file and
tried to transfer using the following command :
c:\>rtopcb test.tto
I received an Access Denied message. What am I being denied
access to and how do I correct this?
fau...@wanadoo.fr
1/manualy
- cfgtcp, option 10, if you want put MYNTSRV in the host list
- FTP MYNYSRV
now FTP "session" is open on your NT SERVER, (FTP SERVICE has to bee active
on NT SERVER)
you can use FTP subcommand
2/ automatic
- cfgtcp ...
- create a source file (why not QFTPSRC)
- create a member in this file (FTPSRC001 ?); in this member, include FTP
subcommands you need
- OVRDBF INPUT QFTPSRC MEMBER(FTPSRC001)
FTP MYNTSVR
subcommand in FTPSRC001 member are running
best regards
--
-- -- -- -- -- -- -- -- -- -- -- -- -- --
Frederic Faure
ETAPES informatique
67 AV DE VERDUN
F77470 TRILPORT
Roger Williams a écrit dans le message <37DD0F...@dimins.com>...
>I am an AS/400 novice.
>
>Can someone please list the steps to follow to manually ftp
>to an NT server and then how do I this automatically.
>
>
Anthony Hunter
> I have successfully transferred data from the AS/400 to PC using
> Client Access Data Transfer. When I save the .tto file and
> tried to transfer using the following command :
>
> c:\>rtopcb test.tto
>
> I received an Access Denied message. What am I being denied
> access to and how do I correct this?
There may be Read-Only rights to the files that the tto is using. Go
to the directory where the tto file is and do a:
attrib -r *.*
this should remove the readonly flags and you should be able to run the
transfers.
Tony Hunter
Per
Is assume that you already have the FTP-deamon running on
the NT:
The following command will start a FTP-session with your NT.
ftp NThost
where NThost is either the IP-address or the domain name.
Domain name will work if you have configured on the AS/400
already as mentioned in an earlier post or if you have a
DNS connected to you AS/400.
Running it automatically:
In the AS/400 world often referred to as "running FTP in
batch"
I'm currently trying to compile a FAQ for FTP on the AS/400
and below is the
"FTP in Batch":
YOURLIB/FTPSCRIPTS is a AS/400 sourcefile i.e. created with
CRTSRCPF
Enter the ftp commands in member Script in file
YOURLIB/FTPSCRIPTS using SEU or equivalent.
Add a member FTPLOG to YOURLIB/FTPSCRIPTS
Pgm
ClrPfm File(YOURLIB/FTPSCRIPTS) Mbr(FTPLOG)
OvrDbf INPUT ToFile(YOURLIB/FTPSCRIPTS) Mbr(SCRIPT)
OvrDbf OUTPUT ToFile(YOURLIB/FTPSCRIPTS) Mbr(FTPLOG)
Ftp TargetSystem
DltOvr INPUT
/* The Logfile could now optionally be parsed in a program
*/
DltOvr OUTPUT
EndPgm
It is vital to use the names INPUT and OUTPUT which is the
only names AS/400 FTP will react on. This is pretty much
like stdin and stdout as it is known in the dos/unix world.
Checkout the IBM-reference material on this:
http://publib.boulder.ibm.com/cgi-
bin/bookmgr/BOOKS/QB3ANL03/7.11.4
HTH
Per Nielsen
* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!