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

HEADER1 and TRAILER1 with Julian date and Time (HHMM) format


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

New User


Joined: 11 Oct 2014
Posts: 2
Location: USA

PostPosted: Mon Oct 13, 2014 10:45 pm
Reply with quote

Hello All,

I have gone thru few of the posts regarding the use of Julian date and time (HHMM format) on the header1 and trailer1 records of the SORT card. I know that TIME2 option can not be used with header1 and trailer1.
There was a post where workaround was possible with BUILD but the position of the time was at end of the header and trailer record.

I have created a SORT card which will temporarily put the HHMM characters in the first SORT step and in the next SORT step I will replace them with TIME2 option. The output file is of 740 characters.

My query is - is any other solution to have time (HHMM format) in the middle of the header1 and trailer record.


//SYSIN DD *
OPTION COPY
OUTFIL REMOVECC,
HEADER1=('AAAAAAA',YDDDNS(YD),'HHMM',
'BBBBBBB',DATENS(4MD),'CCCCCCCC'),
INCLUDE=(1,24,CH,NE,C' '),
BUILD=(1,700,40X),
TRAILER1=('XXXXXXXX',YDDDNS(YD),'HHMM',
'YYYYYYYY',COUNT=(M11,LENGTH=6),
'ZZZZZZZZ',DATENS(4MD))
//*

Let me know if any more details needed.

Your suggestions are highly appreciated.
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 3051
Location: NYC,USA

PostPosted: Thu Oct 16, 2014 6:04 am
Reply with quote

Unless I misunderstood, would TIMENS helps you and then remove SS later?
Back to top
View user's profile Send private message
nileshinus

New User


Joined: 11 Oct 2014
Posts: 2
Location: USA

PostPosted: Thu Oct 16, 2014 10:41 am
Reply with quote

Hi Rohit,
I agree with your solution, but it requires one more step to achieve.
I am looking to achieve that in one step.

I appreciate your reply.

Thanks,
Nilesh
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Thu Oct 16, 2014 4:11 pm
Reply with quote

You're going to have to prepend (variable-length records) or append (fixed-length) an HHMM field to each record, and then reference that field in HEADER1 and TRAILER1.

In HEADER1 it will use the data from the first (if any) record of the OUTFIL group. In TRAILER1 it will use the data from the last (if any) record of the OUTFIL group.
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 Replacing 'YYMMDD' with date, varying... SYNCSORT 3
No new posts Populate last day of the Month in MMD... SYNCSORT 2
No new posts Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts To get the the current time DFSORT/ICETOOL 13
No new posts RC query -Time column CA Products 3
Search our Forums:

Back to Top