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
 

 

Need a REXX tool for comparing variables in 2 files

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CLIST & REXX
View previous topic :: :: View next topic  
Author Message
ankit0610

New User


Joined: 18 Jul 2006
Posts: 4

PostPosted: Tue Jul 18, 2006 10:24 am    Post subject: Need a REXX tool for comparing variables in 2 files
Reply with quote

Hello Everyone.
I need a tool in REXX which will compare variables given to it and search them in the 2 files (both the files are having same layout and r Sequential files)
..e.g. Lets say i wil give 3 variables A, B, C as the input to REXX tool.. it should search these 3 variables in 2 files and give me the results as :-
Variable Name, Variable Value(from 1st File) ,Variable Value(from 2nd File)

A Value of A Value of A
B Value of B Value Of B
C Value of C Value of C

Can anybody help me how can i achieve this??

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

ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2360
Location: Israel

PostPosted: Tue Jul 18, 2006 12:36 pm    Post subject:
Reply with quote

Three options:
1. Invoke SUPERC from within your REXX. This is the fastest option, but it depends on the complexity of your query.
2. Use EXECIO. Read the files line by line and look for the values. It will let you query very complex situations, but you are limited by the files size.
3. Use Edit-Macro.

O.
Back to top
View user's profile Send private message
ankit0610

New User


Joined: 18 Jul 2006
Posts: 4

PostPosted: Tue Jul 18, 2006 12:44 pm    Post subject: Re: Need a REXX tool for comparing variables in 2 files
Reply with quote

Thanks Ofer71 for your quick response..i have never involed Super C from REXX before, can you help me with the syntax?
Back to top
View user's profile Send private message
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2360
Location: Israel

PostPosted: Tue Jul 18, 2006 12:58 pm    Post subject:
Reply with quote

Take a look at SUPERC job (or generate one in 3.15). That will give you a hint about what you need for SUPERC invocation regarding input and output. Create a REXX with the following steps:

1. Allocate your input dataset to NEWDD.
2. Allocate yout output dataset to OUTDD.
3. Allocate SYSIN. QUEUE the line(s) with the search keywords.
4. Put your parms in a variable (for example PARMS='ANYC')
5 .Issue ADDRESS ISPEXEC "SELECT PGM(ISRSUPC) PARM("PARMS")".

O.
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 -> CLIST & REXX All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Append data from two files into a sin... Praveen04 DFSORT/ICETOOL 5 Thu Mar 16, 2017 7:29 pm
No new posts REXX cdoe to purge a JOB from spool a... Sulabh Agrawal CLIST & REXX 11 Thu Mar 09, 2017 11:36 am
No new posts Overriding PS data in rexx Shaheen Shaik CLIST & REXX 8 Fri Mar 03, 2017 5:08 pm
No new posts REXX compiled via RXTCOMP sergeyken CLIST & REXX 7 Tue Feb 07, 2017 9:41 pm
No new posts DB2 9.1.0 not move values to Host-Var... Miguel Fernandez DB2 8 Wed Jan 25, 2017 8:24 pm


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