In the extract there is a column of TIME data type . The format of the TIME filed is hh.mm.ss by default. the hours , minutes and seconds are delimited by period.
The following information is available in the sysout after running the SYNCSORT about the specific field.
DB2 data type : TIME
SYNCSORT data type : CH
My requirement is to print the field in the format hh:mm:ss . the hours , minutes and seconds delimited by a colon.
I have read the syncsort prog guide and DFSORT programming guide but i couldn't understand how exactly to achieve this.
I tried using the EDIT option but keep getting syntax errors.
Please help in writing the OUTREC statement where this reformatting will be done using SYNCSORT.
I have other alternatives like to use Overlay after creating extract or DB2 functions to get hours , minutes and seconds separately and concatenate but I want to learn to do it in SYNCSORT using OUTREC while extracting.