Need Julian Date in Trailer record



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Need Julian Date in Trailer record

Postby arpitpatel01 » Mon Aug 10, 2015 6:17 pm

Hi,

I have a 80 byte FB input file.
I need to write an output file that will have record count ,one file name with Julian date appended to it and other hardcoded values.
ex. MY.OUTPUT.FILE.Dccyyddd

I used the sort card below:-

SORT FIELDS=COPY                                         
 OUTFIL REMOVECC,                                       
        NODETAIL,                                       
        TRAILER1=('1000',' ',                           
                   COUNT=(M11,LENGTH=9),' ',             
                  '000000000000000',' ',                 
                  'ABCD',' ',                           
                  'MY.OUTPUT.FILE.D',DATE3)


Below error message was generated.
OUTFIL STATEMENT : SYNTAX ERROR

Can someone explain why DATE3 is not supported here.Sortcard works fine if DATE is used.

Thanks.
arpitpatel01
 
Posts: 15
Joined: Wed Mar 25, 2015 9:32 am
Has thanked: 0 time
Been thanked: 0 time

Re: Need Julian Date in Trailer record

 

Re: Need Julian Date in Trailer record

Postby BillyBoyo » Mon Aug 10, 2015 6:59 pm

You should consult the documentation to discover what values are valid for dates in TRAILER1. DATE3 isn't there, but there are options for what you want, depending on exactly what you want.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post