Mutiple condtions using REXX

dbzTHEdinosauer · Posted: Fri Aug 01, 2008 7:16 pm Post subject:

billiions of records is considered needed info when talking about rexx. rexx is not a high end i/o utility. you could compile your rexx.

you could build sort control statements
or
write a cobol/pl1/assembler module to process this data.

vidyaa · New User Joined: 02 May 2008 Posts: 46 Location: chennai

this rexx consists of panels and rexx codes, where the user input some values i need tovalidate each fields and throw message after validation take the values entered by the user and search if the combination of values entered by the user is present in a file which is going to have billion of records if the combination exists writes it to a file if not pops up an error message as 'Combination not found' and all these will be done online REXX validtions will be the backend so its not possible to put this in a batch mode.Searching of the combinations of field values entered by the user in the file containing billion of records takes me time.

gcicchet · Senior Member Joined: 28 Jul 2006 Posts: 691

Hi,

I can't believe anyone could come up with such a design, how often are these requests run ? how many users can request this ? what is the current time it takes to satisfy one of these requests ?

Surely the values entered by the user can be validated and saved into a file which can then be used in batch.

I would try to capture all requests into one file and run a batch job on a daily basis.

Gerry

expat · Posted: Tue Aug 05, 2008 12:33 pm Post subject:

Gerry, stop it will you, coming up with sensible suggestions

What do you think this is, a help forum or something

dick scherrer · Posted: Tue Aug 05, 2008 7:54 pm Post subject:

Hello,

If the concept has been proven, it would be best to do as DBZ suggests and re-code the process in a better suited language.

REXX may be the worst choice for processing high volumes of data. . .

Pedro

Craq Giegerich · Posted: Tue Aug 05, 2008 10:04 pm Post subject:

Billions of records, Millions of records I think some of these record estimates are a little off.

Pedro

vidyaa · New User Joined: 02 May 2008 Posts: 46 Location: chennai

yes i got your words intially it was thought to be few record and now it has come to billions. This is need to process online to get the user input and validate and throw him error messages. this cannot be changed to a program i guess. the seraching part kills time is there any way to incorporate this searching part in languale like cobol and combine with rexx as this needs to be done online.

gcicchet · Senior Member Joined: 28 Jul 2006 Posts: 691

Hi,

I want to be the user entering the data and waiting for the results.

I'll have to find ways of amusing myself.

Gerry

dick scherrer · Posted: Wed Aug 06, 2008 11:30 am Post subject:

Hello,

expat · Posted: Wed Aug 06, 2008 11:56 am Post subject:

If it must be done in a wasteful and inappropriate manner then you will need to look at some of the ways to maybe waste a little less resource.

I guess that your shop does not bill each department on its usage of resource, because if they do there will probably be some very unhappy bean counters when the resource bills start rolling in.

If you can use a unique key, then using a VSAM KSDS accessed by IDCAMS within REXX should work.

vidyaa · New User Joined: 02 May 2008 Posts: 46 Location: chennai

What i meant to say is the user only sees the front screen designed by panels he doesnot know what is happening in the backend rexx he corrects the input if he gets the error message, all the validations are done in rexx and throws the message

expat · Posted: Wed Aug 06, 2008 1:51 pm Post subject:

What happens behind the panels are usually of no interest to the user, just the results.

So how you design / implement a package that delivers the results is of no consequence to the user, which gives you a free hand to search the best and most effective methods.

Pedro