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
 
I want to change the PD format into 99999.99999 format

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
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    Post subject: I want to change the PD format into 99999.99999 format
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    Post subject:
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    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 Partial color change of a field in CI... waseem0424 CICS 5 Fri Sep 29, 2017 7:56 pm
No new posts Fetch Previous month & year in MM... girishb2 DFSORT/ICETOOL 3 Thu Sep 21, 2017 9:54 pm
No new posts Convert rows and column into JSON for... Dinesh Manivannan DB2 2 Sun Sep 03, 2017 6:50 pm
No new posts Updating the Trailer count in variabl... satheshbabur DFSORT/ICETOOL 6 Wed Aug 30, 2017 9:49 pm
No new posts How to change a string containing the... chong.zhou TSO/ISPF 6 Tue Aug 29, 2017 4:54 pm

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