Page 4 of 4

Re: File Comparison using ICETOOL

PostPosted: Fri Aug 31, 2012 3:51 pm
by BillyBoyo
The message, and workfile usage, tells you it was doing a SORT, as part of the SELECT. Consult the manual and turn it off.

Re: File Comparison using ICETOOL

PostPosted: Fri Aug 31, 2012 4:23 pm
by thermalchu
How to turn it off?

//DFSPARM DD *
OPTION DYNALLOC=(SYSDA,200),FILSZ=E7000000
DSNTYPE=LARGE,MAINSIZE=MAX
/*
//TOOLIN DD *
SELECT FROM(SORTIN) TO(OUTPUT) ON(1,3500,CH) NODUPS
/*

This is the error message I'm getting:
SORT CAPACITY EXCEEDED - RECORD COUNT 6653419
RECORDS SORTED - PROCESSED: 6653419, EXPECTED: 7596926
DFSORT FAILED TO DYNAMICALLY ALLOCATE THE REQUIRED WORK DATA SET SPACE
FWK=(153,966195) SWK=(2,10104) TWK=(45,161013) RWK=(6,40722) TOTAL=(206,1178034) BLK=55272
ATTEMPTED TO ALLOCATE 66564MB OF DISK WORK SPACE ON 200 WORK DATA SETS WERE USED
SUCCESSFULLY ALLOCATED 62095MB OF DISK WORK SPACE ON 206 WORK DATA SETS
200 WORK DATA SETS WERE INSUFFICIENT TO COMPLETE THIS SORT SO 6 ADDITIONAL WERE
DE-K61787 D5-K58148 C4-K58148 C4-K58148 E8-K70685
END OF DFSORT

Re: File Comparison using ICETOOL

PostPosted: Fri Aug 31, 2012 5:02 pm
by BillyBoyo
Firstly, while developing your solution, use test data.

If you are going to use ICETOOL functions, read that chapter in the manual, look at the examples, wonder what it is that the CNTL files can do for you.

Re: File Comparison using ICETOOL

PostPosted: Fri Aug 31, 2012 8:43 pm
by skolusu
thermalchu,

I am not sure as to why you are wasting time on something that cannot be done. Write a COBOL program to compare. You cannot use select on the first 4000 bytes and eliminate the dups as the other 3000 bytes may be different. So your approach itself is wrong.

Re: File Comparison using ICETOOL

PostPosted: Fri Aug 31, 2012 9:01 pm
by dick scherrer
Hello,

At the top of the COBOL part of the forum is working sample code that will "match" the file by the "key".

How you compare the matched records is up to you. How to process any unmatched is also your code. The sample code will handle the key compare (both files must ne in key sequence).

Re: File Comparison using ICETOOL

PostPosted: Sat Sep 01, 2012 8:55 am
by thermalchu
There is no other way I can modify this JCL? Like 3 steps in one job: (1-3000,3000-6000,6000-7000 bytes)

I went to COBOL part of the forum. It says:
You do not have the required permissions to view the files attached to this post.

Re: File Comparison using ICETOOL

PostPosted: Sat Sep 01, 2012 9:09 am
by dick scherrer
Hello,

There is no other way I can modify this JCL?
IIRC, you have been told NO several times. Suggest you let this go and use the programming solution. . .

This will sound tedious, but if you post each step you took to get to the "Sticky" and how you tried to download the attachment, we may see the problem. As far as i know there is no restricton on downloading attachments.

When downloading, do Not try to "open in new window" - this accesses the attachment, but it is basically unusable. When downloading the attachment right-click and save it to your hard drive. Then upload it to your mainframe.

Re: File Comparison using ICETOOL

PostPosted: Fri Sep 07, 2012 2:24 pm
by thermalchu
Thank you so much :)