Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
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
 
Query regarding easytreive compare?

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

New User


Joined: 25 Apr 2007
Posts: 13
Location: INDIA

PostPosted: Mon Apr 21, 2008 10:11 pm    Post subject: Query regarding easytreive compare?
Reply with quote

Hi,

Can anyone help me regarding eazytreive compare to compare two files based on specific fields. The fields must be compared case sensitive.

Its a urgent. Help pls.

Regards,
G.S.
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 Apr 21, 2008 10:20 pm    Post subject:
Reply with quote

Hello,

Quote:
The fields must be compared case sensitive.
All character field compares are case sensitive (meaning that "Case" is not = "CASE").

What do you mean by compared? Are you trying to match 2 files by some key? If you provide a better definition of your requirement, we can better offer suggestions. Posting sample data from the 2 files and how you want this code to work will help us help you.

Quote:
Its a urgent. Help pls.
Please do not use urgent. It really does you no good.
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: Mon Apr 21, 2008 10:28 pm    Post subject:
Reply with quote

Something like this?
Quote:
The INPUT parameter of the JOB statement designates files and their keys for synchronized file input. The exhibit below illustrates a variety of synchronized file and key combinations:
Code:
FILE FILE1 ...
KEY1A 1 5 A
...
FILE FILE2 ...
KEY2A 24 5 A
...
...
JOB INPUT(FILE1 KEY KEY1A +
          FILE2 KEY KEY2A)
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 Apr 21, 2008 11:06 pm    Post subject:
Reply with quote

Hello,

Quote:
The INPUT parameter of the JOB statement designates files and their keys for synchronized file input.
If that actually is the requirement. . .

Maybe we'll see what needs to be compared and how case sensitivity comes into the requirement. . . .
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: Wed Apr 23, 2008 1:11 am    Post subject:
Reply with quote

Hello,

Srini1528 wrote:
Quote:
HI,

I want to compare two files,

Eg:
File1
AA
BB
CC
DD
xx

File2
aa
bb
cc
dc
ee
FF

I want to compare the two files and result must be like upper case must return a count value and lower case must return a count value.

I think u will get it.

Regards,
G.S.

So far, i haven't gotten it.

Please explain the relationship between the 2 files - they don't have any values in common. . . Also, please post what the output from this process should be. That will probably help us help you.
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: Wed Apr 23, 2008 1:36 am    Post subject:
Reply with quote

Srini1528 wrote:
I want to compare the two files and result must be like upper case must return a count value and lower case must return a count value.
Am I missing something or is this making less sense than before?
Quote:
I think u will get it.
I have to agree with Dick, I haven't gotten it either......
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 query to fetch record which has only ... maxsubrat DB2 12 Mon Dec 11, 2017 5:03 pm
No new posts Compare VSAM files using DFSORT pshongal DFSORT/ICETOOL 5 Thu Nov 23, 2017 10:24 am
No new posts How to query MAXGENS of an existing P... Chuchulo Hatyzak JCL & VSAM 4 Wed Nov 22, 2017 10:23 pm
No new posts Native SQL Query kishpra DB2 1 Wed Nov 22, 2017 8:38 pm
No new posts Compare and COPY using DFSORT pshongal DFSORT/ICETOOL 3 Fri Nov 17, 2017 9:49 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us