MVSFORUMS.com

rafa1215 · Beginner Joined: 14 Jun 2006 Posts: 3 Topics: 1

1. I would like Rexx to grab all lines of information from table A and log it somewhere - call it mismatchlog
2. Then from the mismatch log scan every line and look for specific entries that start of with numeric 23 (for example 23 DAX1234)
3. If it does not find a 23 then exit
4. If it does find a 23 then I would like it to run a compare routine

this is where I'm at so far with my idea - more to come
How would I code this in Rexx

superk · Advanced Joined: 19 Dec 2002 Posts: 684 Topics: 5

First of all, why REXX, especially if you're not familiar with it?

rafa1215 · Beginner Joined: 14 Jun 2006 Posts: 3 Topics: 1

Good question - I should of said why in the first place

My current employer uses this as a database retrieval program

kolusu · Posted: Wed Jun 14, 2006 9:33 pm Post subject:

rafa1215,

Unload the data using DSNTIUAL from the table specifying the 23 in the WHERE clause.

Now take this dataset as input and run your compare routine.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

rafa1215 · Beginner Joined: 14 Jun 2006 Posts: 3 Topics: 1

Thanks Kolusu,

Sorry to take so long getting back to ya
I'll give what you recommended a shot and let you know how it comes out