1 / 14

Chapter 17 Sequential File Maintenance

Chapter 17 Sequential File Maintenance. OLD MASTER. TRANSACTION. NEW MASTER. UPDATE PROGRAM. ERROR MESSAGES. Figure 17.1 Sequential Update. Figure 17.2 Sequential Update with Data Files. OLD MASTER FILE:

risa-arnold
Télécharger la présentation

Chapter 17 Sequential File Maintenance

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Chapter 17 Sequential File Maintenance

  2. OLD MASTER TRANSACTION NEWMASTER UPDATEPROGRAM ERRORMESSAGES Figure 17.1 Sequential Update

  3. Figure 17.2 Sequential Update with Data Files OLD MASTER FILE: 111111111ADAMS 015000 NEW YORK222222222BAKER 025000 NEW YORK333333333ZIDROW 008000 NEW YORK444444444MILGROM 040000 BOSTON555555555BENJAMIN 100000 CHICAGO666666666SHERRY 007500 CHICAGO777777777BOROW 017500 BOSTON888888888JAMES 050000 NEW YORK 999999999RENAZEV 030000 NEW YORK NEW MASTER FILE: 111111111ADAMS 015000 NEW YORK222222222BAKER 028000 BOSTON 333333333ZIDROW 008000 NEW YORK400000000NEW EMPLOYEE 016000 BOSTON 444444444MILGROM 040000 BOSTON 555555555BENJAMIN 100000 CHICAGO 610000000NEW EMPLOYEE II 018000 NEW YORK777777777BOROW 055000 NEW YORK888888888JAMES 050000 NEW YORK999999999RENAZEV 030000 NEW YORK SEQUENTIALUPDATE TRANSACTION FILE: 222222222 028000 C222222222 BOSTON C400000000NEW EMPLOYEE 016000 BOSTON A500000000 020000 C610000000NEW EMPLOYEE II 018000 CHICAGO A610000000 NEW YORK C 666666666SHERRY D777777777 055000 C888888888JAMES 017500 NEW YORK A ERROR MESSAGES: NO MATCH 500000000 DUPLICATE ADDITION 888888888

  4. MASTERAS OF 1/1 JANUARYTRANSACTIONS MASTERAS OF 2/1 MASTERAS OF 3/1 FEBRUARYTRANSACTIONS Figure 17.3 Two-period Sequential Update UPDATEPROGRAM UPDATEPROGRAM Processing done March 1 Processing done February 1

  5. TRANSACTIONFILE OLD MASTER NEW MASTER VALIDTRANSACTIONS STEP 1: EDIT STEP 2: UPDATE ERRORMESSAGES ERRORMESSAGES Figure 17.4 Sequential Update with Data Validation

  6. Figure 17.5 Valid Transaction File 000000000BOROW JSATL07 A000000000BOROW JS 10000C000000000BOROW JS 20000C100000000GRABER P 30000222222222NEW GUY RT A333333333ESMAN TNNY 09 A400000000MOLDOF BLATL15 A444444444RICHARDS IM 05000C555555555JORDAN BOS07 A700000000MILGROM A D666666666JOHNSON M NYC12 A800000000VASQUEZ C 55000C800000000VASQUEZ C C999999999GILLENSON MANYC10 A (a) Transaction File

  7. Figure 17.5 (continued) INVALID TRANSACTION CODE 100000000GRABER P 30000MISSING LOCATION CODE 222222222NEW GUY RT AMISSING OR NON-NUMERIC COMMISSION RATE 222222222NEW GUY RT A INVALID LOCATION CODE 333333333ESMAN TNNY 09 AMISSING NAME OR INITIALS 555555555JORDAN BOS07 ASOCIAL SECURITY NUMBER OUT OF SEQUENCE 666666666JOHNSON M NYC12 AMISSING OR NON-NUMERIC SALES AMOUNT 800000000VASQUEZ C C (b) Error Messages 000000000BOROW JSATL07 A000000000BOROW JS 10000C000000000BOROW JS 20000C400000000MOLDOF BLATL15 A444444444RICHARDS IM 05000C 700000000MILGROM A D 800000000VASQUEZ C 55000C 999999999GILLENSON MANYC10 A (c) Valid Transaction File

  8. Figure 17.6 Hierarchy Chart for Data Validation Program

  9. Open filesDO while data remains READ transaction file AT END Indicate no more data NOT AT END Move ‘YES’ to valid-record-switch IF trans-social-security < previous-social-security Move ‘NO’ to valid-record-switch Write error message ENDIF Move trans-social-security to previous-social-security IF transaction-code is not valid Move ‘NO’ to valid-record-switch Write error message ENDIF IF addition IF transactions fails addition-check(s) Move ‘NO’ to valid-record-switch Write error message(s) ENDIF ELSE IF correction IF sales-amount not numeric Move ‘NO’ to valid-record-switch Write error message ENDIF ENDIF ENDIF IF valid-record-switch = ‘YES’ Write valid-transaction-record ENDIF ENDREADENDDOClose filesStop run Figure 17.7 Pseudocode for Data Validation Program

  10. Figure 17.9 Test Data 100000000GRABER P ATL1500000000200000000RUBIN MABOS0800020000300000000ANDERSON IRBOS1000113000400000000MOLDOF BLATL1500000000500000000GLASSMAN JSNYC1000045000600000000GRAUER RTNYC0800087500700000000MILGROM A SF 0900120000 800000000VASQUEZ C ATL1200060000900000000CLARK E NYC0700002500 (a) Old Master 000000000BOROW JSATL07 A000000000BOROW JS 10000C000000000BOROW JS 20000C400000000MOLDOF BLATL15 A444444444RICHARDS IM 05000C 700000000MILGROM A D 800000000VASQUEZ C 55000C 999999999GILLENSON MANYC10 A (b) Valid Transaction File (Output of Edit Program)

  11. Figure 17.10 Balance Line Algorithm Open filesRead transaction-file, at end move high-values to transaction-keyRead old-master-file, at end move high-values to old-master-keyChoose first active-keyDO WHILE active-key not equal high-values IF old-master-key = active-key Move old-master-record to new-master-record Read old-master-file, at end move high-values to old-master-key ENDIF DO WHILE transaction-key = active-key Apply transaction to new-master-record Read transaction-file, at end move high-values to transaction-key ENDDO IF no deletion was processed Write new-master-record ENDIF Choose next active-keyENDDOClose filesStop run

  12. UPDATE MASTERFILE READ TRANSACTIONFILE READ OLD-MASTER FILE CHOOSE ACTIVE KEY PROCESS ACTIVE KEY BUILD NEW MASTER APPLY TRANSTO MASTER CHOOSE ACTIVE KEY WRITE NEW MASTER READ OLD-MASTER FILE ADD NEW RECORD CORRECT EXISTING RECORD DELETE EXISTING RECORD READ TRANSACTION FILE Figure 17.12 Hierarchy Chart for Sequential Update

  13. Figure 17.14 Truncated Output of Stubs Program RECORDS BEING PROCESSED TRANSACTION SOC SEC #: 000000000 OLD MASTER SOC SEC #: 100000000 ACTIVE KEY: 000000000 0070-APPLY-TRANS-TO-MASTER ENTERED TRANSACTION CODE: A0090-ADD-NEW-RECORD ENTERED 0070-APPLY-TRANS-TO-MASTER ENTERED TRANSACTION CODE: C0100-CORRECT-EXISTING-RECORD ENTERED 0070-APPLY-TRANS-TO-MASTER ENTERED TRANSACTION CODE: C0100-CORRECT-EXISTING-RECORD ENTERED 0080-WRITE-NEW-MASTER ENTERED RECORDS BEING PROCESSED TRANSACTION SOC SEC #: 400000000 OLD MASTER SOC SEC #: 100000000 ACTIVE KEY: 100000000 0060-BUILD-NEW-MASTER ENTERED0080-WRITE-NEW-MASTER ENTERED . . . RECORDS BEING PROCESSED TRANSACTION SOC SEC #: 400000000 OLD MASTER SOC SEC #: 300000000 ACTIVE KEY: 300000000 0060-BUILD-NEW-MASTER ENTERED0080-WRITE-NEW-MASTER ENTERED RECORDS BEING PROCESSED TRANSACTION SOC SEC #: 400000000 OLD MASTER SOC SEC #: 400000000 ACTIVE KEY: 400000000 0060-BUILD-NEW-MASTER ENTERED0070-APPLY-TRANS-TO-MASTER ENTERED TRANSACTION CODE: A0090-ADD-NEW-RECORD ENTERED ERROR- DUPLICATE ADDITION: 400000000080-WRITE-NEW-MASTER ENTERED. . . RECORDS BEING PROCESSED TRANSACTION SOC SEC #: 400000000 OLD MASTER SOC SEC #: 400000000 ACTIVE KEY: 400000000 0070-APPLY-TRANS-TO-MASTER ENTERED TRANSACTION CODE: A0090-ADD-NEW-RECORD ENTERED0080-WRITE-NEW-MASTER ENTERED

  14. Figure 17.16 Output of the Sequential Update 100000000GRABER P ATL1500000000200000000RUBIN MABOS0800020000300000000ANDERSON IRBOS1000113000400000000MOLDOF BLATL1500000000500000000GLASSMAN JSNYC1000045000600000000GRAUER RTNYC0800087500700000000MILGROM A SF 0900120000 800000000VASQUEZ C ATL1200060000900000000CLARK E NYC0700002500 (a) Old Master 000000000BOROW JSATL07 A000000000BOROW JS 10000C000000000BOROW JS 20000C400000000MOLDOF BLATL15 A444444444RICHARDS IM 05000C 700000000MILGROM A D 800000000VASQUEZ C 55000C 999999999GILLENSON MANYC10 A (b) Valid Transaction File 000000000BOROW JSATL0700030000100000000GRABER P ATL1500000000200000000RUBIN MABOS0800020000300000000ANDERSON IRBOS1000113000400000000MOLDOF BLATL1500000000500000000GLASSMAN JSNYC1000045000600000000GRAUER RTNYC0800087500 800000000VASQUEZ C ATL1200060000900000000CLARK E NYC0700002500999999999GILLENSON MANYC1000000000 (c) New Master ERROR-DUPLICATE ADDITION: 400000000ERROR-NO MATCHING RECORD: 444444444 (d) Error Messages

More Related