5 replies to this topic

[luwapula]

Hie guys

Here are the docfile and the report that is being produced. Wherever there is a figure like 999914729.89,9999......'00 that amount is above a billion and these are total amounts per counter clerk.

If I try to increase from s9.2 to any desirable size it does not want.

So pliz assist Iam a newbie in proiv and its version 4.00

DC @DOCFIL McDonnell Information Systems 27/04/06 15:07 PAGE 1
TRM: TTYP0 F I L E D O C U M E N T A T I O N OPR: DEV

CO- AUTO- ENFORCED EXTERNAL FILE KEY RECORD
DIV SEQ PAGING RECORD FORMAT TYPE LENGTH LENGTH
FILE NAME: ONFDETAL Y CISAM 20 109
ALTERNATE: ../y2k_cisam/onfdetal RECORD CODE:
DESC:

---------------------------R E C O R D L A Y O U T--------------------------------
DATA MAX FILL SPECIAL ARRAY
SEQ TYPE VARIABLE NAME LEN CODE DISPLAY-CODE CHECK SIZE
--- ---- -------------------------------- ---- --- ------------ -------- ----

001 K ON.OPR_ID 10
EXTERNAL TYPE ALPHA STORAGE FORMAT
002 K ON.DATE 10 DATE4 DATE4
EXTERNAL TYPE ALPHA STORAGE FORMAT
003 A ON.START_TIME 6
EXTERNAL TYPE ALPHA STORAGE FORMAT
004 A ON.END_TIME 6
EXTERNAL TYPE ALPHA STORAGE FORMAT
005 N ON.NOOFENTRIES 5 5.0
EXTERNAL TYPE C-FLT STORAGE FORMAT 5.0
006 N ON.NOOFENT_COR 5 5.0
EXTERNAL TYPE C-FLT STORAGE FORMAT 5.0
007 N ON.NOOFENT_DEL 5 5.0
EXTERNAL TYPE C-FLT STORAGE FORMAT 5.0
008 N ON.TOTAL_AMT 13 9.2-
EXTERNAL TYPE C-DEC STORAGE FORMAT S9.2
009 N ON.TOTAL_DEP_AMT 13 9.2-
EXTERNAL TYPE C-DEC STORAGE FORMAT S9.2
010 N ON.TOTAL_PAY_AMT 13 9.2-
EXTERNAL TYPE C-DEC STORAGE FORMAT S9.2
011 N ON.TOTAL_DEP_UNAC 13 9.2-
EXTERNAL TYPE C-DEC STORAGE FORMAT S9.2
012 N ON.TOT_PAY_UNAC_AMT 13 9.2-
EXTERNAL TYPE C-DEC STORAGE FORMAT S9.2
013 N ON.TOTAL_CASH_AMT 13 9.2-
EXTERNAL TYPE C-DEC STORAGE FORMAT S9.2
014 N ON.TOTAL_CHQ_AMT 13 9.2-
EXTERNAL TYPE C-DEC STORAGE FORMAT S9.2
015 A ON.START_RECPT 8
EXTERNAL TYPE ALPHA STORAGE FORMAT
016 A ON.END_RECPT 8
EXTERNAL TYPE ALPHA STORAGE FORMAT

DEFAULT HELP MESSAGE/DEFINITION
FLD MESSAGE TEXT
--- ---------------------------------------------------------------------------
001 Operator Indentity
002 Entry Date (Current Date)
003 Start Time
004 End Time
005 Total Number of Entries Entered
006 Total Number of Entries Corrected

MDC @DOCFIL McDonnell Information Systems 27/04/06 15:07 PAGE 2
TRM: TTYP0 F I L E D O C U M E N T A T I O N OPR: DEV

CO- AUTO- ENFORCED EXTERNAL FILE KEY RECORD
DIV SEQ PAGING RECORD FORMAT TYPE LENGTH LENGTH
FILE NAME: ONFDETAL Y CISAM 20 109
ALTERNATE: ../y2k_cisam/onfdetal RECORD CODE:
DESC:

---------------------------R E C O R D L A Y O U T--------------------------------
DATA MAX FILL SPECIAL ARRAY
SEQ TYPE VARIABLE NAME LEN CODE DISPLAY-CODE CHECK SIZE
--- ---- -------------------------------- ---- --- ------------ -------- ----

DEFAULT HELP MESSAGE/DEFINITION
FLD MESSAGE TEXT
--- ---------------------------------------------------------------------------
007 Total Number of Entries Deleted
008 Total Payments / Deposits Amount
009 Total Deposit Amount
010 Total Payment Amount
011 Total Unaccounted Deposit Amount
012 Total Unaccounted Payment Amount
013 Total Cash Amount
014 Total Cheque amount
015 Start Receipt Number
016 End Receipt Number

FILE CUSTOM ERROR MESSAGES
--------------------------
RECORD NOT IN FILE:
* ERROR MESSAGE NOT DEFINED *
RECORD ALREADY IN FILE:
* ERROR MESSAGE NOT DEFINED *
RECORD LOCKED - RETRYING:
* ERROR MESSAGE NOT DEFINED *
RECORD LOCKED - ABORT/RETRY:
* ERROR MESSAGE NOT DEFINED *

E N D O F D O C U M E N T A T I O N F O R F I L E ONFDETAL




Start End
Operator Date Time Entry Entry Amount Deposits Payments Cash Cheques Receipt Receipt
---------- ---------- -------- ----- ----- ------------- ------------- ------------- ------------- ------------- -------- ---------
CHIHUNGWAC 27/04/2006 07:53:16 170 610292072.48 610292072.48 196595000.00 413697072.4800086997
CHINGOMBEC 27/04/2006 07:45:12 161 999953550.38 250000.00 968277671.92 220148500.00 779805050.3800029017
CHINHURUC 27/04/2006 08:03:19 30 131749604.75 1500000.00 130249604.75 97173000.00 34576604.7500022882
CHITENGAC 27/04/2006 07:18:31 149 563435422.44 250000.00 560185422.44 171114550.00 392320872.4400015236
CHIWAWAC 27/04/2006 08:06:01 115 999999970.60 999999968.70 999999970.6000012276
DHAKWAC 27/04/2006 08:03:32 187 999986070.97 .50 991870745.41 109955500.00 890030570.9700037137
DUMBUC 27/04/2006 07:57:36 205 999970868.09 250000.00 992389779.25 146715500.00 853255368.0900070092
GWEDEC 27/04/2006 07:50:45 197 999997816.52 1750000.00 997997815.60 140461100.00 859536716.5200095462
HAPAGUTIC 27/04/2006 08:53:33 1 400000.00 400000.0000000021
KACHIDZAC 27/04/2006 08:09:28 68 136263012.22 136263012.22 85867000.00 50396012.2200043108
KAGURAC 27/04/2006 07:48:54 169 999994068.63 250000.00 999444068.63 187233500.00 812760568.6300072360
MAKADZANGC 27/04/2006 08:58:07 132 999914729.89 3250000.00 993664729.89 263701507.43 736213222.4600031229
MAKUBAZAC 27/04/2006 13:18:07 00001016
MANHAMOC 27/04/2006 07:48:49 176 999938190.74 998988190.74 999938190.7400004085
MARUVAC 27/04/2006 11:20:23 00005775

yours
BP Luwapula

[Chris Pepper]

I don't know if you are supporting a single customer site, or if you have a number of customers.

If you want to do this you need to understand a couple of things first:

1) You will need to create a completely new physical file.
2) You will need to create a conversion Function that will copy the existing data from the existing file to the new file. Each record on this file will be larger than the original file because the numbers will take more space.
3) Your system will need enough space to have both files present at the same time. The original file may be archived at the end of the procedure.
4) You will need to regen all the Functions that access this file. You'll also need to make any changes to the size of fields on the screen or in reports if these need to be bigger.
5) You will need to move all the Functions to the live system and import them.
6) You will need to run the Function to copy the data on the live system.
7) No users can be on the system when you are doing this.
8) If the system is installed on more than one site you will have to do this everywhere.
9) When you have regenned the Functions they will not work with the old file format. Any old runtime Functions will not work with the new format file.

Obviously if you get this wrong you could mess up the system! If you are happy with this I'll give you instructions on what will need to be changed.

[Bob Filipiak]

Adding to chris' post,

MAKE SURE YOU HAVE A GOOD BACKUP OF YOUR DATA

If you have the disk space available, then create a testing environment IDENTICAL to the one you have to modify, and make your changes in the TESTING environment. While logged in to that environment, perform the copy of the data using your 'expand' function.

TEST it some more, and test it again, because, brother if you do not have it right, there is no going back if you overwrite your live environment.

I speak from experience. (At the time a newbie)

Bob Filipiak

[andykay]

BP,

First off don't let this seem like a monumental task...it is not. It may seem like it if you've never done it, but Chris has layed out everything you'll need to do and I'm sure you'll do fine.

Just a note: If you are totally uncomfortable with doing this because you're a newbie, I would hand this off to a more senior programmer or at least have one looking over your shoulders while you do it. Because, to paraphase Bob, once the data is gone...there's no recovery without loss somewhere. Besides, if you do have a senior programmer watching over you and something does go wrong...well, call it job security.

Secondly, after reformatting your report to a more presentable format (see attached), I couldn't help but get the feeling that this file is used as a workfile for this report because of the high dollar amounts. At least I wouldn't want to do my banking at a bank that stores a Billion+ dollars worth of data on a single file . If this is the case, then it will be even simpler as most likely the table won't be used elsewhere. If it is just a workfile we're talking about here then you'd just have to see if any other functions/reports use that workfile, too, make the changes to the table, and then regen them all.

Thirdly, even if my second point is completely wrong, whatever you do...do this in DEV first, then if everything goes ok, have your supervisor run this in TEST and have him sign off on this and pass this off here. A newbie shouldn't be responsible for a file change in PROD.

Good Luck,

AK

Attached Files

•  Formatted_Report.doc   21KB   137 downloads

[Bob Filipiak]

AK,

I WISH I had someone looking "over my shoulder"!!!

What a mess that was.

Had I known THEN what I know now - the answer would have been a flat NO! - Get someone else.

BP,

I can not stress enough - leave yourself some fall back option. With the kind of figures you are talking about any kind of screw up would be a career killer.

Bob Filipiak

[luwapula]

Thanx guys

I have done all what Chris and Bob Filipiak and I have created a new physical file from my devepopment server and tested it and it seems it had worked.

Keep the fire burning guys.

Luwapula