Search found 805 matches

by Frank Yaeger
Wed Jun 14, 2006 12:11 am
Forum: JCL
Topic: Help required for a sort step.
Replies: 5
Views: 10952

Ok, now I understand what you want to do. It's rather tricky, but the DFSORT/ICETOOL job below will give you what you asked for. Since you didn't give me the starting position, length and format of each of your fields, I assumed the following: Type = 1,12,CH Date-field = 13,10,CH Credit-Amt = 23,5,Z...
by Frank Yaeger
Tue Jun 06, 2006 10:18 pm
Forum: JCL
Topic: Help required for a sort step.
Replies: 5
Views: 10952

Some questions: Do you only have one key (e.g. "James") in the file, or can you have multiple keys (e.g. "James", "Richard", "Carl"). What is the RECFM and LRECL of the input file? Are the adate values already in ascending order as shown in your example? Can you please show a better example of the i...
by Frank Yaeger
Fri May 12, 2006 8:43 pm
Forum: JCL
Topic: hi clear this doubt
Replies: 1
Views: 5559

The problem is SPACE=(TRK,(25,10),RLSE),... You didn't specify any directory blocks so you get 0. Without any directory blocks, you can't create any members. Change your SPACE parameter to: SPACE=(TRK,(25,10,20),RLSE),... That will give you 20 directly blocks so you can create members. 20 is just an...
by Frank Yaeger
Thu May 11, 2006 8:40 pm
Forum: JCL
Topic: SORT OUTFIL HEADER Example
Replies: 5
Views: 19994

"how do we include Header and Taylor in sort command? I think you mean Header and Trailer. You can use DFSORT's OUTFIL statement to include header and trailer records of various types. For example, you can use the HEADER1 parameter to include report header records and the TRAILER1 parameter to incl...
by Frank Yaeger
Wed Apr 26, 2006 10:09 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Taking Backup of a Partitioned Dataset using ICEGENER
Replies: 4
Views: 10666

ICEGENER is DFSORT's replacement for IEBGENER. ICEGENER uses DFSORT's Copy function to copy a data set or a member of a pds. ICEGENER does NOT handle multiple pds members in one invocation. For complete information on DFSORT's ICEGENER, see: http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS...
by Frank Yaeger
Tue Apr 25, 2006 8:47 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: To compare two files (SSN fields)
Replies: 20
Views: 44802

could you please explain me does both the files from IN1 and IN2 gets copied to T1 . Yes. First the IN1 records are copied to T1. Then the IN2 records are copied to T1 (after the IN2 records). Note that MOD is used on the T1 DD to allow that: //T1 DD DSN=&&T1,UNIT=SYSDA,SPACE=(TRK,(5,5)...
by Frank Yaeger
Tue Apr 25, 2006 8:40 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Sumup of the fields in sort
Replies: 6
Views: 28196

Glad I could help.
by Frank Yaeger
Mon Apr 24, 2006 9:34 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Sumup of the fields in sort
Replies: 6
Views: 28196

Those are the correct control statements if your sum won't exceed 9 digits. If you're worried about your sum exceeding 9 digits, you can use these controls statements to add 2 extra digits of zeros at the start of the sum field to extend it from 5 bytes (max of 9 digits) to 6 bytes (max of 11 digits...
by Frank Yaeger
Fri Apr 21, 2006 10:19 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Sumup of the fields in sort
Replies: 6
Views: 28196

Let me explain by example. When you use DFSORT statements like this: SORT FIELDS=(6,3,CH,A) SUM FIELDS=(1,5,ZD) for input records like this: 12345AAA 35218AAA 71234AAA the first two records will be summed, but since the third record would cause the sum to overflow (that is, be greate...
by Frank Yaeger
Thu Apr 20, 2006 7:40 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: New DFSORT/ICETOOL Features (April, 2006)
Replies: 0
Views: 6603

New DFSORT/ICETOOL Features (April, 2006)

PTF UK90007 for z/OS DFSORT V1R5 and PTF UK90006 for DFSORT R14 (April, 2006) provide important enhancements to DFSORT and DFSORT's ICETOOL for extracting variable position/length fields (e.g. CSV, delimited fields, keyword separated fields, etc) into fixed parsed fields (PARSE, %nn); justifying and...
by Frank Yaeger
Wed Apr 19, 2006 11:15 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: To compare two files (SSN fields)
Replies: 20
Views: 44802

I'm kind of confused now. The last job I gave you creates four permanent data sets as follows: FILEA - records in IN1, but not in IN2. FILEB - records in IN2, but not in IN1. FILED - records in FILEA, but not in FILEC. FILEE - records in FILEB, but not in FILED. Do you need FILEA, FILEB, FILED and F...
by Frank Yaeger
Wed Apr 19, 2006 10:10 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: To compare two files (SSN fields)
Replies: 20
Views: 44802

Vikas, Here's a DFSORT/ICETOOL job that produces FILEA, FILEB, FILED and FILEE as requested in one step. If you really need it in two steps instead of one step, let me know. //S1 EXEC PGM=ICETOOL //TOOLMSG DD SYSOUT=* //DFSMSG DD SYSOUT=* //IN1 DD DSN=... input file1 (FB/80) //IN2 DD DSN=......
by Frank Yaeger
Wed Apr 19, 2006 9:33 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Omitt records from sort but still include them in output
Replies: 2
Views: 13569

I think you're trying to keep record 1 (a header?) where it is and sort the rest of the records. If that's what you're trying to do, then you can use a DFSORT job like this to do it. I assumed your input file has RECM=FB and LRECL=80, but the job can be changed appropriately for other attributes. //...
by Frank Yaeger
Wed Apr 19, 2006 9:21 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: DFsort
Replies: 2
Views: 5203

It's not clear to me exactly what you're trying to do. Please show an example of the records in input FileA and in input FileB and the expected output records, and explain the example. Give the RECFM and LRECL of input FileA and input FileB, and the starting position, length and format of all releva...
by Frank Yaeger
Wed Apr 19, 2006 1:16 am
Forum: DFSORT , ICETOOL & Utilities
Topic: To compare two files (SSN fields)
Replies: 20
Views: 44802

For requirement 2: Let's call FILED the output file for FILEA vs FILEC, and FILEE the output file for FILEB vs FILEC. Do you just need FILED and FILEE, or do you need FILEA, FILEB, FILED and FILEE? In other words, do you need to keep FILEA and FILEB or are they just temporary data sets you use to ge...