Page 1 of 1

Can any one write a REXX program for me?

PostPosted: Sun Jan 22, 2012 12:38 am
by JCLKINGBY2013
I have 2 PS files.

1. Keys file
2. PS file with number of PS files


1. Keys file

field1  field2         field3
101      89237598   20119283982349
101      89237598   20119283643410
102      89237598   20119283947351
103      89237598   20119283364352
104      89237598   20119283982311
105      89237598   20119283982372
106      89237598   20342483982349
107      89237598   20119543987645
108      89237598   20119282382394



2. Another PS file with some information. say file2

SAMNC.MODST.HKAJJD.SALKSF.D120122
SAMNC.SAMNC.HKAJJD.SALKSF.ADSONSA.D120122
SAMNC.SALMS.HKAJJD.SALKSF.SAMN.D120122
SAMNC.MODLS.HKAJJD.SALKSF.D120122


My requirement is to take a PS dataset from the file2, search for the field3 from Keys file. If any of the key found in PS file taken from file2, write the dataset name on to file3 i.e. another ps file.

Please help me out in this...

Re: Can any one write a REXX program for me?

PostPosted: Sun Jan 22, 2012 1:31 am
by steve-myers
You are asking for the work product of professionals. Professionals expect to be paid. If you are willing to pay a professional to perform this task, leave a message here and someone may contact you using the private mail facility in this forum with their expected rates.

Re: Can any one write a REXX program for me?

PostPosted: Tue Jan 24, 2012 10:34 am
by expat
Why is this being done in REXX, the IO overheads could be huge depending on the input file sizes.

Re: Can any one write a REXX program for me?

PostPosted: Sat Jun 23, 2012 1:43 am
by dick scherrer
Hello,

Can any one write a REXX program for me?
Many Can, but probably no one Will (Unless you are willing to pay to have this rexx written for you - as Steve mentioned).

We are to help people learn and get thru problems encountered.

We are a Help forum - not a "write it for me forum". We are also not a manual-reading service.

Suggest you consider the impact of using rexx. Depending on the number of records in the input files named in file 2, you have the potential of dimming the lights in the data center. . . How many "keys" is the max for file 1?

Re: Can any one write a REXX program for me?

PostPosted: Wed Jun 27, 2012 9:21 pm
by Pedro
search for the field3 from Keys file. If any of the key found in PS file taken from file2,


Which one of your sample data fits the criteria?

Re: Can any one write a REXX program for me?

PostPosted: Thu Jun 28, 2012 2:31 am
by Ed Goodman
A few questions:
-Are the files in which you are searching all the same records length and type?
-How large can the key file get?
-How large are the files listed in PS file 2?
-How many files can be listed in PS file 2?

Re: Can any one write a REXX program for me?

PostPosted: Thu Jun 28, 2012 11:56 am
by NicC
I suspect that he has managed to do it by now - he has had 6 months and not come back once.

Re: Can any one write a REXX program for me?

PostPosted: Thu Jun 28, 2012 12:43 pm
by prino
Why not lock (or better just delete) this thread?