getting the rec count and date



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

getting the rec count and date

Postby richj » Wed Jan 29, 2020 1:40 am

I think I have part if this correct
My sort is:

INCLUDE COND=(1,40,SS,EQ,C'.OUTPUT')
SORT FIELDS=(47,4,CH,A)

I would like to count the records and print the count and todays date to a second file. (snip from the manual)

COUNT FROM(IN3) WRITE(CT3) .... How do I add the date?
richj
 
Posts: 3
Joined: Wed Jan 29, 2020 1:26 am
Has thanked: 0 time
Been thanked: 0 time

Re: getting the rec count and date

 

Re: getting the rec count and date

Postby richj » Thu Jan 30, 2020 10:38 pm

I guess Count is part of ICETOOL not ICEMAN. I got the count to a second file in a second step.

Still looking for the date.
richj
 
Posts: 3
Joined: Wed Jan 29, 2020 1:26 am
Has thanked: 0 time
Been thanked: 0 time

Re: getting the rec count and date

Postby richj » Wed Feb 05, 2020 9:14 pm

This worked : the key was "NODETAIL" on the OUTFIL


//SYSIN    DD  *                                                    
 INCLUDE COND=(1,40,SS,EQ,C'.OUTPUT')                                
 SORT  FIELDS=(47,4,CH,A)                                            
 OUTFIL FNAMES=SORTCNT,REMOVECC,NODETAIL,                            
 TRAILER1=('XXXX.DATA.QREMOTE.DATA.SORT             ~',&DATE=(MD4/),
 '~',COUNT)                                                          
/*
richj
 
Posts: 3
Joined: Wed Jan 29, 2020 1:26 am
Has thanked: 0 time
Been thanked: 0 time


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post