Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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 How to pick only YYMMDD from DATE1P (... atulbaviskar SYNCSORT 2 Wed Mar 22, 2017 11:39 am
No new posts Date and time format in CICS Chandru3183 CICS 2 Sat Mar 18, 2017 12:46 pm
No new posts Fail to change physical VSAM filename... jacobdng CICS 7 Fri Jan 20, 2017 12:36 pm
No new posts Match or compare two files in VB Format anatol DFSORT/ICETOOL 14 Thu Nov 03, 2016 7:41 pm
No new posts Low values Results from VARCHAR FORMAT balaji81_k DB2 10 Thu Oct 20, 2016 1:18 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us