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
 

 

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 Join in SQL Query vickey_dw DB2 2 Tue Jan 17, 2017 12:15 am
No new posts Storing huge volume of data, compare ... Pradeep K M All Other Mainframe Topics 3 Mon Jan 16, 2017 5:08 pm
This topic is locked: you cannot edit posts or make replies. MQ setup query mohitsaini Java & MQSeries 4 Sun Jan 08, 2017 1:53 am
No new posts DB2 query Using Recursion, Converting... smilewithashu2 DB2 1 Tue Jan 03, 2017 12:50 pm
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am


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