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
 
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 attchmvs from rexx subroutine that re... harisukumaran CLIST & REXX 1 Fri Jan 19, 2018 5:29 am
No new posts Can we create REXX ouput in an Excel ... upendrasri CLIST & REXX 3 Wed Jan 17, 2018 8:19 pm
No new posts Need to obtain VTOC information via R... djeffbland CLIST & REXX 10 Thu Jan 11, 2018 4:13 am
No new posts REXX contest sergeyken CLIST & REXX 2 Tue Jan 09, 2018 1:55 am
No new posts To get Non matching row after compari... vinu78 DB2 7 Fri Jan 05, 2018 5:43 pm

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