Search found 28 matches

by arcvns
Thu Sep 17, 2009 11:22 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Header date to overlay on all subsequent records
Replies: 12
Views: 16134

it appears that WHEN=GROUP came in with V1.5 and we are on V1.3 Carlos, You're running SYNCSORT FOR Z/OS 1.3.1. "WHEN=GROUP" is supported by the latest version of SyncSort which is SYNCSORT FOR Z/OS 1.3.2. Do you know if there is any other solution if WHEN=GROUP cannot be used ? Yes. This is untest...
by arcvns
Tue Aug 25, 2009 2:35 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: SORT - COUNT
Replies: 10
Views: 14094

MrSpock, I think this forum represents SyncSort as well. DFSORT , ICETOOL & Utilities In this Mainframe Forum - You can post your queries on DFSORT, ICETOOL , SyncSort & JCL Utilities DATASORT is not a valid operator for the Syncsort product The latest SYNCTOOL version - SYNCTOOL RELEASE 1.6.2 (ship...
by arcvns
Sat Aug 15, 2009 11:02 pm
Forum: JCL
Topic: What wll be the next version of GDG?
Replies: 3
Views: 3948

Same question in multiple forums :roll:
by arcvns
Wed Aug 12, 2009 5:12 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: SORT SUM
Replies: 9
Views: 12822

SRI123, And does this sysntax is valid for packed data also? No, it's NOT. As per your original problem, your input file has ZD data. The solution can vary based on the field format. for packed I'm not getting correct output The solution provided was for ZD input. Now what exactly is your field form...
by arcvns
Wed Aug 12, 2009 4:25 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: SORT SUM
Replies: 9
Views: 12822

Change your OUTFIL statement like this to display the sign as well. AFAIK s9(9)v99 would occupy only 11 bytes. OPTION COPY OUTFIL REMOVECC,NODETAIL, TRAILER1=('TOTAL=',TOT=(10,11,ZD,EDIT=(STTTTTTTTT.TT),SIGNS=(+,-)))
by arcvns
Wed Aug 12, 2009 1:30 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: SORT SUM
Replies: 9
Views: 12822

SRI123, Welcome to the forums. Try this one. //STEP1 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //SORTIN DD DSN = Input file //SORTOUT DD DSN = Output file //SYSIN DD * OPTION COPY OUTFIL REMOVECC,NODETAIL, TRAILER1=('TOTAL=',TOT=(10,12,ZD,M11,LENGTH=12))
by arcvns
Tue Aug 11, 2009 8:50 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Sort card to filter one record
Replies: 3
Views: 5180

Jairam_baju,

Is there anything which specifically identifies your first record?
by arcvns
Sat Aug 08, 2009 2:21 pm
Forum: JCL
Topic: how to limit SyncSort comparision ?
Replies: 1
Views: 2241

uthami, You can do file comparison using the JOIN feature available in SyncSort. But it's not quite clear what exactly you're expecting in output here. Please provide a few more details. 1)RECFM/LRECL of input as well as output files 2)Starting position and length of key field in the input files. 3)...
by arcvns
Fri Aug 07, 2009 6:09 pm
Forum: COBOL
Topic: How we can access PDS and its Members thru COBOL ?
Replies: 5
Views: 11954

Hello,

I doubt whether you'll be able to achieve this in COBOL. What you're trying can easily be done in REXX.
by arcvns
Fri Aug 07, 2009 12:46 pm
Forum: JCL
Topic: How to reset the return code of the same step ?
Replies: 3
Views: 5165

Hello,

As MrSpock said, you CANNOT change the return code of a step once it's issued.
Try using SET command. I am not sure whether it will work or not.
AFAIK, the SET command is used to initialize symbolic parameters in JCL.
by arcvns
Thu Aug 06, 2009 3:40 pm
Forum: JCL
Topic: Fetching Previous Day's date in my JCL
Replies: 11
Views: 13222

Hello, May be it's too late, but you can generate the above WHERE condition using the below SyncSort job. //STEP1 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //SORTIN DD * //SORTOUT DD SYSOUT=* //SYSIN DD * OPTION COPY OUTFIL REMOVECC,NODETAIL,BUILD=(80X), TRAILER1=('WHERE AUDIT_UPDT_TS BETWEEN',...
by arcvns
Thu Jul 09, 2009 6:38 pm
Forum: COBOL
Topic: is multiple STOP RUN are valid?
Replies: 16
Views: 17361

the statements coded after the STOP RUN, is valid???
Only if the same is "valid" when coded before STOP RUN :D
by arcvns
Thu Jul 09, 2009 6:03 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: SPLICE! - Help needed (urgent)
Replies: 6
Views: 8377

sts043,

You're welcome. Glad that it works fine for you :)
Can you tell me what the '99,8,ZD,SUB,+1,M11' is doing please?
It will subtract 1 from the sequence number for all records where you have a dot(.) at pos-21.
by arcvns
Wed Jul 08, 2009 8:29 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: SPLICE! - Help needed (urgent)
Replies: 6
Views: 8377

Glenn, Hello and welcome to the forums. :) Here's a Synctool job which I think does what you want. You can modify it as per your real file attributes. //STEP0100 EXEC PGM=SYNCTOOL //TOOLMSG DD SYSOUT=* //DFSMSG DD SYSOUT=* //IN DD * LONG TERM PLAN FOR DATE: 22/05/09 GSHPHCD@DAILYCAT | ORDENTRY 00.01...
by arcvns
Fri Jul 03, 2009 7:28 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Select records based on some condition
Replies: 7
Views: 8055

Bathri, The below SYNCTOOL job should work for your requirement. //STEP0100 EXEC PGM=SYNCTOOL //DFSMSG DD SYSOUT=* //TOOLMSG DD SYSOUT=* //IN DD DSN= Input file ---> FB/LRECL=80 //OUT DD DSN= Output file ---> FB/LRECL=80 //TOOLIN DD * SPLICE FROM(IN) TO(OUT) ON(89,8,CH) WITH&...