want to determine if hex date field populated



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

want to determine if hex date field populated

Postby sydtally » Sat Jun 29, 2013 12:25 am

Hi,
I am wanting to output a third data set from my input file that has a date (hex)4 bytes starting in pos 91 ... I only want to include the record if it has a date ... it is not 00000f
//SORTOUT3 DD DSN=D.WIT.WRK.WCRF01.EFTPCHKC,DISP=(NEW,CATLG), 
//            DCB=(RECFM=FB,LRECL=0)                           
//SYSPRINT DD SYSOUT=A                                         
//SYSOUT   DD SYSOUT=A                                         
//CTL1CNTL DD *                                               
      SORT FIELDS=(1,103,CH,A)                                 
      OUTFIL FNAMES=SORTOUT1,                                 
      INCLUDE=(59,1,CH,NE,C' ')                               
      OUTREC FIELDS=(1,103,C'V')                               
      OUTFIL FNAMES=SORTOUT2,                                 
      INCLUDE=(43,1,CH,NE,C' ')                               
      OUTREC FIELDS=(1,103,C'R')                               
      OUTFIL FNAMES=SORTOUT3,                                 
      INCLUDE=(93,4,??,NE,??)                                 
   OUTREC FIELDS=(1,103,C'C')                               
      END                                           
anyhelp would be appreciated.
thanks
sydtally
 
Posts: 2
Joined: Sat Jun 29, 2013 12:19 am
Has thanked: 0 time
Been thanked: 0 time

Re: want to determine if hex date field populated

 

Re: want to determine if hex date field populated

Postby BillyBoyo » Sat Jun 29, 2013 3:06 am

CH and X'00000F' - that's three bytes. If it is four long, X'0000000F'.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: want to determine if hex date field populated

Postby sydtally » Mon Jul 01, 2013 7:21 pm

Thank you! yes it was my typo it is 4 long.
sydtally
 
Posts: 2
Joined: Sat Jun 29, 2013 12:19 am
Has thanked: 0 time
Been thanked: 0 time

Re: want to determine if hex date field populated

Postby Akatsukami » Mon Jul 01, 2013 7:51 pm

Although I cannot say definitely without more information, this alleged date field sounds very much like an unsigned packed decimal of precision 7. I really think that we need to know more about the data.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1053
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post