IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Filtering record from two different file formats(VB, FB)


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
G-Man

New User


Joined: 09 Oct 2008
Posts: 5
Location: Madras

PostPosted: Thu Jul 16, 2009 8:25 pm
Reply with quote

I have given my input file format and required output file format. I need to sort using syncsort.

Input-1

Key (20byte) First name(20byte) Last name(20byte)
XXX01X001000051-----LOGIST--------------LENIN
XX01X001000054-----CHIC----------------JACKY
XXX01X123123123---KUMAR---------------MARK

Input-2

Key(20byte)
XX01X001000054-----

Required Output:
Key (20byte) First name(20byte) Last name(20byte)
XX01X001000054-----CHIC----------------JACKY

File format:
Input-1: 64 byte VB file
Input-2: 20 byte FB file

Output file: 64 byte VB file
The output must have only the records from input-1 that has its key in input-2.
Back to top
View user's profile Send private message
Binop B

Active User


Joined: 18 Jun 2009
Posts: 407
Location: Nashville, TN

PostPosted: Fri Jul 17, 2009 9:48 am
Reply with quote

Hi G-Man,

These are some the very few topics already posted in the forum.

Topic1
Topic2

Please have a look and let us know if you were not able to find a solution.
Back to top
View user's profile Send private message
G-Man

New User


Joined: 09 Oct 2008
Posts: 5
Location: Madras

PostPosted: Fri Jul 17, 2009 5:35 pm
Reply with quote

Thanx Binop.

Regards,
GurU
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files and retrive records f... DFSORT/ICETOOL 3
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 8
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
Search our Forums:

Back to Top