Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
how to do generate report using ICETOOL based on record type

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
homesh_career

New User


Joined: 25 Aug 2005
Posts: 5

PostPosted: Mon Oct 20, 2008 10:03 pm    Post subject: how to do generate report using ICETOOL based on record type
Reply with quote

Hi,

I have a VSAM file (KSDS)...with LRECL 250
for example

Rectype data amount
1 aaaa 10.00
2 aadsf 20.00
1 fdgdfkl 30.00
4 dfgfd 20.00
2 dfgfd 10.00
1 iuretret 10.00
----------------------------------

The amount is in packed decimal..
and the output should be in the following format and the amount will be is a display format ..

RecType no_of_rec total_amt
1 3 50.00
2 2 30.00
4 1 20.00
------------------------------------

Please help out if this possible using ICETOOL.

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

Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Mon Oct 20, 2008 10:24 pm    Post subject:
Reply with quote

What is the starting position, length and format of each field in the input records?

What is the starting position of each column in the output records?

Does the VSAM input file have fixed-length records or variable-length records?
Back to top
View user's profile Send private message
homesh_career

New User


Joined: 25 Aug 2005
Posts: 5

PostPosted: Mon Oct 20, 2008 10:32 pm    Post subject:
Reply with quote

Thanks for reply ...
Input Record
Field1 - position 98, Length -1, char
Field2 - data field , not required in the output
Field3 - position 73 Packed Decimal s9(10)V99
----------------------------------------
Output reocrd

Field1 Record_type char 1
Field2 No_of_records - record count in display format 99999
Field3 Total_amount - display format
---------------
VSAM file is of fixed length format with LRECL 350

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

Senior Member


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

PostPosted: Mon Oct 20, 2008 10:51 pm    Post subject:
Reply with quote

homesh_career,

Use the following DFSORT control cards


Code:

//SYSIN    DD *                                   
  SORT FIELDS=(1,1,CH,A)                         
  INREC BUILD=(98,1,73,7,23:X)                   
  OUTFIL REMOVECC,NODETAIL,                       
  SECTIONS=(1,1,                                 
  TRAILER3=(1,1,X,COUNT=(M11,LENGTH=5),X,         
            TOT=(2,7,PD,EDIT=(IIIIIIIIIIIT.TT))))
/*


The output is
Code:

1 00003           50.00
2 00002           30.00
4 00001           20.00
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to select record x+7 or x+2 based... JoAnn Kulcyk SYNCSORT 6 Tue Jan 16, 2018 10:49 pm
No new posts query to fetch record which has only ... maxsubrat DB2 12 Mon Dec 11, 2017 5:03 pm
No new posts Extract record for change in combinat... Trinadh DFSORT/ICETOOL 6 Thu Nov 23, 2017 3:32 pm
No new posts ICETOOL - RESIZE DYNAMICALLY kranthikumarb DFSORT/ICETOOL 0 Tue Nov 21, 2017 5:30 pm
No new posts Extract Record using range of Data scorp_rahul23 DFSORT/ICETOOL 3 Wed Nov 15, 2017 11:54 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us