View previous topic :: View next topic
|
Author |
Message |
sivatechdrive
Active User
Joined: 17 Oct 2004 Posts: 191 Location: hyderabad
|
|
|
|
i have 2 files ,i need to compare(one field) the 2 files,and write the records which are not equakl to 3rd file
2 . how to restart a program without using jcl
Thanks
Siva |
|
Back to top |
|
|
jz1b0c
Active User
Joined: 25 Jan 2004 Posts: 160 Location: Toronto, Canada
|
|
|
|
Siva,
Please write questions clearly.
I got your question like this.
File-1
1
3
4
7
File-2
2
3
4
7
9
your output should have..
1
2
9.
if I got your question correct here is the answer
for this you have to sort both the files in same order.
Read file-1
Read file-2
Evaluate True
When file1-rec > file2-rec
write out-file from file2-rec
read file-2
when file2-rec > file1-rec
write out-file from file1-rec
read file-1
when file2-rec = file1-rec
read file-1
read file-2
ned-evaluate. |
|
Back to top |
|
|
sandip_datta
Active User
Joined: 02 Dec 2003 Posts: 150 Location: Tokyo, Japan
|
|
|
|
Hi Siva,
It can be done in SORT also but before I can proceed, I need following information -
1. File1 can contain duplicate or not?
2. File2 can contain duplicate or not?
3. File1 can contain all records in File2 + extra record?
4. File2 can contain all records in File1 + extra record?
5. Record length, F/V, field position and length?
A program can not be executed without JCL unless it is an online program. Online program can be executed/restarted by firing transaction ID but at backgrond some jcl must be running.
Regards,
Sandip. |
|
Back to top |
|
|
|