Search found 8 matches

by vikasbs
Fri Jun 11, 2010 1:44 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: SORT JCL to seperate Matched and unmatched records
Replies: 4
Views: 11965

SORT JCL to seperate Matched and unmatched records

Hi Anuj,

The number in File A starts from collumn 1

- - - - + - - - - 1
11 11 1 1 11 1
The same number in File A in File B start from collumn 2

- - - - + - - - - 1 -
21 11 1 1 1 11 1

Hope I am clear.

Regards
Vikas
by vikasbs
Tue Jun 08, 2010 6:58 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: SORT JCL to seperate Matched and unmatched records
Replies: 4
Views: 11965

SORT JCL to seperate Matched and unmatched records

I've two file with FB record formate File A - Record length - 9 File B - Records Lenght - 300 I need to comparea a number from File A in position ( 1,9) to a number in FIle B in position (2,9). My Requirement 1) I want two output files OUT1 with matched records from File B 2) Output file OUT2 with u...
by vikasbs
Tue Apr 25, 2006 7:11 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: To compare two files (SSN fields)
Replies: 20
Views: 55087

To compare two files (SSN fields)

Hi Frank Hope you are doing fine well the jcl is working fine and i am getting the desired result but i've a small doubt on this syntax. COPY FROM(IN1) TO(T1) USING(CTL1) COPY FROM(IN2) TO(T1) USING(CTL2) SPLICE FROM(T1) TO(FILEA) ON(424,9,CH) WITH(433,1) - USING(CTL3) KEEPNODUPS COPY FROM(IN3) TO(T...
by vikasbs
Wed Apr 19, 2006 10:27 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: To compare two files (SSN fields)
Replies: 20
Views: 55087

To compare two files (SSN fields)

Hi Frank Thanks again ,but could you please give me in two step for example STEP01 FILEA compares FILEC compares and gives FILED as output. STEP02 FILEB compares with FILEC and gives FILEE as output. Frank since i have a requirement to send FILED and FILEE as report it would be great if you could gi...
by vikasbs
Wed Apr 19, 2006 2:48 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: To compare two files (SSN fields)
Replies: 20
Views: 55087

To compare two files (SSN fields)

Hi Frank The last JCL which you gave worked fine and my profound thanks to you. Frank your understanding is right about the requirement no 2. Please find the answers to your questions. We need to keep FILEA and FILEB and in the output i would just need FILED and FILEE. The specification of FILEC are...
by vikasbs
Wed Apr 19, 2006 12:19 am
Forum: DFSORT , ICETOOL & Utilities
Topic: To compare two files (SSN fields)
Replies: 20
Views: 55087

To compare two files (SSN fields)

Hi Frank I would like to explain the requirement 2 As you know we get two output file from the step which we are working FILEA and FILEB Now in the next step the above mentioned file would be compared to another file FILEC Now the compare once again will be on the SSN so i am writing out the all the...
by vikasbs
Tue Apr 18, 2006 10:53 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: To compare two files (SSN fields)
Replies: 20
Views: 55087

To compare two files (SSN fields)

Hi Frank, I just tried the new JCL but it ends with MAXCC=16 stating following message 1) OUTFIL FNAMES=OUT1,INCLUDE=(433,2,CH,EQ,C'11'),BUILD=(1,423) $ INVALID OUTFIL STATEMENT OPERAND OUTFIL FNAMES=OUT2,INCLUDE=(433,2,CH,EQ,C'22'),BUILD=(1,423) $ INVALID OUTFIL STATEMENT OPERAND I also tried using...
by vikasbs
Mon Apr 17, 2006 5:27 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: To compare two files (SSN fields)
Replies: 20
Views: 55087

To compare two files (SSN fields)

I have a requirement to compare two files .The field i am trying to compare is SSN . The requirement is : There are two files FILEA and FILEB I need to compare FILEA with FILEB where in the output file i need the SSN's found on FILEA not on FILEB I am trying to use COMPAREX but not able to get the d...