Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Compare and merging with VSAM

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
bbharathiraj
Warnings : 1

New User


Joined: 26 Oct 2006
Posts: 50
Location: Chennai

PostPosted: Mon Aug 30, 2010 4:06 pm    Post subject: Compare and merging with VSAM
Reply with quote

below is my requirement.

I/P FILE1 (flat file -FB)

COUNTRY-CODE PIC 9(3)
Current CUSTOM NMBR - X(19)

I/P FILE 2 (Total Length - 1020, VSAM file: key 1 to 26 - first 3 fields from below list)

COUNTRY CODE POS (1) length (PIC 9(3)
Current CUSTOM NMBR - POS (4) length X(19)
seq-nmbr pos (23) length 9(4) - Value is 0001
State-code - pos(404) length 9(3)
New-customer-nmbr pos(407) length x(19)

o/p:

I am trying to create the o/p file with the below format
ONLY if Current CUSTOM NMBR from File 1 is match with File2 and State-code = 780 and New-customer-nmbr should NOT BE SPACES.


o/p file: Total length 400 and FB. Other position can be spaces. Only below fields are important

rwenrl IND - POS (1) (T -constant)
Current CUSTOM NMBR POS(2) length Length X(19) (from file 1)
COUNTRY CODE pos(85) length 9(3) (from I/P file 1)
State-code pos(88) length 9(3) (from file 2)
New-customer-nmbr pos (91) length X(19) (from file 2)
Back to top
View user's profile Send private message

sqlcode1

Active Member


Joined: 08 Apr 2010
Posts: 578
Location: USA

PostPosted: Mon Aug 30, 2010 4:47 pm    Post subject:
Reply with quote

bbharathiraj,

What is the LRECL for file1? Could you have duplicates in file1 and/or file2 for the cust. number?Why do you say you want state code from file2 if it is always going to be a constant value of 780?

Please provide your DFSort function level.

Thanks,
Back to top
View user's profile Send private message
bbharathiraj
Warnings : 1

New User


Joined: 26 Oct 2006
Posts: 50
Location: Chennai

PostPosted: Mon Aug 30, 2010 6:16 pm    Post subject: Reply to: Compare and merging with VSAM
Reply with quote

My LrecL for file1 is 22 byte. I need to extract only state code is 780.I/p file 2 is also having other state code as well
Back to top
View user's profile Send private message
sqlcode1

Active Member


Joined: 08 Apr 2010
Posts: 578
Location: USA

PostPosted: Mon Aug 30, 2010 6:32 pm    Post subject:
Reply with quote

bbharathiraj,
You still didn't answer earlier question on duplicates. Could you have duplicates in file1 and/or file2 for the cust. number?

Thanks,
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Aug 30, 2010 7:57 pm    Post subject:
Reply with quote

Hello,

You need to post same sample input data and the output you want when that sample input is processed. You need to explain any rules associated with this process. If there can be duplicates, show this in the sample data as well as how duplicates should be dealt with.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Updating a VSAM file with DISP=OLD sheersh JCL & VSAM 8 Tue Mar 14, 2017 6:14 pm
No new posts SORT VSAM file with each field one by... maxsubrat DFSORT/ICETOOL 6 Tue Mar 14, 2017 1:07 pm
No new posts VSAM RLS=NRI while doing IDCAMS sheersh JCL & VSAM 1 Tue Mar 07, 2017 1:55 pm
No new posts Fail to change physical VSAM filename... jacobdng CICS 7 Fri Jan 20, 2017 12:36 pm
No new posts Storing huge volume of data, compare ... Pradeep K M All Other Mainframe Topics 3 Mon Jan 16, 2017 5:08 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us