Mainframe, MVS and zOS Discussion

Posted: **Thu Oct 12, 2017 9:46 pm**

Hi,

There is a flat file of LRECL 500 and 1500 records. From column 10 date and time field start and they are in the format of DD.MM.YYYY and HH:MM:SS respectively.I want to copy this data in the output with all the fileds as is but date and time changed to the format YYYYMMDD and HHMMSS. How can I do that, please help.

Posted: **Fri Oct 13, 2017 2:54 pm**

What have you tried?

Posted: **Sat Nov 25, 2017 8:43 am**

I used like following :

Code: Select all

OUTREC FIELDS=(16,4,12,2,10,2)

as my date starts from column 10 in my input file. But I want to if there is a format which can directly understand DD.MM.YYYY, date with dots?

Mainframe, MVS and zOS Discussion

Change the date and time format in SORT.

Change the date and time format in SORT.

Re: Change the date and time format in SORT.

Re: Change the date and time format in SORT.