Author |
Message |
Topic: remove duplicates from file with LRECL 3709 |
Martin
Replies: 12
Views: 9507
|
Forum: Utilities Posted: Fri Feb 12, 2010 2:49 pm Subject: remove duplicates from file with LRECL 3709 |
Martin,
As is the matching with longer keys is complicated and you threw in monkey wrench into it now with duplicates. I will try if I can come up with an elegant solution.
Thanks !! If you ar ... |
Topic: remove duplicates from file with LRECL 3709 |
Martin
Replies: 12
Views: 9507
|
Forum: Utilities Posted: Fri Feb 12, 2010 2:05 pm Subject: remove duplicates from file with LRECL 3709 |
Hi Kolusu,
In this case I want all the duplicates records from file1 to be removed from the output file.
Ex:
File1
aaaaaaaaa11111
aaaaaaaaa11111
aaaaaaaaa11111
aaaaaaaaa11111
File 2: ... |
Topic: remove duplicates from file with LRECL 3709 |
Martin
Replies: 12
Views: 9507
|
Forum: Utilities Posted: Fri Feb 12, 2010 1:41 pm Subject: remove duplicates from file with LRECL 3709 |
I have a file with a LRECL of 23200 and as mentioned in the original post I need to compare the entire record btw TWO files and remove the duplicates.
wow 23,200 bytes eh? Do any of these files hav ... |
Topic: remove duplicates from file with LRECL 3709 |
Martin
Replies: 12
Views: 9507
|
Forum: Utilities Posted: Fri Feb 12, 2010 12:07 pm Subject: remove duplicates from file with LRECL 3709 |
what if the LRECL exceeds 4088 bytes, How does SORT handle this?
well there is a trick to handle if the total key length exceeds 4088. However it would involve multi pass of data.
Could you plea ... |
Topic: remove duplicates from file with LRECL 3709 |
Martin
Replies: 12
Views: 9507
|
Forum: Utilities Posted: Fri Feb 12, 2010 11:40 am Subject: remove duplicates from file with LRECL 3709 |
Thanks Kolusu !!
I will try this out...
I have another question here:
what if the LRECL exceeds 4088 bytes, How does SORT handle this? |
Topic: remove duplicates from file with LRECL 3709 |
Martin
Replies: 12
Views: 9507
|
Forum: Utilities Posted: Fri Feb 12, 2010 10:50 am Subject: remove duplicates from file with LRECL 3709 |
Hi All,
I have 2 files with an LRECL of 3709. I need to compare these two files and remove the duplicates .
My question is NOT on how to remove the duplicates. I would like to know if SORT can ... |
Topic: Change character string in all members of a PDS |
Martin
Replies: 2
Views: 2025
|
Forum: Utilities Posted: Thu Feb 11, 2010 3:42 pm Subject: Change character string in all members of a PDS |
Hi All,
Here's the problem at hand:
every member of the PDS has the below character string :
The emp dept of the employee is : *BQXXXXX
Here * can any of the alphabets. ( A -Z ) . I need ... |
Topic: Copy data from specific GDG versions |
Martin
Replies: 2
Views: 6114
|
Forum: Utilities Posted: Mon Feb 01, 2010 6:35 pm Subject: Copy data from specific GDG versions |
Hi All,
Am having a file which specific GDG version names listed in here and I need to create an utility( preferably a JCL) to copy the data from the GDG base excluding the versions stated in the a ... |
Topic: Process GDG that are created today using REXX. |
Martin
Replies: 8
Views: 7232
|
Forum: Utilities Posted: Mon Feb 01, 2010 6:08 pm Subject: Process GDG that are created today using REXX. |
Hi All,
I am in similar situation wherein I need to copy the GDG versions which are created before given time ( thru a sort card). Is there a way to achieve this?
Thanks,
Martin |
Topic: How to activate initial screen of EJCK |
Martin
Replies: 3
Views: 5536
|
Forum: Job Control Language(JCL) Posted: Mon Feb 01, 2010 12:47 am Subject: How to activate initial screen of EJCK |
Am facing the same issue as stated above... Can anyone ans this pls? |
Topic: change the HLQ on all datasets |
Martin
Replies: 2
Views: 1990
|
Forum: Utilities Posted: Mon Jan 25, 2010 3:16 pm Subject: change the HLQ on all datasets |
Hi,
I need change the HLQ on all the datasets starting with MARTIN. Can this be done thru SORT?
Ex:
MARTIN.* Needs to change to <tsoid>.*
Thanks,
Martin |
Topic: copy every 5th record from the input file |
Martin
Replies: 2
Views: 1719
|
Forum: Utilities Posted: Thu Jan 14, 2010 12:42 pm Subject: copy every 5th record from the input file |
Thanks Frank for the quick reply ! |
Topic: copy every 5th record from the input file |
Martin
Replies: 2
Views: 1719
|
Forum: Utilities Posted: Thu Jan 14, 2010 11:18 am Subject: copy every 5th record from the input file |
Hi,
I have an I/P file with zillions of records and I need to copy every 5th record to the O/P file. Is there a way to achieve this using SORT?
File is 80 byte length and is FB
Thanks,
Mart ... |
Topic: SUPERC for multiple elements |
Martin
Replies: 3
Views: 2839
|
Forum: Job Control Language(JCL) Posted: Tue Nov 10, 2009 12:42 pm Subject: SUPERC for multiple elements |
Thanks for reply !!
I need help with point #3 here.... How do we create members out of the single PS file..
I searched the forum but couldn't find any similar examples.
TIA.
Martin |
Topic: SUPERC for multiple elements |
Martin
Replies: 3
Views: 2839
|
Forum: Job Control Language(JCL) Posted: Tue Nov 10, 2009 12:03 pm Subject: SUPERC for multiple elements |
Hi All,
I need to create SUPERCs for more than 1000 elements. Is there a way to create individual members for every SUPERC produced using any of the utilities?
EX:
PDS 1 :
AA
AB
AC
AD
. ... |
|