Search found 805 matches

by Frank Yaeger
Wed Apr 19, 2006 1:03 am
Forum: DFSORT , ICETOOL & Utilities
Topic: To compare two files (SSN fields)
Replies: 20
Views: 55087

I check in the DFSMSG we have DFSORT REL 14.0 with us not the one you've mentioned i guess. DFSORT Rel 14.0 is just the base release to which PTFs are applied. Ask your System Programmer to apply DFSORT PTF UQ95213 (Dec, 2004). Once he/she does, you'll be able to use OVERLAY and BUILD. We when i us...
by Frank Yaeger
Tue Apr 18, 2006 11:05 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: To compare two files (SSN fields)
Replies: 20
Views: 55087

OVERLAY and BUILD require z/OS DFSORT V1R5 PTF UQ95214 or DFSORT R14 PTF UQ95213 (Dec, 2004). So if the $ is pointing to BUILD, that's why. Ask your System Programmer to install the appropriate PTF. I also tried using OUTREC instead of BUILD even that didn't work. When you say something didn't work,...
by Frank Yaeger
Tue Apr 18, 2006 9:26 pm
Forum: JCL
Topic: JCL - INCLUDE Condition - SORT INCLUDE COND
Replies: 4
Views: 26709

That's something you have to determine based on the amount of data you'll be writing to the output data set and the capacity of the devices you're using for output. There are formulas for how much data fits on a track, cylinder, etc for each type of device. If your output data set size will be equal...
by Frank Yaeger
Tue Apr 18, 2006 9:17 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: To compare two files (SSN fields)
Replies: 20
Views: 55087

1) The way you described your requirement, I thought you only wanted the SSN in the output data sets. So that's what I showed you how to do. If you want the entire record in each output data set, you can use a DFSORT/ICETOOL job like this: //S1 EXEC PGM=ICETOOL //TOOLMSG DD SYSOUT=* //DFSMSG DD SYSO...
by Frank Yaeger
Tue Apr 18, 2006 12:33 am
Forum: DFSORT , ICETOOL & Utilities
Topic: To compare two files (SSN fields)
Replies: 20
Views: 55087

Vikas, Here's a DFSORT/ICETOOL job that will do what I think you asked for. I assumed the SSN is in positions 1-9 in input file1 and in positions 19-27 in input file2, and that you just wanted the SSN in the output files. I also assumed that there are no duplicate SSNs within input file1, and no dup...
by Frank Yaeger
Mon Apr 17, 2006 8:24 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: To compare two files (SSN fields)
Replies: 20
Views: 55087

Can you use DFSORT instead of COMPAREX? If so, you can use a variation of the Smart DFSORT Trick discussed at:

http://www.ibm.com/servers/storage/supp ... 2.html#t05
by Frank Yaeger
Fri Mar 31, 2006 9:23 pm
Forum: JCL
Topic: JCL - INCLUDE Condition - SORT INCLUDE COND
Replies: 4
Views: 26709

1. The size of the output data set depends on the space you allocated for it. For example, if you specify SPACE=(CYL,(5,5)), you'll get a primary of 5 cylinders and secondaries of 5 cylinders as needed. To increase the size of the output data set, increase the space you allocate for it. 2. You can u...
by Frank Yaeger
Sat Feb 25, 2006 1:40 am
Forum: JCL
Topic: IEBGENER - Emptying dataset.
Replies: 5
Views: 21018

arrbee, You probably need to specify a RECFM and LRECL for the SYSUT1 DD DUMMY that matches your SYSUT2 data set. For example: //SYSUT1 DD DUMMY,RECFM=FB,LRECL=80 Note that this might work without specifying RECFM and LRECL in some shops because the values are being defaulted (e.g. by SMS). But in y...
by Frank Yaeger
Sat Feb 18, 2006 10:17 pm
Forum: Suggestions & Feedback
Topic: Upload Avatar from your machine
Replies: 2
Views: 4945

Great! Professor Rat is in the house. :wink:
by Frank Yaeger
Sat Feb 18, 2006 6:00 am
Forum: Suggestions & Feedback
Topic: Upload Avatar from your machine
Replies: 2
Views: 4945

Upload Avatar from your machine

On similar boards, it's possible to upload an avatar from your own machine. Can you please add that capability. I have an avatar (professor rat) I use on all of the helpboards I participate on and I would like to use it on this board as well.