MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 20 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Remove records if duplicate occurs more than once
nagarajan.dharani

Replies: 8
Views: 3796

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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 ...
 
Page 1 of 2 Goto page 1, 2  Next
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group