Author |
Message |
Topic: Remove records if duplicate occurs more than once |
nagarajan.dharani
Replies: 8
Views: 3796
|
Forum: Utilities Posted: Mon Jan 14, 2008 2:40 am Subject: Remove records if duplicate occurs more than once |
Hi,
Can anyone help me one in the following requirement.
I've a fixed length record file with a employee number as one of the fields.
I need to do a sort and remove the duplicate records i ... |
Topic: Sequntial file compares |
nagarajan.dharani
Replies: 23
Views: 10316
|
Forum: Utilities Posted: Wed Oct 24, 2007 8:02 am Subject: Sequntial file compares |
Hi Kris,,
Thanks a lot for your code.
If my input files are as the following and the employee number is in binary format
Contents of IN1 (Employee numbers with their names, for example)
1 ... |
Topic: Sequntial file compares |
nagarajan.dharani
Replies: 23
Views: 10316
|
Forum: Utilities Posted: Wed Oct 24, 2007 5:03 am Subject: Sequntial file compares |
Hi Kris,
I've posted my sample values already.
Thanks,
Dharani |
Topic: Sequntial file compares |
nagarajan.dharani
Replies: 23
Views: 10316
|
Forum: Utilities Posted: Wed Oct 24, 2007 4:45 am Subject: Sequntial file compares |
Hi Vivek,
Following are the input file values and the output that i need.
Contents of IN1 (Only the employee numbers, for example)
11111
11111
22222
33333
44444
44444
66666
6666 ... |
Topic: Sequntial file compares |
nagarajan.dharani
Replies: 23
Views: 10316
|
Forum: Utilities Posted: Wed Oct 24, 2007 2:01 am Subject: Sequntial file compares |
Hi Krisprems,
Thanks a lot for having solved my requirement. But that code is getting me unmatched records also.
I tried the following code that you had given me
//************************* ... |
Topic: Sequntial file compares |
nagarajan.dharani
Replies: 23
Views: 10316
|
Forum: Utilities Posted: Fri Oct 19, 2007 6:30 am Subject: Sequntial file compares |
Hi,
This is my code and the build here has only 223 characters.
But i am still getting the same error
E RECORD TYPE IS F - DATA STARTS IN POSITION 1
3 END OF FIELD BEYOND MAXIMUM RECORD LENGT ... |
Topic: Sequntial file compares |
nagarajan.dharani
Replies: 23
Views: 10316
|
Forum: Utilities Posted: Fri Oct 19, 2007 6:20 am Subject: Sequntial file compares |
Out file length should be 223 and should have the simliar format of file1 |
Topic: Sequntial file compares |
nagarajan.dharani
Replies: 23
Views: 10316
|
Forum: Utilities Posted: Fri Oct 19, 2007 6:11 am Subject: Sequntial file compares |
file1 length is 223
file2 lenght is 10 |
Topic: Sequntial file compares |
nagarajan.dharani
Replies: 23
Views: 10316
|
Forum: Utilities Posted: Fri Oct 19, 2007 5:54 am Subject: Sequntial file compares |
Hi for the following code i am getting an error
E RECORD TYPE IS F - DATA STARTS IN POSITION 1
3 END OF FIELD BEYOND MAXIMUM RECORD LENGTH
0 C5-K26318 C6-K90007 C7-K90000 C8-K23476 E9-K ... |
Topic: Sequntial file compares |
nagarajan.dharani
Replies: 23
Views: 10316
|
Forum: Utilities Posted: Fri Oct 19, 2007 4:31 am Subject: Sequntial file compares |
Hi,
Can some one help me out in the following requirement.
I have two sequential files of different record length as below.
File1 with length 10
0000008060
0000009980
0000018060
0000019 ... |
Topic: Getting maxcc=0020 for ICETOOL |
nagarajan.dharani
Replies: 2
Views: 7706
|
Forum: Utilities Posted: Thu Oct 18, 2007 10:13 am Subject: Getting maxcc=0020 for ICETOOL |
Hi Frank,
Yes I missed out //TOOLMSG
Now it is working for me.'
Thanks a lot for your help.
Thanks,
Dharani |
Topic: Getting maxcc=0020 for ICETOOL |
nagarajan.dharani
Replies: 2
Views: 7706
|
Forum: Utilities Posted: Thu Oct 18, 2007 9:52 am Subject: Getting maxcc=0020 for ICETOOL |
Hi for the following code i am getting MAXCC=0020
Can someone please help me out insolving error.
//TOOLIN DD *
COPY FROM(IN1) TO(T1) USING(CTL1)
COPY FROM(IN2& ... |
Topic: Syncsort - tacking on one record to multiple records |
nagarajan.dharani
Replies: 9
Views: 6369
|
Forum: Utilities Posted: Fri May 25, 2007 10:50 am Subject: Syncsort - tacking on one record to multiple records |
Kolusu,
I am not able to get the exact code. Can you pls help me out?
Thanks,
Dharani |
Topic: Syncsort - tacking on one record to multiple records |
nagarajan.dharani
Replies: 9
Views: 6369
|
Forum: Utilities Posted: Fri May 25, 2007 9:14 am Subject: Syncsort - tacking on one record to multiple records |
Hi kolusu,
Following is my requirement
I have two files file1 and file2. I am sorting the file1 and i have a include cond in this sort. Include cond is field1 in file1 should be present in a s ... |
Topic: Syncsort - tacking on one record to multiple records |
nagarajan.dharani
Replies: 9
Views: 6369
|
Forum: Utilities Posted: Fri May 25, 2007 8:25 am Subject: Syncsort - tacking on one record to multiple records |
Hi,
I am trying with the below code. If the OPTION STOPAFT=1 is not given
the sort card fails with duplicate symbol definition as this sort card process
only 1 record from the input file. If I h ... |
|