Search found 7 matches

by ShivanoTE
Wed Apr 29, 2015 6:11 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: WER488A JOIN CAPACITY EXCEEDED
Replies: 10
Views: 12279

Next to the first line put the 'SORTED' parametre. Like this:

Code: Select all

       JOINKEYS FILES=F1,FIELDS=(01,64,A),SORTED                         
       JOINKEYS FILES=F2,FIELDS=(01,64,A),SORTED


This indicates that F1 and F2 are sorted and save you time and space. Try it!
by ShivanoTE
Fri Feb 20, 2015 12:13 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Problem with signs
Replies: 3
Views: 5915

Finally I made the sort to convert those numeric fields... //******************************************************************** //STEP0040 EXEC PGM=ICETOOL //TOOLMSG DD SYSOUT=* //DFSMSG DD SYSOUT=* //SHOWDEF DD SYSOUT=* //ENT1 DD DSN=ENTRADA1 //SAL1 DD DSN=SALIDA1,DISP=(NEW,CATLG), // SPA...
by ShivanoTE
Wed Jan 07, 2015 7:29 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Sort to split into 3 files with sum fields at GROUP level
Replies: 2
Views: 3976

Can you show us how the 3 output files should be? Also add the 'cols' line to see better the input file.
by ShivanoTE
Mon Dec 22, 2014 7:44 pm
Forum: JCL
Topic: JCL Diagram
Replies: 3
Views: 5531

JCL Diagram

Hi guys, somebody know a freeware app to draw flowchart from a job on plain text?
I find some, but all are shareware. Do you know someone to recommend?
Thanks!
by ShivanoTE
Thu Dec 18, 2014 11:02 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Problem with signs
Replies: 3
Views: 5915

OK. I got this: //STEP0040 EXEC PGM=SORT //SYSPRINT DD SYSOUT=* //SYSOUT DD SYSOUT=* //SORTIN DD DSN=INFILE,DISP=SHR //SORTOUT DD DSN=OUTFILE, // DISP=(NEW,CATLG), // SPACE=(TRK,(10,10),RLSE), // DCB=(RECFM=FB,DSORG=PS,LRECL=250,BLKSIZE=0) //SYSIN DD * SORT FIELDS=COP...
by ShivanoTE
Thu Dec 18, 2014 9:04 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Problem with signs
Replies: 3
Views: 5915

Problem with signs

Hi guys, I try to convert a number (ZD without sign) to PD, but the sign is unpacked at the end. My SORTIN: ----+----1----+----2----+----3----+----4-- CONV0000089800000002346768+00000000000000+ CONV0000095000000022186672-00000000000000+ CONV0000102600000023887500+00000000000000+ DEPO0017991200000229...
by ShivanoTE
Thu Dec 18, 2014 8:45 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: How to copy matching records and unmatching records in jcl
Replies: 1
Views: 4296

You may do a JOINKEYS sort (my favorite sentence in dfsort!) to do that, here a simple example: //JKE5 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //SORTJNF1 DD DSN=FIRST.FILE,DISP=SHR //SORTJNF2 DD DSN=SECOND.FILE,DISP=SHR //F1ONLY DD SYSOUT=* //F2ONLY DD SYSOUT=* //BOTH DD SYSOUT=* //SYSIN DD * * Control s...