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

Syncsort - OUTFIL HEADER1 positioning at column 2


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
kris_madras
Warnings : 1

New User


Joined: 04 Jul 2005
Posts: 31

PostPosted: Sun Aug 17, 2008 10:21 pm
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

Moderator Emeritus


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

PostPosted: Sun Aug 17, 2008 10:45 pm
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: 31

PostPosted: Sun Aug 17, 2008 11:02 pm
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

Moderator Emeritus


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

PostPosted: Mon Aug 18, 2008 1:17 am
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: 496
Location: USA

PostPosted: Mon Aug 18, 2008 8:01 pm
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: 31

PostPosted: Mon Aug 18, 2008 11:08 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts How to load to DB2 with column level ... DB2 6
No new posts Calling DFSORT from Cobol, using OUTF... DFSORT/ICETOOL 5
No new posts RC query -Time column CA Products 3
No new posts OUTFIL with SAVE option DFSORT/ICETOOL 7
Search our Forums:

Back to Top