Anthony replied to Anthony's discussion Convert Normal/Standard date format to Julian format in Mainframe
"Hi Team,

I have found the way,

//SORTIN DD *
20081231
20090204
20070405
20040331
//SORTOUT DD SYSOUT=*
//SYSIN DD *
OPTION COPY
OUTREC BUILD=(1,8,Y4T,TOJUL=Y2T)

Please skip.

Kind regards,
Anthony"
Mar 22, 2017
Anthony posted a discussion in Mainframe
Hi Team,I have list of standard date list on SYNCSORT SYSIN control card, how I covert into Julian format. Please help me to find the way. Thanks.Kind regards,Anthony
Mar 21, 2017
Anthony replied to Anthony's discussion JOINKEYS Query in Mainframe
"Hi All,

Please skip above query., I am able to tidy up using below,

//SYSIN DD *
JOINKEYS FILE=F1,FIELDS=(1,44,A)
JOINKEYS FILE=F2,FIELDS=(1,44,A)
JOIN UNPAIRED,F1,F2
REFORMAT FIELDS=(F1:1,44,F2:1,92),FILL=C'#'
SORT FIELDS=COPY
OUTFIL FNAMES=NOMAT…"
Jan 30, 2017
Anthony posted a discussion in Mainframe
Hi Team,I have a question, I have two files, like to compare and print if matches not found on file2. So I have coded below logic.//STEP001 EXEC PGM=SORT//SORTWK01 DD DSN=&&SORT1,UNIT=3390,// SPACE=(CYL,(100,100))//SORTWK02 DD DSN=&&SORT2,UNIT=3390,…
Jan 30, 2017
Anthony replied to Anthony's discussion Find and count similar fields in each records and display if >20 in Mainframe
"Hi Brian Wood,

Thanks. Sorry, I misused your time. I have tidy up using REXX code.

Kind regards,
Anthony"
Jan 30, 2017
Anthony posted a discussion in Mainframe
Hi All,I am new to this community and syncsort. I have a situation like, we need to find  first key started at col 1 , its length is 7(field), if the total number of field exceeds >20 from apprx 200 records in a dataset, then it needs to be extracte…
Jan 12, 2017
Anthony is now a member of Mainframe
Jan 12, 2017
Anthony is now a member of Syncsort Community
Jan 12, 2017