Interested to Buy Any Domain ? << Click Here >> for more details...
oza017.myorg.emp has 100 records ,oza018.myorg.staff has
200 records but 50 are the common records in both files
copy all the common records into oza017.myorg.xyz dataset
- 3 Answers
- 8714 Views
- Cognizant, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vinodh
IN SORT, YOU CAN USE JOINKEYS AND CAN TAKE 50 COMMON
RECORDS IN B/W 2 I/P FILES AND WRITE TO O/P FILE.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / mariopuzo
//step01 exec pgm=sort
//sysin01 dd=input1,disp=shr
// dd=input2,disp=shr
//sysout dd=output1,disp=(new,catlg,del)
//sysin dd *
Sum fields=none
/*
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / challa srinivas
//SORT1 EXEC PGM=SORT
//SORTJNF1 DD DSN = oza018.myorg.staff
DSN = oza017.myorg.emp
//SORTOUT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSIN DD DSN = oza017.myorg.xyz
JOINKEYS FILES=F1,
JOINKEYS FILES=F2,
REFORMAT FIELDS
SORT FIELDS=COPY
| Is This Answer Correct ? | 0 Yes | 0 No |
in catalog procedure i have step1 dd dsn=filea dd dsn=fileb dd dsn=filec ur concatenaning all the files. but i need to override fileb with file 2 ? can anyone give the ans pls for ths
Please go thru the below points and let me know how to code this. 1. Sort the input dataset for the condition : Starting position is 37,length of the field is 13 based on character and in the ascending order , starting from position 25 length of 12 ,character and in the ascending order. Use a temporary dataset to hold the sorted file. 2. Use the temporary file created in the above step as the input for the next step. The next step is to execute a program and produce an output file. Use the temporary file created in the above as work file 1 and the output of the file to be created in this step work file 2.Also, pass a parameter to the program that is to be executed in this step. The parameter should have the current date in YYYYMMDD format. For the sake of convenience, you can use the below Job Name : Sample1 Input DSN : PCABDT11.CABD.TEST.INPUT Temporary DSN : Sort1 Output DSN : PCABDT11.CABD.TEST.OUTPUT Program Name : SAMPLE Thanks in Advance for your response.
1)what is compilation jcl for cobol program but it is calling another program 2)what is compilation jcl for cobol program but it is calling another program(in this, main program is pure cobol but sub program is cobol+db2 program anyone please answer me for above questions. it's very urgent
i have 3 steps in my jcl, where i want to run only one step at a time depending on the variable. How should i give the condition statement... I have tried this with two steps which is working but not able to add condn for the 3rd step. can anyone help me... I want to know the cond stmt which i can code in step 3 and step4, so that only either step2 or step3 or step4 executes
I have Job A and Job B. I want to trigger Job B from Job A. Please advise.
I've one sequential file, that file size is LREC=100 (File contain Records like 1 to 100). Now I was increase the file size is LREC=102. My question is I want insert 00 (Two Zeros) in to the new file (That output file looks like : 00123 up to 100). How will write the SORT card in JCL. Please let me know.
how many members can be created inside a single pds?
what is a null indicator in db2?
We are aware of eliminating the duplicate records from outyput fiel using sort utility. Can we get the duplicate records in to another file in the Same sort utility?
How do you create a temporary dataset?
what type of version is we r using now real time in all modules(cobol, jcl, cics, db2, vsam)?
how to set dependancy for jobs?
COBOL 
