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

Synchronized File Processing in Eztrieve


IBM Mainframe Forums -> CA Products
Post new topic   Reply to topic
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
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
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
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: 2146
Location: At my coffee table

PostPosted: Thu May 29, 2008 3:58 pm
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
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
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
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

Moderator Emeritus


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

PostPosted: Thu May 29, 2008 11:23 pm
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> CA Products

 


Similar Topics
Topic Forum Replies
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
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
Search our Forums:

Back to Top