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
This topic is locked: you cannot edit posts or make replies. Calling REXX code from ISPF panel sanchita dey TSO/ISPF 4 Mon Jan 02, 2017 5:13 pm
No new posts REXX DB2: Dynamic allocation of DB2.D... BHAS CLIST & REXX 3 Mon Dec 19, 2016 8:26 pm
No new posts find particular member name in PDS us... ravi243 CLIST & REXX 10 Mon Dec 19, 2016 6:44 pm
No new posts High CPU consumption Job using IAM fi... aswinir JCL & VSAM 15 Thu Dec 01, 2016 8:28 pm
No new posts What is the command to check MODE of ... rohanthengal CLIST & REXX 7 Fri Nov 18, 2016 1:48 pm


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