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"
Wednesday
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
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
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
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
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
Anthony is now a member of Mainframe
Jan 12
Anthony is now a member of Syncsort Community
Jan 12