Author Topic: Folder view what specific key or index value, but it displays the whole report  (Read 1821 times)

madrivers1

  • Newbie
  • *
  • Posts: 4
    • View Profile
I am hoping for a easy answer.  Aren't we all.

I have a request to store a report “File” in cmod that is ASCII code page 850 that has ending 0D0A at the end of each line.  This file has fixed length columns and is 2287 bites long.  The user has selected 9 of those columns to be indexed and searchable.  We got this to load as ACIF. I set the report  to break on each index value.  When I try to view this report from the folder to go to a specific key or index value it displays the whole report from the top, and not the specific key.  I think I know why it does this, because there are no page breaks in the document.  Is there a way to specify a new page after each row?  Even if there are no page breaks in the document?

Brian 

CC=NO
CCTYPE=Z
CONVERT=NO
CPGID=850
MCF2REF=CPCS
TRC=NO
FILEFORMAT=STREAM,(NEWLINE=X'0D0A')
TRIGGER1=*,19,X'2020',(TYPE=GROUP)                       /*         */
FIELD1=0,21,6,(TRIGGER=1,BASE=0)
FIELD2=0,27,12,(TRIGGER=1,BASE=0)
FIELD3=0,39,15,(TRIGGER=1,BASE=0)
FIELD4=0,54,4,(TRIGGER=1,BASE=0)
FIELD5=0,83,10,(TRIGGER=1,BASE=0)
FIELD6=0,95,14,(TRIGGER=1,BASE=0)
FIELD7=0,109,6,(TRIGGER=1,BASE=0)
FIELD8=0,127,16,(TRIGGER=1,BASE=0)
FIELD9=0,143,12,(TRIGGER=1,BASE=0)
INDEX1=X'434C49454E54',FIELD1,(TYPE=GROUP,BREAK=YES)   /* CLIENT */
INDEX2=X'434F4D50414E595F434F4445',FIELD2,(TYPE=GROUP,BREAK=YES)   /* COMPANY_CODE */
INDEX3=X'444F43554D454E545F4E554D424552',FIELD3,(TYPE=GROUP,BREAK=YES)   /* DOCUMENT_NUMBER */
INDEX4=X'46495343414C5F59454152',FIELD4,(TYPE=GROUP,BREAK=YES)   /* FISCAL_YEAR */
INDEX5=X'504F5354494E475F4441544532',FIELD5,(TYPE=GROUP,BREAK=YES)   /* POSTING_DATE2 */
INDEX6=X'504F5354494E475F504552494F44',FIELD6,(TYPE=GROUP,BREAK=YES)   /* POSTING_PERIOD */
INDEX7=X'4C4544474552',FIELD7,(TYPE=GROUP,BREAK=YES)   /* LEDGER */
INDEX8=X'444154415F464C4F575F4F524947494E',FIELD8,(TYPE=GROUP,BREAK=YES)   /* DATA_FLOW_ORIGIN */
INDEX9=X'555345525F4944',FIELD9,(TYPE=GROUP,BREAK=YES)   /* USER_ID */
DCFPAGENAMES=NO
UNIQUEBNGS=YES
IMAGEOUT=ASIS
INDEXOBJ=ALL
INDEXSTARTBY=1
INSERTIMM=NO
RESTYPE=NONE

Greg Ira

  • Full Member
  • ***
  • Posts: 240
    • View Profile
If the number of records in each page is identical you could use the LINECNT parm to force a page break. Other than that we've used an input exit to insert page breaks as needed.

madrivers1

  • Newbie
  • *
  • Posts: 4
    • View Profile
Thank you!!!!

Changing the Line count to 1 did the trick. 

Brian