|
View previous topic :: View next topic
|
| Author |
Message |
shrivatsa
Warnings : 1
Active User
Joined: 17 Mar 2006
Posts: 174
Location: Bangalore
|
|
|
|
Input File 1
FB LRECL=232 Key 1 to 11
Input file2
KSDS Average record size: 52
Maximum record size: 500
KSDS key length: 24
But from this key I want to compare with File1 11 Characters and produce output same as KSDS with MATCHED and UNMATCHED records
Input File1 FB:-
| Code: |
000000001602009020720001 20080207MGA01/01/1900METGEN MODEL A
000000001622010020720003 20080207MGC01/01/1900METGEN MODEL C
000000001642011020720005 20080207MGF01/01/1900METGEN MODEL F
000000001652011020720006 20080207RTA01/01/1900RETAIL MODEL A
000000001672011020720008 20080207RTH01/01/1900RETAIL MODEL H
000000001692011020720010 20080207RTJ01/01/1900RETAIL MODEL J |
Input File2 KSDS:-
| Code: |
000000001602008020720001 20080207MGA01/01/1900METGEN MODEL A
000000001612008020720002 20080207MGB01/01/1900METGEN MODEL B
000000001622008020720003 20080207MGC01/01/1900METGEN MODEL C
000000001632008020720004 20080207MGD01/01/1900 METGEN MODEL D
000000001642008020720005 20080207MGF01/01/1900METGEN MODEL F
000000001652008020720006 20080207RTA01/01/1900RETAIL MODEL A
000000001662008020720007 20080207RTG01/01/1900RETAIL MODEL G
000000001672008020720008 20080207RTH01/01/1900RETAIL MODEL H
000000001682008020720009 20080207RTI01/01/1900RETAIL MODEL I
000000001692008020720010 20080207RTJ01/01/1900RETAIL MODEL J |
Please help me out with this. |
|
| Back to top |
|
 |
Senthilkumar k
Warnings : 1
New User
Joined: 07 May 2009
Posts: 51
Location: Chennai
|
|
|
|
| Could you please provide me your expected output. |
|
| Back to top |
|
|
shrivatsa
Warnings : 1
Active User
Joined: 17 Mar 2006
Posts: 174
Location: Bangalore
|
|
|
|
I need MATCHED and UNMATCHED records in separate files with propertis like VSAM KSDS.
As such for the above example I don't have any expected output. |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
| shrivatsa wrote: |
| As such for the above example I don't have any expected output. |
here are the appropriate control cards:
|
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| As such for the above example I don't have any expected output. |
Nonsense. . . Of course you have expected output.
Now post the output files of matched and unmatched records that you want. No one here needs to "figure this out" - you need to post it.
You have been here for more than 4 years and should know this already. . .
d |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
Also, run this job and show the //SYSOUT messages you receive, so I can see what level you're at:
| Code: |
//S1 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD *
RECORD
//SORTOUT DD DUMMY
//SYSIN DD *
OPTION COPY
/*
|
|
|
| Back to top |
|
|
|
|
