Cut-over

In the Middle of an ERP System Implementation Cutover 

Twas the night before cutover,
And all through the house,
Not a program was working,
Not even a browse.

Consultants were wrung out,
Too mindless to care,
Knowing chances of cutover
Hadn't a prayer.

The users were nestled
All snug in their beds,
While visions of inquiries
Danced in their heads.

When out in the lobby
There arose such a clatter,
That I sprang from my tube
To see what was the matter.

And what to my wondering
Eyes should appear,
But a Super Programmer,
Oblivious to fear.

More rapid than eagles,
His programs they came
And he whistled and shouted
And called them by name.

On Update! On Add!
On Inquiry! On Delete!
On Batch Jobs! On Closing!
On Functions Complete!

His eyes were glazed over,
His fingers were lean,
>From weekends and nights
Spent in front of a screen.

A wink of his eye,
And a twist of his head,
Soon gave me to know
We had nothing to dread.

He spoke not a word,
But went straight to his work,
Turning specs into code,
Then he turned with a jerk.

And laying his fingers
Upon the ENTER key,
The system came up,
And worked perfectly!

The updates updated;
The deletes they deleted;
The inquiries inquired;
And the closing completed.

He tested each whistle,
He tested each bell,
With nary an abend,
And all had gone well.

The system was finished,
The tests were concluded,
The client's last changes
Were even included!

And the client exclaimed,
With a snarl and a taunt,
"It's just what I asked for,
But it's not what I want!" 


Michael Ala
EDI Service Line Leader
BP Lubricants USA Inc.
Phone: (973) 633-2353  Fax: (973) 686-4053


-----Original Message-----
From: rpg400-l-bounces+michael.ala=bp.com@xxxxxxxxxxxx
[mailto:rpg400-l-bounces+michael.ala=bp.com@xxxxxxxxxxxx] On Behalf Of
rpg400-l-request@xxxxxxxxxxxx
Sent: Thursday, December 22, 2005 4:58 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: RPG400-L Digest, Vol 4, Issue 1465

Send RPG400-L mailing list submissions to
        rpg400-l@xxxxxxxxxxxx

To subscribe or unsubscribe via the World Wide Web, visit
        http://lists.midrange.com/mailman/listinfo/rpg400-l
or, via email, send a message with subject or body 'help' to
        rpg400-l-request@xxxxxxxxxxxx

You can reach the person managing the list at
        rpg400-l-owner@xxxxxxxxxxxx

When replying, please edit your Subject line so it is more specific than
"Re: Contents of RPG400-L digest..."


*** NOTE: When replying to this digest message, PLEASE remove all text
unrelated to your reply and change the subject line so it is meaningful.

Today's Topics:

   1. Re: Opnqryf (Dave Reiher/prairiefarms)
   2. Re: Opnqryf (steema@xxxxxxxxxxxxx)
   3. Re: Opnqryf (David Gibbs)
   4. Re: Opnqryf (steema@xxxxxxxxxxxxx)
   5. RE: Opnqryf (Matt.Haas@xxxxxxxxxxx)
   6. RE: Opnqryf (steema@xxxxxxxxxxxxx)
   7. Re: Opnqryf (SASchollenberger@xxxxxxxxxxxx)
   8. RE: Opnqryf (steema@xxxxxxxxxxxxx)


----------------------------------------------------------------------

message: 1
date: Thu, 22 Dec 2005 15:08:25 -0600
from: Dave Reiher/prairiefarms <DReiher@xxxxxxxxxxxxxxxx>
subject: Re: Opnqryf

I'll go along with Scott.
I just checked one of mine. I am doing OVRDBF SHARE(*YES) and in my
OPNQRYF doing KEYFLD(FILE/DATEFLD) and it appears to be working.

    Dave Reiher
    System Analyst
    Prairie Farms Dairy - Corporate
    dreiher@xxxxxxxxxxxxxxxx



SASchollenberger@xxxxxxxxxxxx
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
12/22/2005 03:19 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
cc

Subject
Re: Opnqryf






Did you do an OVRDBF SHARE(*YES) before the OPNQRYF command?
If not, the RPG (assuming here) program creates its own ODP rather than
using the one created
by OPNQRYF which applied your new ordering by date.
----------------------
Scott

Scott A. Schollenberger
Chief Technology Officer
TENEX Systems, Inc.
2011 Renaissance Blvd., Suite 100
King of Prussia, PA  19406
Phone: 610-239-9988  Ext. 305
Fax: 610-239-9995
E-mail: saschollenberger@xxxxxxxxxxxx
Web: www.tenexsys.com

IBM Certified Specialist - eServer i5 iSeries Technical Solutions
Implementer V5R3

CONFIDENTIALITY NOTICE:  This email message, including any attachments,
is
for the sole use of the intended recipient(s) and contains confidential 
and
privileged information.  Any unauthorized review, use, disclosure or
distribution is prohibited.  If you are not the intended recipient,
please
contact the sender by reply email and destroy all copies of the original
message.

----------------------
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."    --Benjamin Franklin
----------------------


 
             steema@diskhaven. 
             com 
             Sent by:
To 

             rpg400-l-bounces@         "RPG programming on the AS400 / 
             midrange.com              iSeries" <rpg400-l@xxxxxxxxxxxx> 
 
cc 

 
             12/22/2005 03:46
Subject 

             PM                        Opnqryf 
 
 
             Please respond to 
              RPG programming 
              on the AS400 / 
                  iSeries 
             <rpg400-l@midrang 
                  e.com> 
 
 




HI I Have a file that is sorted by invoice number. The requirements for
the reprt are to list details by year. Yet the date is not part of the
key.
I tried an OPNQRYF using the date as the key, but this was ignored.

Did I do this wrong, or is there no way to do this w/out creating
another
logical?

Thanks,
Steve
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.