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
 
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 column with count of rows within dist... ronald wouterson DB2 4 Sun Sep 17, 2017 9:48 pm
No new posts Split 1 file into 10 output Files - S... Prasanth Kumar SYNCSORT 5 Sat Sep 16, 2017 12:02 am
No new posts BUILD OUTFIL based on condition other... balaji81_k DFSORT/ICETOOL 13 Fri Sep 08, 2017 11:06 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 Select numeric portion from CHAR data... balaji81_k DB2 6 Sat Aug 19, 2017 1:51 am

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