IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Best solution for this by using ICEMAN OR ICETOOL


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Rajkumar_n

New User


Joined: 07 Dec 2006
Posts: 51
Location: Bloomington

PostPosted: Tue May 29, 2007 7:34 pm
Reply with quote

Hi,

I have 2 files as shown below with record structure as shown below

File 1
-------

Field1 Field2 Field3............

File2
------

Field 1

I would like to retrieve records from File1 with the condition of matching value for Filed1 from both files.

I am using DFSORT but my input is having large number of records and it is failing with reason icon_cry.gif maximum sort records reached.

Can any one advise best solution for this by using ICEMAN OR ICETOOL.

Thanks and Regards,
Rajkumar Nerella
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Tue May 29, 2007 9:00 pm
Reply with quote

Quote:
it is failing with reason maximum sort records reached


Please post the job you're using and the DFSORT messages (ICExxxs) you received.
Back to top
View user's profile Send private message
Rajkumar_n

New User


Joined: 07 Dec 2006
Posts: 51
Location: Bloomington

PostPosted: Tue May 29, 2007 9:10 pm
Reply with quote

Hi,

Thanks for your response.The message looks like the following.

ICE143I 0 BLOCKSET SORT TECHNIQUE SELECTED
ICE000I 1 - CONTROL STATEMENTS FOR 5740-SM1, DFSORT REL 14.0 - 17:16 ON MON MAY
SORT FIELDS=(6,5,PD,A)
SUM FIELDS=(1,1),FORMAT=ZD
ICE201I 0 RECORD TYPE IS F - DATA STARTS IN POSITION 1
ICE193I 0 ICEAM1 ENVIRONMENT IN EFFECT - ICEAM1 INSTALLATION MODULE SELECTED
ICE088I 1 TRN201UE.PSTEP03 . , INPUT LRECL = 24577, BLKSIZE = 24577, TYPE
ICE093I 0 MAIN STORAGE = (MAX,33554432,33554432)
ICE156I 0 MAIN STORAGE ABOVE 16MB = (33425928,33425928)
ICE127I 0 OPTIONS: OVFLO=RC0 ,PAD=RC0 ,TRUNC=RC0 ,SPANINC=RC16,VLSCMP=N,SZERO=Y,
ICE128I 0 OPTIONS: SIZE=33554432,MAXLIM=1048576,MINLIM=450560,EQUALS=N,LIST=Y,ER
ICE129I 0 OPTIONS: VIO=N,RESDNT=ALL ,SMF=SHORT,WRKSEC=Y,OUTSEC=Y,VERIFY=N,CHALT=
ICE130I 0 OPTIONS: RESALL=10240,RESINV=0,SVC=109 ,CHECK=Y,WRKREL=Y,OUTREL=Y,CKPT
ICE131I 0 OPTIONS: TMAXLIM=4194304,ARESALL=0,ARESINV=0,OVERRGN=0,CINV=Y,CFW=Y,DS
ICE132I 0 OPTIONS: VLSHRT=N,ZDPRINT=N,IEXIT=N,TEXIT=N,LISTX=N,EFS=NONE ,EXITC
ICE133I 0 OPTIONS: HIPRMAX=OPTIMAL,DSPSIZE=MAX ,ODMAXBF=0,SOLRF=Y,VLLONG=N,VSAMI
ICE084I 0 EXCP ACCESS METHOD USED FOR SORTOUT
ICE084I 0 EXCP ACCESS METHOD USED FOR SORTIN
ICE750I 0 DC 3712650774 TC 17398033723 CS DSVUU KSZ 6 VSZ 6
ICE752I 0 FSZ=858961 RC IGN=0 E AVG=24580 0 WSP=27422498 C DYN=0 0
ICE752I 0 FSZ=858961 RC IGN=0 E AVG=24580 0 WSP=27422498 C DYN=0 0
ICE046A 0 SORT CAPACITY EXCEEDED - RECORD COUNT 624402
ICE052I 0 END OF DFSORT

One more twist is the first input file will contain multiple records for one matching record in file2.

i.e

File 1
-------

XXXX A Field3............
XXXX B
XXXX C
File2
------

XXXX
YYYYY

I want to retrieve all records from File-1. Please suggest a good soloution.

Thanks and Regards,
Rajkumar Nerella
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Tue May 29, 2007 9:42 pm
Reply with quote

We're already discussing your ICE046A in:

ibmmainframes.com//viewtopic.php?t=21315

so we don't need to discuss it here.

If you want to discuss how to get the output you want, please show a better example of the records in each input file and what you expect for output, and explain the "rules" for getting from input to output.
Back to top
View user's profile Send private message
Rajkumar_n

New User


Joined: 07 Dec 2006
Posts: 51
Location: Bloomington

PostPosted: Tue May 29, 2007 10:49 pm
Reply with quote

Hi,

Please have a look at the following two records in HEX ON mode.

File 1.

01...d?2B.FULL000000000005 682FA07777050FI02 1111719830830200610032006T
4FF00289FC0CEDDFFFFFFFFFFFF44444444FFFCCFFFFFFFFCCFF44FFFFFFFFFFFFFFFFFFFFFFFFFE
0011214C220643300000000000500000000682610777705069020011117198308302006100320063
------------------------------------------------------------------------------
.01...d?2U..@.<..?1..MACHASE MORG.... 1938259966012000000472410001094CMAWEL
0FF00289FE00704039F00DCCCCEC4DDDC0000444444FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFCDCECD
0011214C2400C5C09C10041381250469700000000001938259966012000000472410001094341653

My First input file contains two records with apllication number : 10221849
whicah are two different type of records.

My second input file contains only the application number
File 2
10221849

My requirement is I need to gather all records from file1 after looking in to application number from file2

File is very very big file and I am getting error as I explained.

Please suggest a good solution for this.

Thanks and Regards.
Rajkumar Nerella
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Tue May 29, 2007 11:05 pm
Reply with quote

Does the SORT and SUM do what you want or do you need another solution?

Your latest post doesn't really explain anything more about what you're trying to do. It's NOT a good example. We can't help you if we don't understand what you're trying to do.

Quote:
File is very very big file and I am getting error as I explained.


As I said, we're already discussing the ICE046A in the other thread so we don't need to discuss it here. Have you looked at/tried the suggestions in the other thread?
Back to top
View user's profile Send private message
Rajkumar_n

New User


Joined: 07 Dec 2006
Posts: 51
Location: Bloomington

PostPosted: Tue May 29, 2007 11:25 pm
Reply with quote

Hi,

I am not tryin to discuss about the problem 'ICE046A' here

I am trying use and SORT and SUM for this requirement.

But I am worrying whether my requirement can be achived with SORT and SUM or not, because

I am sorting first file and placing a number 1 at first byte of record
For second file and I a sorting and placing number 2 at first bye of record

In the next step I am trying to use SUM Fields on first byte number

I am worrying if I am collecting records with value '3' in the first byte of record will resolve my requirement or not.

Can you please let me know if there are multiple records in first file does SUM will reflect to all records.

Thanks and Regards,
Rajkumar Nerella
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Tue May 29, 2007 11:43 pm
Reply with quote

Hello,

I believe this
Quote:
File is very very big file and I am getting error as I explained.
is the "the problem 'ICE046A' ". . .

If it is not, what other error are you getting?

To me, your requirement is still not at all clear. Please show what the "right" output would be from the input records you've posted (ie. as though they were the entire run).
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Tue May 29, 2007 11:51 pm
Reply with quote

Rajkumar,

I can't tell you if SORT and SUM will do what you want, because I don't understand what you're trying to do. I don't know what your input records look like and I don't know what you want the output records to look like.

You show:

SORT FIELDS=(6,5,PD,A)
SUM FIELDS=(1,1),FORMAT=ZD

In the three records you showed, I see X'40', X'00' and C'1'. X'40' and X'00' are NOT even ZD values. So I have no idea what you're trying to do.

Quote:
please let me know if there are multiple records in first file does SUM will reflect to all records


I can't figure out what you're asking here. A good example to illustrate what you want to know would help.
Back to top
View user's profile Send private message
Rajkumar_n

New User


Joined: 07 Dec 2006
Posts: 51
Location: Bloomington

PostPosted: Wed May 30, 2007 12:39 am
Reply with quote

It is my bad that I am not able to explain the requirement correctly. Let me try to put my requirement in this way.

I have File1 with the following data

OCR-CR-KEY-APPL-NUM OCR-CR-KEY-CNTR-CODE OCR-CR-KEY-CB2-CODE
5/PS 1/AN 1/AN
(4-8) (9-9) (10-10)
4------------------ 5------------------- 6------------------
********************************* TOP OF DATA **********************-CAPS OFF-*
10221849 2 B -------- Please obseve different
type of records here for the
same application number
10221849 2 U --------


10221850 1 C
10221850 1 D
10221850 1 U


File 2 will have the data as shown below

****** ***************************** Top of Data ******************************
000001 10221849
000002 10221850
****** **************************** Bottom of Data ****************************


Now I need to retrieve data for every record available in File2 from File1 (All records from File1)
Please remember the note shown above.

Please let me know if this requirement is clear. Please suggest me one good solution.

Thanks and Regards,
Rajkumar Nerella
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Wed May 30, 2007 1:53 am
Reply with quote

Hello,

Given that input, what do you need the output from those few records to be?
Back to top
View user's profile Send private message
Rajkumar_n

New User


Joined: 07 Dec 2006
Posts: 51
Location: Bloomington

PostPosted: Wed May 30, 2007 2:30 am
Reply with quote

Hi,

I need all records from Input file (File1) in my output file. That was an example but in reality File1 have many records.

I dont need any FILE2 records. File2 I am using is only for matching criteria.

Thanks and Regards,
Rajkumar Nerella
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Wed May 30, 2007 2:35 am
Reply with quote

Hello,

So there is not a requirement to accumulate any totals or record counts - is that correct?
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Wed May 30, 2007 3:22 am
Reply with quote

Rajkumar,

We're getting closer. icon_smile.gif

I think you're saying that you want all of the records from File1 that have a match in File2 ... is that right?

So if you had two input records in File1 with 10221855, you wouldn't want those in the output file because there's no match in File2 ... is that right?

Now I need to know:

1) What is the RECFM and LRECL of input file1 and input file2?
2) What is the starting position, length and format of the 8 digit value in file1 you want to compare on? Is the starting position 4 and the length 5?
I don't know what format PS represents - is it PD, ZD, something else?
3) What is the starting position, length and format of the 8 digit value in file2 you want to compare on?
4) Can file2 have duplicates within it? Your example doesn't show any duplicates within file2, but are they possible?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Shift left VB record without x00 endi... DFSORT/ICETOOL 11
No new posts how to calculate SUM value for VB fil... DFSORT/ICETOOL 1
No new posts how to calculate SUM for VB file usin... JCL & VSAM 1
No new posts Null values are considered in Total c... DFSORT/ICETOOL 6
No new posts SDSF like solution in EJES (store com... All Other Mainframe Topics 4
Search our Forums:

Back to Top