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

leading spaces can be removed in trailer1 of sort JCL ?


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

New User


Joined: 04 Aug 2023
Posts: 6
Location: India

PostPosted: Fri Aug 04, 2023 3:53 pm
Reply with quote

Hi,

I have requirement to count the records in flat file and also sum for one comp -3 variable in file. I coded in trailer1 in sort jcl to calculate count and sum like below.

My doubt here is how to remove leading spaces when we calculate count and sum.

Ex:
current output:
8| 68|
expected output:
8|68|

Please can any one help me to code to remove leading spaces in trailer1.
Back to top
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 2141
Location: USA

PostPosted: Fri Aug 04, 2023 5:30 pm
Reply with quote

surezznag wrote:
Hi,

I have requirement to count the records in flat file and also sum for one comp -3 variable in file. I coded in trailer1 in sort jcl to calculate count and sum like below.

My doubt here is how to remove leading spaces when we calculate count and sum.

Ex:
current output:
8| 68|
expected output:
8|68|

Please can any one help me to code to remove leading spaces in trailer1.

1. Learn to post your code in a polite manner:
Code:
         8|             68|
Code:
8|68|


2. Present a sample of your code: what have you tried so far? If nothing, then your request to be ignored.

3. Hint: RTFM about parameters JFY=, and SQZ=
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 JCL sort to compare dates in two file... DFSORT/ICETOOL 2
No new posts Is this possible via sort (in one pass)? SYNCSORT 4
No new posts GDG generation name to GDG Base name ... DFSORT/ICETOOL 3
No new posts SORT on detail record, then repeat he... DFSORT/ICETOOL 3
No new posts FB to .CSV conversion using sort DFSORT/ICETOOL 7
Search our Forums:

Back to Top