IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Eliminating Header Rows in a report


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
samuel_Inba

New User


Joined: 03 Jan 2008
Posts: 53
Location: Chennai

PostPosted: Thu Jun 12, 2008 4:37 pm
Reply with quote

Hi,
I have a FB file which is has a multi page report.Each report has a standard headers (company name & other details) which is about 8 lines.
The format of the file will be like this>

( Company name:Report name:etc.... ) for the first 8 lines

Actual report data ( from line num 9 thru 58)

then the second page of the report which again has the standard header as mentioned above (59 thru 66) thn the report continues with standard report length of (58 lines)...

Now I need to remove the eight header lines from the fB file which occurs repeatedly.

I cant use Omit with eight conditions with report heading.

Is there any way to use seqnum with restart & then use a single OMIT ?

Thanks
Back to top
View user's profile Send private message
samuel_Inba

New User


Joined: 03 Jan 2008
Posts: 53
Location: Chennai

PostPosted: Thu Jun 12, 2008 5:24 pm
Reply with quote

//TOOLIN DD * *** CONSTANT CONTROL CARDS ***
SELECT FROM(I1) TO(O1) NODUPS ON(1,100,CH)
/*
//CTL1CNTL DD *
SORT FIELDS=COPY
SUM FIELDS=NONE
/*

I tried to use the above mentioned step and it gave me the required result...but the resultant report was sorted and it messed up the final report...Is there any way to copy without getting the output sorted ?
Back to top
View user's profile Send private message
samuel_Inba

New User


Joined: 03 Jan 2008
Posts: 53
Location: Chennai

PostPosted: Thu Jun 12, 2008 5:26 pm
Reply with quote

Sorry - SUM FIELDS=NONE - Need not be there ( as NODUPS) Can take of the dups...

Thanks,
Back to top
View user's profile Send private message
scorp_rahul23

New User


Joined: 06 May 2008
Posts: 96
Location: Delhi

PostPosted: Thu Jun 12, 2008 5:31 pm
Reply with quote

U can very well Easytreive for this. It will remove the header lines
Back to top
View user's profile Send private message
samuel_Inba

New User


Joined: 03 Jan 2008
Posts: 53
Location: Chennai

PostPosted: Thu Jun 12, 2008 5:38 pm
Reply with quote

Sorry I am not supposed to use othr than JCL. icon_sad.gif
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Thu Jun 12, 2008 5:44 pm
Reply with quote

Quote:
I cant use Omit with eight conditions with report heading.

why ?
Quote:

Sorry I am not supposed to use other than JCL

I guess that Your organization must be trained on the proper terminology
jcl does nothing, it just setups things in order for programs to be able to execute
any action on data must be carried on by a .... program
utilities are just that, programs

it' s very difficult to understand the reasons for such sick requirements
Back to top
View user's profile Send private message
Skolusu

Senior Member


Joined: 07 Dec 2007
Posts: 2205
Location: San Jose

PostPosted: Thu Jun 12, 2008 11:47 pm
Reply with quote

samuel_Inba,

Please refer to the solution posted here

ibmmainframes.com/viewtopic.php?p=137819#137819
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts To get the count of rows for every 1 ... DB2 3
No new posts Exclude rows with > than x occurre... DFSORT/ICETOOL 6
No new posts Need help on formatting a report DFSORT/ICETOOL 14
No new posts Creating Report using SORT DFSORT/ICETOOL 7
No new posts Insert header record with record coun... DFSORT/ICETOOL 14
Search our Forums:

Back to Top