Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> JCL
  2. Suggest New Category

what is the sortcard for comparing two files with a field key
and get the duplicates in onefile and noduplicates in another
file

Question Posted / annie

Answers were Sorted based on User's Feedback



what is the sortcard for comparing two files with a field key and get the duplicates in onefile and..

Answer / sv

sort fields = copy
sum fields = none,xsum

Is This Answer Correct ?    12 Yes 3 No

what is the sortcard for comparing two files with a field key and get the duplicates in onefile and..

Answer / arthi

JOINKEYS F1=FILE1,FIELDS=(1,10,A)
JOINKEYS F2=FILE2,FIELDS=(1,10,A)
JOIN UNPAIRED,F1,F2
REFORMAT FIELDS=(F1:1,10,F2:1,10)
INREC IFTHEN=(WHEN(1,10,CH,NE,11,10,CH),OVERLAY=(22:C'N'))
OUTFIL FNAMES=MATCHED,INCLUDE=(22,1,CH,EQ,C'B')
OUTFIL FNAMES=UNMATCHED,INCLUDE=(22,1,CH,EQ,C'N')

Is This Answer Correct ?    4 Yes 0 No

what is the sortcard for comparing two files with a field key and get the duplicates in onefile and..

Answer / vinodh

Refining the above sort card statement after executing it

SORT FIELDS=COPY
JOINKEYS FILES=F1,FIELDS=(1,10,A)
JOINKEYS FILES=F2,FIELDS=(1,10,A)
JOIN UNPAIRED,F1,F2
REFORMAT FIELDS=(F1:1,10,F2:1,10)
INREC IFTHEN=(WHEN(1,10,CH,NE,11,10,CH),OVERLAY=(22:C'N'))
OUTFIL FNAMES=MATCH,INCLUDE=(22,1,CH,EQ,C' ')
OUTFIL FNAMES=UNMATCH,INCLUDE=(22,1,CH,EQ,C'N')

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More JCL Interview Questions

Is there a limit of 3273 DD statements for a JCL or for every EXEC step in a JCL?

2 Answers  

how to identify the file used in the JCL is an VSAM file. Just seeing the JCL code how can we track the file as VSAM file?

6 Answers   CSC,

THERE IS ONE STEP AS BELOW: //STEPJS060 EXEC PGM=XYX, COND=((200,EQ,JS010),(0,NE,JS020.C),EVEN) COULD ANY ONE EXPLAIN HOW COND PARAMETER WORKS HERE? I AM CONFUSED BECOZ OF "EVEN".

2 Answers  

Is it possible to code instream data in a PROC?

0 Answers  

How is a GDG base created?

5 Answers  

what is the cond=even only

4 Answers   EDS,

I am getting the file from Unix to Mainframes for every 15 minutes. The mainframe job get abended with bad records coming from unix. I recovered that by deleting the bad data. I need permenant solution how to fix the issue? The record is getting characters in in first 9 positions which it should not. Please provide me the solution how to skip the records if it finds the charcters in the first 9 positions. K

3 Answers  

Passing a variable parm from JCL to a cobol/db2 program

1 Answers   IBM,

What is the difference between run mode and addressing mode?

0 Answers  

Why we will create load module in PDS only, Why nt in PS?

2 Answers   TCS,

What will happen if two JOB statements are mentioned in an JCL continuously.

2 Answers   IBM,

How is a new GDG coded?

2 Answers  

For more JCL Interview Questions Click Here
Categories