| Author |
Message |
Topic: Selective Count in Sort |
anandss_75
Replies: 2
Views: 1882
|
Forum: Utilities Posted: Mon Jan 14, 2008 2:54 am Subject: Selective Count in Sort |
Hello All,
I have a requirement as below
File 1
Rec no Col1 Col2
1 AAAAA CL
2 AAAAA CL
3 AAAAA C ... |
Topic: Confronting SB37 while SORT to find out matching records |
anandss_75
Replies: 22
Views: 18610
|
Forum: Utilities Posted: Tue Oct 23, 2007 4:59 am Subject: Confronting SB37 while SORT to find out matching records |
Vivek,
Thanks a ton.
My only intention of posting it to this forum is to find out ..if the sort cards can be fine tuned to avoid B37. I personally am not convinced that this problem is caused just ... |
Topic: Confronting SB37 while SORT to find out matching records |
anandss_75
Replies: 22
Views: 18610
|
Forum: Utilities Posted: Tue Oct 23, 2007 3:17 am Subject: Confronting SB37 while SORT to find out matching records |
Phani,
I know i am providing the error messages from the jcl that i just submitted. Would you please let me know why you are saying that i am not providing the correct messages. I might probably try ... |
Topic: Confronting SB37 while SORT to find out matching records |
anandss_75
Replies: 22
Views: 18610
|
Forum: Utilities Posted: Tue Oct 23, 2007 2:44 am Subject: Confronting SB37 while SORT to find out matching records |
Krisprems,
Regret the typo again. Please find the correct messages
JCL
//S1 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN1 DD DSN=PRWTPGG..SORT.PGG429PA.ULCLPTBL(0),DI ... |
Topic: Confronting SB37 while SORT to find out matching records |
anandss_75
Replies: 22
Views: 18610
|
Forum: Utilities Posted: Tue Oct 23, 2007 1:46 am Subject: Confronting SB37 while SORT to find out matching records |
Hello Everyone,
Regret the misinformation delivered. The Jcl i had posted was just a sample. The actual jcl is in production and the control cards are in specific card libraries. Hence the mismatch i ... |
Topic: Confronting SB37 while SORT to find out matching records |
anandss_75
Replies: 22
Views: 18610
|
Forum: Utilities Posted: Mon Oct 22, 2007 8:44 am Subject: Confronting SB37 while SORT to find out matching records |
Phani,
I had tried increasing the same to the extent possible and still i am getting this issue. Only due to this reason did i give filsiz option under dfsparms.
Also what you said about spool is tr ... |
Topic: Confronting SB37 while SORT to find out matching records |
anandss_75
Replies: 22
Views: 18610
|
Forum: Utilities Posted: Mon Oct 22, 2007 7:15 am Subject: Confronting SB37 while SORT to find out matching records |
Hello All,
I am confronting a SB37 while SORT to find out matching records between two files.
My jcl looks something like this
//S1 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT= ... |
Topic: Comparing different record length files |
anandss_75
Replies: 3
Views: 2178
|
Forum: Utilities Posted: Mon Oct 22, 2007 3:12 am Subject: Comparing different record length files |
Frank,
Thanks. That worked like a charm.
Thanks
Anand |
Topic: Comparing different record length files |
anandss_75
Replies: 3
Views: 2178
|
Forum: Utilities Posted: Fri Oct 19, 2007 8:35 am Subject: Comparing different record length files |
Hello All,
I have the following requirement.
1) I have two files that need to be matched on a particular field X in File 1 with another field Y in the file 2
2) The record lengths of these files a ... |
| |