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
 

 

How to display Numeric field in report

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products
View previous topic :: :: View next topic  
Author Message
khyati kumar

New User


Joined: 04 Jan 2008
Posts: 15
Location: Pune

PostPosted: Wed May 28, 2008 6:43 pm    Post subject: How to display Numeric field in report
Reply with quote

Hi All,

Actually i am writing the program to display the report using easytrieve.In this there is one Amount field in my input file which is defined as
9(12).But in my report i want to display this field right justified replacing zeros by spaces(eg: if the input contain
Code:
000000123456
, then in my report it should be displayed as
Code:
      123456
.

the field is used as follows:-

Code:
WS-RPT-TYPE7-DTL4                           W      80 A         
 WS07-RPT-COMMON-DTL-HDR WS-RPT-TYPE7-DTL4         25 A         
 WS07-RPT-DR-ITEM-COUNT  WS-RPT-TYPE7-DTL4 +25      7 N MASK +   
 ('ZZZZZZ9')                                                     
 FILLER-20               WS-RPT-TYPE7-DTL4 +32      1 A         
 [color=red]WS07-RPT-DR-ITEM-AMOUNT [/color]WS-RPT-TYPE7-DTL4 +33     12 N MASK +   
 ('ZZZZZZZZZZZ9')                                               
 FILLER-21               WS-RPT-TYPE7-DTL4 +45      6 A         
 WS07-RPT-CR-ITEM-COUNT  WS-RPT-TYPE7-DTL4 +51      7 N MASK +   
 ('ZZZZZZ9')                                                     
 FILLER-22               WS-RPT-TYPE7-DTL4 +58      1 A         
 WS07-RPT-CR-ITEM-AMOUNT WS-RPT-TYPE7-DTL4 +59     12 N MASK +   
 ('ZZZZZZZZZZZ9')                                               
 FILLER-23               WS-RPT-TYPE7-DTL4 +71      9 A         


In the above WS07-RPT-CR-ITEM-AMOUNT.Here i had used the mask parameter to supress the laeding zeros but when i am displaying whole WS-RPT-TYPE7-DTL4 it displays the amount field without supressing the zeros.Please if anyone can help me for this.
Back to top
View user's profile Send private message

CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Wed May 28, 2008 10:30 pm    Post subject:
Reply with quote

The mask works for the report, but the display does not see the mask.
Does that help?
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed May 28, 2008 11:16 pm    Post subject:
Reply with quote

Hello,

Said slightly differently, If you display WS07-RPT-CR-ITEM-AMOUNT, you should see the zero suppression you want.
Back to top
View user's profile Send private message
lcmontanez

New User


Joined: 19 Jun 2007
Posts: 50
Location: Chicago

PostPosted: Thu May 29, 2008 2:47 am    Post subject:
Reply with quote

Let's try again,

The mask option will only work in the report section. Display will NOT use the mask (ie: leading zero will NOT be suppressed).
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu May 29, 2008 4:27 am    Post subject:
Reply with quote

Hello,

Quote:
Display will NOT use the mask (ie: leading zero will NOT be suppressed).
Even if the masked field is named in the DISPLAY?
Back to top
View user's profile Send private message
khyati kumar

New User


Joined: 04 Jan 2008
Posts: 15
Location: Pune

PostPosted: Thu May 29, 2008 9:50 am    Post subject:
Reply with quote

hi ,

actually i am not using report writer in this program i am just arranging the data as per my requirement and puting it to output report file so in this case it is not suppressing leading zeros.
Back to top
View user's profile Send private message
khyati kumar

New User


Joined: 04 Jan 2008
Posts: 15
Location: Pune

PostPosted: Thu May 29, 2008 10:11 am    Post subject:
Reply with quote

Actually what is happening when i am trying to display only amount field it is displaying the proper amount which is masked,but i am displaying WS-RPT-TYPE7-DTL4 ...in this the zeros are not suppressed in the amount field.
Back to top
View user's profile Send private message
lcmontanez

New User


Joined: 19 Jun 2007
Posts: 50
Location: Chicago

PostPosted: Thu May 29, 2008 7:09 pm    Post subject:
Reply with quote

dick scherrer wrote:
Hello,

Quote:
Display will NOT use the mask (ie: leading zero will NOT be suppressed).
Even if the masked field is named in the DISPLAY?


Sorry, I just tried this and it does work (maybe it depends on the release). I do recall this NOT working.

I stand corrected.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat May 31, 2008 12:00 am    Post subject: Reply to: How to display Numeric field in report
Reply with quote

Hello,

Quote:
Sorry, I just tried this and it does work (maybe it depends on the release). I do recall this NOT working.
Not to worry icon_smile.gif
Between product changes and subtle differences in specific code, oh well. . .

It's been one of those weeks for me as well - i've been "away" and haven't actually tested everything as i reply. . . Gotten "bit" on 2 things i remembered, but didn't verify icon_redface.gif

Have a gr8 weekend,

d
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 -> CA Products All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts INVALID FIELD OR CONSTANT IN SORTOF ?? Ron Klop DFSORT/ICETOOL 8 Wed Jan 11, 2017 3:44 pm
No new posts Display ZEDLMSG without Pressing F1 &... anandgbe CLIST & REXX 8 Thu Dec 15, 2016 4:20 pm
No new posts Performing arithmetic on input field zh_lad DFSORT/ICETOOL 31 Tue Dec 06, 2016 8:04 pm
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
No new posts How to split the records using the am... vnktrrd DFSORT/ICETOOL 24 Fri Oct 28, 2016 7:33 pm


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