练习题
- 在2006年1月1日之前入职且在职的营销员,给予年资补贴2000元;
- 符合以上条件的,再按以下标准一次性发放职级补贴:
职级代码 |
简称 |
补偿金额 |
A1 |
AD |
6000 |
B1 |
SBM |
5000 |
C1 |
BM |
4000 |
其他职级 |
2000 |
要求:
新增一FILE记录此类奖金的发放明细,要求记录公司号、分支号、营销员代码、职级、年资补贴金额、职级补贴金额,新增一COBOL程序完成奖金计算,然后新建Schedule执行批处理,要求可以重复执行Batch;
备注:
营销员的基础信息为AA01PF,请找出其最合适的LF来使用;
字段说明:公司号COMPANY、分支BRANCH、营销员代码AGNTNUM、营销员职级DUTYDEG、入职日期DTEAPP、离职日期DTETRM(等于99999999为在职)、渠道COMTYPE(AG为营销员);
主要程序段
DELETE逻辑
5000-DEL-TIM5 SECTION.
*
5010-START.
*
INITIALIZE TIM5-PARAMS. MOVE TIM5REC TO TIM5-FORMAT.
MOVE BEGNH TO TIM5-FUNCTION.
*
5020-READ.
*
CALL 'TIM5IO' USING TIM5-PARAMS. IF TIM5-STATUZ NOT = O-K AND ENDP
MOVE TIM5-STATUZ TO SYSR-STATUZ
MOVE TIM5-PARAMS TO SYSR-PARAMS
PERFORM 600-FATAL-ERROR
END-IF. IF TIM5-STATUZ = ENDP
GO TO 5090-EXIT
END-IF. MOVE DELET TO TIM5-FUNCTION.
CALL 'TIM5IO' USING TIM5-PARAMS. IF TIM5-STATUZ NOT = O-K
MOVE TIM5-STATUZ TO SYSR-STATUZ
MOVE TIM5-PARAMS TO SYSR-PARAMS
PERFORM 600-FATAL-ERROR
END-IF. *
5080-NEXTR.
MOVE NEXTR TO TIM5-FUNCTION.
GO TO 5020-READ.
*
5090-EXIT.
EXIT.
/
INSERT逻辑
7000-INSERT-TIM5 SECTION.
*
7010-START.
*
MOVE AA01-COMPANY TO TIM5-COMPANY.
MOVE AA01-BRANCH TO TIM5-BRANCH.
MOVE AA01-AGNTNUM TO TIM5-AGNTNUM.
MOVE AA01-DUTY-DEG TO TIM5-DUTY-DEG.
MOVE WSAA-PAYBYYEAR TO TIM5-PAYBYYEAR.
MOVE WSAA-PAYBYDUTY TO TIM5-PAYBYDUTY. MOVE TIM5REC TO TIM5-FORMAT.
MOVE WRITR TO TIM5-FUNCTION. CALL 'TIM5IO' USING TIM5-PARAMS. IF TIM5-STATUZ NOT = O-K
MOVE TIM5-STATUZ TO SYSR-STATUZ
MOVE TIM5-PARAMS TO SYSR-PARAMS
PERFORM 600-FATAL-ERROR
END-IF. 7090-EXIT.
EXIT.
/
主要的读操作
Columns . . . : 1 71 Edit Pending . . . . . : CC
SEU==>
FMT CB ......-A+++B+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 0301.00 6000-READ-AA01 SECTION.
0302.00 *
0303.00 6010-START.
0304.00 *
0305.00 INITIALIZE AA01-PARAMS.
0306.00
0307.00 MOVE AA01REC TO AA01-FORMAT.
0308.00 MOVE BEGN TO AA01-FUNCTION.
0309.00 *
0310.00 6020-READ.
0311.00 *
0312.00 CALL 'AA01IO' USING AA01-PARAMS.
0313.00
0314.00 IF AA01-STATUZ NOT = O-K AND ENDP
0315.00 MOVE AA01-STATUZ TO SYSR-STATUZ
0316.00 MOVE AA01-PARAMS TO SYSR-PARAMS
0317.00 PERFORM 600-FATAL-ERROR
0318.00 END-IF.
0319.00
0320.00 IF AA01-STATUZ = ENDP
0321.00 GO TO 6090-EXIT
0322.00 END-IF.
0323.00
0324.00 IF AA01-COM-TYPE = 'AG'
0325.00 AND AA01-DTETRM = 99999999
0326.00 AND AA01-DTEAPP < 20060000
0327.00
0328.00 MOVE 2000 TO WSAA-PAYBYYEAR
0329.00 EVALUATE AA01-DUTY-DEG
0330.00 WHEN 'A1'
0331.00 MOVE 6000 TO WSAA-PAYBYDUTY
0332.00 WHEN 'B1'
0333.00 MOVE 5000 TO WSAA-PAYBYDUTY
0334.00 WHEN 'C1'
0335.00 MOVE 4000 TO WSAA-PAYBYDUTY
0336.00 WHEN OTHER
0337.00 MOVE 2000 TO WSAA-PAYBYDUTY
0338.00 END-EVALUATE
0338.01 PERFORM 7000-INSERT-TIM5
0339.00 END-IF.
0340.00
0341.00 IF AA01-STATUZ NOT = O-K
0342.00 MOVE AA01-STATUZ TO SYSR-STATUZ
0343.00 MOVE AA01-PARAMS TO SYSR-PARAMS
0344.00 PERFORM 600-FATAL-ERROR
0345.00 END-IF.
0347.00 *
0348.00 6080-NEXTR.
0349.00 MOVE NEXTR TO AA01-FUNCTION.
0350.00 GO TO 6020-READ.
0351.00 6090-EXIT.
0352.00 EXIT.
0353.00 /
完整的按照Smart/400 规范写的代码:
select count(*) from CL4DEVDTA.TIM5Pf
Columns . . . : 1 71 Browse CL4DEVSRC/QLBLSRC
SEU==> TIM07
FMT CB ......-A+++B+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
*************** Beginning of data *************************************
0001.00 IDENTIFICATION DIVISION.
0002.00 PROGRAM-ID. TIM07.
0003.00 *
0004.00 *(C) Copyright CSC Corporation Limited 1986 - 2000.
0005.00 * All rights reserved. CSC Confidential.
0006.00 *
0007.00 *REMARKS.
0008.00 * This is a skeleton for a batch mainline program.
0056.00 **DD/MM/YY*******************************************************
0057.00 *
0058.00 ENVIRONMENT DIVISION.
0059.00 CONFIGURATION SECTION.
0060.00 SOURCE-COMPUTER. IBM-AS400.
0061.00 OBJECT-COMPUTER. IBM-AS400.
0062.00 *
0063.00 INPUT-OUTPUT SECTION.
0064.00 FILE-CONTROL.
0065.00 /
0066.00 DATA DIVISION.
0067.00 FILE SECTION.
0068.00 /
0069.00 WORKING-STORAGE SECTION.
0070.00 *
0071.00 01 WSAA-PROG PIC X(05) VALUE 'TIM07'.
0072.00 01 WSAA-VERSION PIC X(02) VALUE '01'.
0073.00 *
0074.00 * These fields are required by MAINB processing and should not
0075.00 * be deleted.
0076.00 *
0077.00 01 WSAA-COMMIT-CNT PIC S9(08) COMP-3.
0078.00 01 WSAA-CYCLE-CNT PIC S9(08) COMP-3.
0079.00 01 WSAA-CNT PIC 9(02).
0080.00 01 WSSP-EDTERROR PIC X(04).
0081.00 01 WSAA-PAYBYYEAR PIC 9(04).
0082.00 01 WSAA-PAYBYDUTY PIC 9(04).
0083.00 *
0084.00 ****************************************************************
0085.00 *
0086.00 * The formats BUPA BSSC BPRD BSPR and BMSG are required by MAINB
0087.00 * processing and should not be deleted.
0088.00 *
0089.00 01 FORMATS.
0090.00 03 BMSGREC PIC X(10) VALUE 'BMSGREC'.
0091.00 03 BPRDREC PIC X(10) VALUE 'BPRDREC'.
0092.00 03 BSPRREC PIC X(10) VALUE 'BSPRREC'.
0093.00 03 BSSCREC PIC X(10) VALUE 'BSSCREC'.
0094.00 03 BUPAREC PIC X(10) VALUE 'BUPAREC'.
0095.00 03 DESCREC PIC X(10) VALUE 'DESCREC'.
0096.00 03 AA01REC PIC X(10) VALUE 'AA01REC'.
0097.00 03 TIM5REC PIC X(10) VALUE 'TIM5REC'.
0098.00 *
0099.00 01 TABLES.
0100.00 03 T1692 PIC X(06) VALUE 'T1692'.
0101.00 03 T1693 PIC X(06) VALUE 'T1693'.
0102.00 03 T3629 PIC X(06) VALUE 'T3629'.
0103.00 *
0104.00 01 CONTROL-TOTALS.
0105.00 03 CT01 PIC 9(02) VALUE 01.
0106.00 *
0107.00 01 WSAA-OVERFLOW PIC X(01) VALUE 'Y'.
0108.00 88 NEW-PAGE-REQ VALUE 'Y'.
0109.00 *
0110.00 01 WSAA-EOF PIC X(01) VALUE 'N'.
0111.00 88 END-OF-FILE VALUE 'Y'.
0112.00 *
0113.00 01 INDIC-AREA.
0114.00 03 INDIC-TABLE OCCURS 99 PIC 1 INDICATOR 1.
0115.00 88 IND-OFF VALUE B'0'.
0116.00 88 IND-ON VALUE B'1'.
0117.00 *
0118.00 * Main, standard page headings
0119.00 *
0120.00 * Detail line - add as many detail and total lines as required.
0121.00 * - use redefines to save WS space where applicable.
0122.00 *
0123.00 /
0124.00 COPY BATCDORREC.
0125.00 /
0126.00 COPY BATCUPREC.
0127.00 /
0128.00 COPY BSSCSKM.
0129.00 /
0130.00 COPY BSPRSKM.
0131.00 /
0132.00 COPY BUPASKM.
0133.00 /
0134.00 COPY BPRDSKM.
0135.00 /
0136.00 COPY CONLOGREC.
0137.00 /
0138.00 COPY CONTOTREC.
0139.00 /
0140.00 COPY DATCON1REC.
0141.00 /
0142.00 COPY DESCSKM.
0143.00 /
0144.00 COPY SFTLOCKREC.
0145.00 /
0146.00 COPY SYSERRREC.
0147.00 /
0148.00 COPY VARCOM.
0149.00 COPY AA01SKM.
0150.00 COPY TIM5SKM.
0151.00 /
0152.00 *
0153.00 LINKAGE SECTION.
0154.00 *****************
0155.00 *
0156.00 01 LSAA-STATUZ PIC X(04).
0157.00 01 LSAA-BSSCREC PIC X(1024).
0158.00 01 LSAA-BSPRREC PIC X(1024).
0159.00 01 LSAA-BPRDREC PIC X(1024).
0160.00 01 LSAA-BUPAREC PIC X(1024).
0161.00 /
0162.00 PROCEDURE DIVISION USING LSAA-STATUZ
0163.00 LSAA-BSSCREC
0164.00 LSAA-BSPRREC
0165.00 LSAA-BPRDREC
0166.00 LSAA-BUPAREC.
0167.00 *
0168.00 COPY MAINB.
0169.00 /
0170.00 0900-RESTART SECTION.
0171.00 **********************
0172.00 *
0173.00 0910-RESTART.
0174.00 *
0175.00 * Place any additional restart processing in here.
0176.00 *
0177.00 0990-EXIT.
0178.00 EXIT.
0179.00 /
0180.00 1000-INITIALISE SECTION.
0181.00 *************************
0182.00 *
0183.00 1010-INITIALISE.
0184.00 *
0185.00 PERFORM 5000-DEL-TIM5.
0186.00 *
0187.00 *
0188.00 INITIALIZE AA01-PARAMS.
0189.00
0190.00 MOVE AA01REC TO AA01-FORMAT.
0191.00 MOVE BEGN TO AA01-FUNCTION.
0192.00 *
0193.00 1090-EXIT.
0194.00 EXIT.
0195.00 /
0196.00 2000-READ-FILE SECTION.
0197.00 ************************
0198.00 *
0199.00 2010-READ-FILE.
0200.00 *
0201.00 * Call the I/O module or do a Standard COBOL read on
0202.00 * the primary file.
0203.00 *
0204.00 IF WSAA-EOF = 'Y'
0205.00 MOVE ENDP TO WSSP-EDTERROR
0206.00 END-IF.
0207.00 *
0208.00 MOVE O-K TO WSSP-EDTERROR.
0209.00 CALL 'AA01IO' USING AA01-PARAMS.
0210.00
0211.00 IF AA01-STATUZ NOT = O-K AND ENDP
0212.00 MOVE AA01-STATUZ TO SYSR-STATUZ
0213.00 MOVE AA01-PARAMS TO SYSR-PARAMS
0214.00 PERFORM 600-FATAL-ERROR
0215.00 END-IF.
0216.00
0217.00 IF AA01-STATUZ = ENDP
0218.00 MOVE ENDP TO WSSP-EDTERROR
0220.00 END-IF.
0221.00
0222.00 /
0223.00 2500-EDIT SECTION.
0224.00 *******************
0225.00 *
0226.00 2510-EDIT.
0227.00 *
0228.00 * Check record is required for processing.
0229.00 * Softlock the record if it is to be updated.
0230.00 *
0231.00 * MOVE O-K TO WSSP-EDTERROR.
0232.00 *
0233.00 2080-NEXTR.
0234.00 MOVE NEXTR TO AA01-FUNCTION.
0235.00 2590-EXIT.
0236.00 EXIT.
0237.00 /
0238.00 3000-UPDATE SECTION.
0239.00 *********************
0240.00 *
0241.00 3010-UPDATE.
0242.00 *
0243.00 * Update database records.
0244.00 *
0245.00
0247.00 IF AA01-COM-TYPE = 'AG'
0248.00 AND AA01-DTETRM = 99999999
0249.00 AND AA01-DTEAPP < 20060000
0250.00
0251.00 MOVE 2000 TO WSAA-PAYBYYEAR
0252.00 EVALUATE AA01-DUTY-DEG
0253.00 WHEN 'A1'
0254.00 MOVE 6000 TO WSAA-PAYBYDUTY
0255.00 WHEN 'B1'
0256.00 MOVE 5000 TO WSAA-PAYBYDUTY
0257.00 WHEN 'C1'
0258.00 MOVE 4000 TO WSAA-PAYBYDUTY
0259.00 WHEN OTHER
0260.00 MOVE 2000 TO WSAA-PAYBYDUTY
0261.00 END-EVALUATE
0262.00 PERFORM 7000-INSERT-TIM5
0263.00 END-IF.
0279.00 *
0280.00 3090-EXIT.
0281.00 EXIT.
0282.00 /
0283.00 3500-COMMIT SECTION.
0284.00 **********************
0285.00 *
0286.00 3510-COMMIT.
0287.00 *
0288.00 * Place any additional commitment processing in here.
0289.00 *
0290.00 3590-EXIT.
0291.00 EXIT.
0292.00 /
0293.00 3600-ROLLBACK SECTION.
0294.00 **********************
0295.00 *
0296.00 3610-ROLLBACK.
0297.00 *
0298.00 * Place any additional rollback processing in here.
0299.00 *
0300.00 3690-EXIT.
0301.00 EXIT.
0302.00 /
0303.00 4000-CLOSE SECTION.
0304.00 ********************
0305.00 *
0306.00 4010-CLOSE-FILES.
0307.00 *
0308.00 * Close any open files.
0309.00 *
0310.00 MOVE O-K TO LSAA-STATUZ.
0311.00 *
0312.00 4090-EXIT.
0313.00 EXIT.
0314.00 /
0315.00 5000-DEL-TIM5 SECTION.
0316.00 *
0317.00 5010-START.
0318.00 *
0319.00 INITIALIZE TIM5-PARAMS.
0320.00
0321.00 MOVE TIM5REC TO TIM5-FORMAT.
0322.00 MOVE BEGNH TO TIM5-FUNCTION.
0323.00 *
0324.00 5020-READ.
0325.00 *
0326.00 CALL 'TIM5IO' USING TIM5-PARAMS.
0327.00
0328.00 IF TIM5-STATUZ NOT = O-K AND ENDP
0329.00 MOVE TIM5-STATUZ TO SYSR-STATUZ
0330.00 MOVE TIM5-PARAMS TO SYSR-PARAMS
0331.00 PERFORM 600-FATAL-ERROR
0332.00 END-IF.
0333.00
0334.00 IF TIM5-STATUZ = ENDP
0335.00 GO TO 5090-EXIT
0336.00 END-IF.
0337.00
0338.00 MOVE DELET TO TIM5-FUNCTION.
0339.00 CALL 'TIM5IO' USING TIM5-PARAMS.
0340.00
0341.00 IF TIM5-STATUZ NOT = O-K
0342.00 MOVE TIM5-STATUZ TO SYSR-STATUZ
0343.00 MOVE TIM5-PARAMS TO SYSR-PARAMS
0344.00 PERFORM 600-FATAL-ERROR
0345.00 END-IF.
0346.00 *
0347.00 5080-NEXTR.
0348.00 MOVE NEXTR TO TIM5-FUNCTION.
0349.00 GO TO 5020-READ.
0350.00 *
0351.00 5090-EXIT.
0352.00 EXIT.
0353.00 /
0354.00 7000-INSERT-TIM5 SECTION.
0355.00 *
0356.00 7010-START.
0357.00 *
0358.00 INITIALIZE TIM5-PARAMS.
0359.00 MOVE AA01-COMPANY TO TIM5-COMPANY.
0360.00 MOVE AA01-BRANCH TO TIM5-BRANCH.
0361.00 MOVE AA01-AGNTNUM TO TIM5-AGNTNUM.
0362.00 MOVE AA01-DUTY-DEG TO TIM5-DUTY-DEG.
0363.00 MOVE WSAA-PAYBYYEAR TO TIM5-PAYBYYEAR.
0364.00 MOVE WSAA-PAYBYDUTY TO TIM5-PAYBYDUTY.
0365.00 MOVE TIM5REC TO TIM5-FORMAT.
0366.00 MOVE WRITR TO TIM5-FUNCTION.
0367.00 CALL 'TIM5IO' USING TIM5-PARAMS.
0368.00
0369.00 IF TIM5-STATUZ NOT = O-K
0370.00 MOVE TIM5-STATUZ TO SYSR-STATUZ
0371.00 MOVE TIM5-PARAMS TO SYSR-PARAMS
0372.00 PERFORM 600-FATAL-ERROR
0373.00 END-IF.
0374.00 7090-EXIT.
0375.00 EXIT.
0376.00 /
****************** End of data ****************************************