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 Profile Log in to check your private messages Log in
 
Synchronized File Processing in Eztrieve

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products
View previous topic :: :: View next topic  
Author Message
ashwinreddy

Active User


Joined: 16 Sep 2004
Posts: 106
Location: Hyderabad

PostPosted: Wed May 28, 2008 4:17 pm    Post subject: Synchronized File Processing in Eztrieve
Reply with quote

Hi all,

As i am new to Eztrieve, plz help in understanding the logic behind the Synchronized File Processing ( I mean key Matching Logic in Eztrieve.

JOB INPUT ( SYS001 KEY ( WW-SYS001-POLICY ) SYS002 KEY ( AR-POLICY ))

My Doubt is when i use the above Matching verb, when their is Match between SYS001 and SYS002, will the records incermented in both the files (SYS001 and SYS002) or only in SYS001 and this record from SYS001 is compared from 1st record SYS002.

If Confused i will give you my file details

SYS001
Policy - Column in SYS001
1
2
3
4

SYS002
Policy - Column in SYS002
1
2
2
3
4

Now when the Record of SYS001 (Policy 1) is Matched to SYS002 (Policy 1), Will the next Record comparision will be as

Policy 2 of SYS001 is compared with Policy 1 of SYS002
or
Policy 2 of SYS001 is compared with Policy 2 of SYS002

Thx for Help

Cheers
Ashwin
Back to top
View user's profile Send private message

lcmontanez

New User


Joined: 19 Jun 2007
Posts: 50
Location: Chicago

PostPosted: Thu May 29, 2008 2:56 am    Post subject:
Reply with quote

Do you have access to the manual?
Back to top
View user's profile Send private message
ashwinreddy

Active User


Joined: 16 Sep 2004
Posts: 106
Location: Hyderabad

PostPosted: Thu May 29, 2008 10:59 am    Post subject:
Reply with quote

Hi,


Did you any time Read the Ezytrieve Manuals? , they won't explain the Logic much clearly.

And i don't know you but a small suggestion don't assume that people who post here doesn't do their intial research.

I know Ezytrieve little bit as my whole of my experience was in cobol. So i thought i could get help from here.

Cheers
Ashwin
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Thu May 29, 2008 3:58 pm    Post subject:
Reply with quote

I would think that "Policy 2 of SYS001 is compared with Policy 2 of SYS002" and "IF FIRST-DUP SYS002" would be TRUE....
Why don't you set up a quick test with displays and confirm the conditions for yourself?
Back to top
View user's profile Send private message
lcmontanez

New User


Joined: 19 Jun 2007
Posts: 50
Location: Chicago

PostPosted: Thu May 29, 2008 7:27 pm    Post subject:
Reply with quote

ashwinreddy wrote:
And i don't know you but a small suggestion don't assume that people who post here doesn't do their intial research.


Ashwin,

I was NOT assuming that you did not do your initial research. My question was "Do you have access to the manual". Some members on this forum use eztrieve but do not have ANY manuals.

I do use the manual and believe the REFERENCE manual explains the process well (see chapter 11). My initial question was to point you in the right direction.

My remarks was not intended as an offense.

Cheers
- lcmontanez
Back to top
View user's profile Send private message
ashwinreddy

Active User


Joined: 16 Sep 2004
Posts: 106
Location: Hyderabad

PostPosted: Thu May 29, 2008 9:39 pm    Post subject:
Reply with quote

Hi all,

Thanks for the Suggestions, Tried all the combinations but finally decided to go with Cobol.


lcmontanez,

Nothing Personal, i just want to say that some people will do their initail research.

Thanks for the Suggestions, i have looked at the Manuals tab in this forum but couldn't find any so i did google and found some manuals.

Sorry for mis-understanding.


Cheers
Ashwin
Back to top
View user's profile Send private message
Douglas Wilder

Active User


Joined: 28 Nov 2006
Posts: 305
Location: Deerfield IL

PostPosted: Thu May 29, 2008 10:41 pm    Post subject:
Reply with quote

I am sorry you had to go back to COBOL for this. I find file matching in Easytrieve very good. The order of the files in the job statement does make a difference. In this case the records returned to the program would be (1 matched with 1, 2 matched with 2, 2 matched with 2 again, 3 matched with 3, and 4 matched with 4). Internally 1 must have been matched with 2, but this combination would not be returned to the program. Please try file matching in Easytrieve, if not now, sometime when you have time to try things out. I too am primarily a COBOL programmer, and we do get more control in COBOL, but I find file matching like this in Easytrieve very quick and easy. When given a choice I usually choose to do this in Easytrieve rather than COBOL.
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: Thu May 29, 2008 11:23 pm    Post subject:
Reply with quote

Hello,

Quote:
i have looked at the Manuals tab in this forum but couldn't find any so i did google and found some manuals.
You should at least be aware that the manuals are not available here because the material is covered by copyright. We may neither post them not link to them from our forum.

If your organization is licensed to use the product, the material is free from CA support. If you are not licensed, the product should not be used.

If someone posts/downloads the actual CA copyrighted documentation, they are simply stealing from CA - not something i would recommend.
Back to top
View user's profile Send private message
ashwinreddy

Active User


Joined: 16 Sep 2004
Posts: 106
Location: Hyderabad

PostPosted: Fri May 30, 2008 8:55 pm    Post subject:
Reply with quote

Hi Douglas,

Yes i too Agree that Easytrieve is much simpler than cobol. As our Client request was so stupid that the left side file (SYS001) will have duplicates and right side(SYS002) won't. So i read in some manual that it should be reverse for using Matching logic. So i want to make it clear for any future use when i find time rather than overnight delivery.

Thanks for the Useful Information.

Hi Dick,

Sorry I fogot that the CA-Products manuls should be Licensed.


Cheers
Ashwin
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 -> CA Products All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Split 1 file into 10 output Files - S... Prasanth Kumar SYNCSORT 5 Sat Sep 16, 2017 12:02 am
No new posts BUILD OUTFIL based on condition other... balaji81_k DFSORT/ICETOOL 13 Fri Sep 08, 2017 11:06 pm
No new posts Skip file from delete pema_yozer All Other Mainframe Topics 3 Tue Aug 29, 2017 3:19 pm
No new posts editting the file by inserting zeros ... pramodrsingh DFSORT/ICETOOL 9 Mon Aug 21, 2017 5:58 pm
No new posts Match two files using multiple keys a... santoshks1987 SYNCSORT 11 Fri Aug 18, 2017 10:50 am

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