Date conversion



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

Date conversion

Postby lekha » Tue Aug 07, 2012 10:30 am

Hi,
I have to convert month-day-year format to year-month-day format.
Code which i tried :
   OPTION COPY                                                       
   OUTREC PARSE=(%01=(ENDBEFR=C',',FIXLEN=5),                       
                 %02=(ENDBEFR=C',',FIXLEN=3),                       
                 %03=(ENDBEFR=C',',FIXLEN=18),                       
                 %04=(ENDBEFR=C',',FIXLEN=9),                       
                 %05=(FIXLEN=23)),                                   
                    BUILD=(%01,9:%02,15:%03,35:%04,Y4Y,TOGREG=(Y4T(-)),47:%05)     

Error message :
  WER268A  OUTREC STATEMENT  : SYNTAX ERROR                           
  WER211B  SYNCSMF  CALLED BY SYNCSORT; RC=0000                       
  WER449I  SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE


Without date conversion field code is working fine.
Kindly help me in this requirement

Thanks,
Lekha
lekha
 
Posts: 1
Joined: Tue Aug 07, 2012 10:04 am
Has thanked: 0 time
Been thanked: 0 time

Re: Date conversion

 

Re: Date conversion in jcl sort

Postby steve-myers » Tue Aug 07, 2012 10:56 am

  1. Determine the sort product in use at your site. IBM DFSORT messages are usually preceded by ICEnnn message codes. Syncsort messages are preceded by WERnnn codes. There are a few other sort products in the wild, but they are rarely encountered.
  2. Post this request in the appropriate forum for the sort product you use, not in the JCL forum. There is no such thing as a "JCL sort." Sort products are called by JCL, but the best place to get information about a sort product is in the appropriate forum.
  3. The control statements you show are not JCL. They are input controls that tell a sort product what to do.
steve-myers
Global moderator
 
Posts: 1885
Joined: Thu Jun 03, 2010 6:21 pm
Has thanked: 4 times
Been thanked: 197 times

Re: Date conversion in jcl sort

Postby BillyBoyo » Tue Aug 07, 2012 2:30 pm

Your topic has been moved to SYNCSORT, as you have the WER... messages.

Your post has also been Code'd to improve readability.

You need to show the full sysout for the step, all the WER messages as they are. Please use the Code tags.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: Date conversion

Postby MrSpock » Tue Aug 07, 2012 7:09 pm

I don't see any parameter "TOGREG" listed in the product documentation.
User avatar
MrSpock
Global moderator
 
Posts: 810
Joined: Wed Jun 06, 2007 9:37 pm
Location: Raleigh NC USA
Has thanked: 0 time
Been thanked: 2 times

Re: Date conversion

Postby Alissa Margulies » Tue Aug 07, 2012 7:59 pm

Which release of SyncSort for z/OS are you running?
Alissa Margulies
Syncsort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com
Alissa Margulies
Global moderator
 
Posts: 369
Joined: Tue Feb 26, 2008 11:15 pm
Location: USA
Has thanked: 1 time
Been thanked: 1 time

Re: Date conversion

Postby Alissa Margulies » Tue Aug 07, 2012 8:18 pm

In the OUTREC control statement you specified:
BUILD=(%01,9:%02,15:%03,35:%04,Y4Y,TOGREG=(Y4T(-)),47:%05)

Y4Y is not a valid field format. What does the data actually look like in that field?

In regards to the date conversion, are you just simply trying to reorder the field (move the year to the beginning instead of the end), or are you truly converting a Julian date to a Gregorian date?

Providing sample input and the desired output may help us to better assist you.
Alissa Margulies
Syncsort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com
Alissa Margulies
Global moderator
 
Posts: 369
Joined: Tue Feb 26, 2008 11:15 pm
Location: USA
Has thanked: 1 time
Been thanked: 1 time


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post