[Download-List] BREAK.SUP Page Break Option

Brian Pollitt bpollitt at dacc.edu
Tue Nov 4 10:11:01 EST 2008


Hi Everyone,

Is there a way to cause a page break when a BREAK.SUP value changes? 
I've tried using "'P'", but I get a syntax error. Here's my coding:

SELECT HRPER \
WITH HRP.LAST.PAY.PERIOD.WORK = "<<Enter Last Pay Period(MM/DD/YYYY):>>" \
BY D03.HR.PRI.POS.CLASS BY HRP.LAST.NAME

DOWNLOAD HRPER \
SECONDARY.FILE POSITION KEY HRP.PRI.POS \
BREAK.SUP "'P'" D03.HR.PRI.POS.CLASS FMT "0L" \
D03.HRPER.COUNTER FMT "0L" \
LITERAL "   " HRPER.ID FMT "15L" \
HRP.LFM.NAME FMT "30L" \
HRP.PRI.DEPT.DESC FMT "33L" \
POSITION->POS.DFLT.WORK.WEEK FMT "5L" \
LITERAL "    " \
HRP.EFFECT.EMPLOY.DATE FMT "8R" \
LITERAL "  " \
HRP.SERVICE.YEARS FMT "3R" CONV "MD02" \
HRP.SSN FMT "19R" LINE 2 \
HRP.AGE FMT "14R" \
LITERAL "          " \
HRP.PRI.POS FMT "19L" \
D03.HR.PRI.POS.TITLE FMT "40L" \
HRP.ACTIVE.BASE.SAL FMT "12R" \
LITERAL " " LINE 3 \
LITERAL " " LINE 4 \
....
....
....
FOOTING.ON D03.HR.PRI.POS.CLASS LITERAL "   --------------------------" \
LITERAL "" FMT "73L" \
LITERAL "------------" \
LITERAL "   Employees in Class " LINE 2 D03.HR.PRI.POS.CLASS FMT "2L" 
LITERAL ": " TOTAL D03.HRPER.COUNTER FMT "3R" \
LITERAL " 
           " TOTAL HRP.ACTIVE.BASE.SAL \
LITERAL "   --------------------------" LINE 3 \
LITERAL "" FMT "73L" \
LITERAL "------------" \
LITERAL " " LINE 4 \
FOOTING.ON FINAL LITERAL "   ====================" FMT "80L" \
LITERAL "   ===============================" \
LITERAL "   Total Employees: " LINE 2 TOTAL D03.HRPER.COUNTER FMT "3R" \
LITERAL "" FMT "60L" \
LITERAL "Total of Salaries: " TOTAL HRP.ACTIVE.BASE.SAL \
LITERAL "   ====================" FMT "80L" LINE 3 \
LITERAL "   ===============================" \
FILE _HOLD_ HR.EMPACT.TXT FORMAT FIXED OVERWRITING NO.PAGE

Thanks!!

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        Brian J. Pollitt
         Programmer/DBA
   Administrative Data Systems
Danville Area Community College
      2000 East Main Street
       Danville, IL 61865
         (217)443-8854
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
-------------- next part --------------
A non-text attachment was scrubbed...
Name: bpollitt.vcf
Type: text/x-vcard
Size: 357 bytes
Desc: not available
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20081104/025233b7/attachment.vcf>


More information about the download-list mailing list