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
 

 

Syncsort - OUTFIL HEADER1 positioning at column 2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
kris_madras
Warnings : 1

New User


Joined: 04 Jul 2005
Posts: 26

PostPosted: Sun Aug 17, 2008 10:21 pm    Post subject: Syncsort - OUTFIL HEADER1 positioning at column 2
Reply with quote

Not sure why.. Sure I can get help here..

My work shop is using SYNCSORT. I am summarizing input file on Hour field to calculate frequency with header in the final output.

INREC FIELDS=(001:009,02, TX HOUR
010:C'00000001') RECORD COUNT
SORT FIELDS=(001,002,CH,A)
SUM FIELDS=(010,008,ZD)
OUTFIL FNAMES=MOTHREPT,
HEADER1=('HOUR',' COUNT')

Final output looks good.. but the output is starting from Column 2, with character '1' in column1..?

Code:
----+----1----+---
******************
1HOUR  COUNT     
118       00000185
 19       00000131
 20       00000216
 21       00000141
 22       00000112
 23       00000083
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: Sun Aug 17, 2008 10:45 pm    Post subject:
Reply with quote

Hello,

You have defined a "report" and those are "carriage control" characters.

All is working as it should. When you print the report, you will have the proper output. The carriage control characters do not actually print on the page.
Back to top
View user's profile Send private message
kris_madras
Warnings : 1

New User


Joined: 04 Jul 2005
Posts: 26

PostPosted: Sun Aug 17, 2008 11:02 pm    Post subject:
Reply with quote

dick scherrer wrote:
Hello,

You have defined a "report" and those are "carriage control" characters.

All is working as it should. When you print the report, you will have the proper output. The carriage control characters do not actually print on the page.


Great!.. Thanks for your quick reply.. need another help .. Can we suppress leading zeroes in the SUM FIELDS output as shown above?
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: Mon Aug 18, 2008 1:17 am    Post subject:
Reply with quote

Hello,

Yes, you can use the EDIT subparameter of OUTREC. Modify this to fit what you need:
Code:
  OUTREC FIELDS=(1,50,64,4,PD,M2,68,6,ZD,
     EDIT=($I,IIT.TTS),SIGNS=(,,+,-))
This example uses one packed decimal field and a "standard" edit mask and one zoned decimal field with a user-defined edit mask.
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Mon Aug 18, 2008 8:01 pm    Post subject:
Reply with quote

kris_madras wrote:
...the output is starting from Column 2, with character '1' in column1..?

Quote:
You have defined a "report" and those are "carriage control" characters. All is working as it should. When you print the report, you will have the proper output. The carriage control characters do not actually print on the page.

Please also refer to the optional REMOVECC parameter. If the output is intended to be viewed online or written to a list data set rather than a printout, then this option may be what you are looking for.
Back to top
View user's profile Send private message
kris_madras
Warnings : 1

New User


Joined: 04 Jul 2005
Posts: 26

PostPosted: Mon Aug 18, 2008 11:08 pm    Post subject:
Reply with quote

Thanks so much for your replies and suggestions
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DB2 query Using Recursion, Converting... smilewithashu2 DB2 1 Tue Jan 03, 2017 12:50 pm
No new posts Syncsort Help to group fields sudhakarraju SYNCSORT 6 Thu Dec 29, 2016 1:38 am
No new posts syncsort: copy lines after the keyword shreya19 SYNCSORT 7 Fri Dec 02, 2016 9:47 am
No new posts SQZ pipe delimited file with 1 column... Rick Silvers DFSORT/ICETOOL 2 Sun Nov 06, 2016 8:11 pm
No new posts Syncsort - Hard coded Value in output PORYES SYNCSORT 1 Thu Nov 03, 2016 9:23 am


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