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

I want to change the PD format into 99999.99999 format


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

New User


Joined: 30 Oct 2005
Posts: 5
Location: India

PostPosted: Mon Aug 31, 2009 6:31 pm
Reply with quote

Hi,

My requirement is to create a report using ICETOOL. Report has field called Share quantity as data type as PD which I need to convert into display format using ICETOOL as explained below.

For example,
If the share quantity in the input file is 9481000 then the output should be 94.81000. Can we achieve this using ICETOOL?

I have attached the JCL which I have used and the output which I have got using that JCL.

Thanks,
Sankar.

Mod Note: Attachment removed due to copyright complaints - Attached document has TCS Confidetial at footer
Back to top
View user's profile Send private message
Skolusu

Senior Member


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

PostPosted: Mon Aug 31, 2009 9:35 pm
Reply with quote

sankarcpp1,

Assuming that your input PD field is at pos 20 for 6 bytes and you want the edited result at pos 30 , the following control cards will give you the desired results

Code:

//SYSIN    DD *                                               
  SORT FIELDS=COPY                                           
  OUTREC OVERLAY=(30:(+100000,MUL,20,6,PD),DIV,+100000,       
                      EDIT=(IIIIT.TTTTT))                     
/*
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 Populate last day of the Month in MMD... SYNCSORT 2
No new posts Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts Need to convert date format DFSORT/ICETOOL 20
No new posts InfoSphere OPTIM CSV ouput vs DSNTIUA... IBM Tools 3
No new posts 3270 personal communications. Can't c... TSO/ISPF 2
Search our Forums:

Back to Top