MVSFORUMS.com

nivedita · Beginner Joined: 04 Nov 2003 Posts: 22 Topics: 15

HI ,

I am enclosing some writeup on in-memory cache / database .Can you please let me know if such an implementation is possible
for mainframe cobol / db2 application .The below writeup was prepared for a java application .

The set of data like reference data, business rules and validation rules which are frequently accessed by the application. Typical characteristics of these data are:

kolusu · Posted: Fri Dec 26, 2003 12:54 pm Post subject:

vani,

You can code a simple stored procedure which can be invoked from Java and will return the result set to client. check this link for Using stored procedures for client/server processing.

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAPH11/6.2?DT=20010710165542

Hope this helps...

cheers

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

sri_naveen · Posted: Tue Dec 30, 2003 4:23 am Post subject:

Hi Vani,
Stored procedures are alright if you also constantly update info, but since this is a typical read only stuff that needs to reside in MM, you can use the time tested Object Oriented paradigm....declare a template (its possible in java) and hardcode the logic on a layer above that template...this can be read only and reside in MM..while you can actually instantiate an object for the update transaction(s).
Lets not constrain our working to the so called "Database frameset"...OODB can be fun to explore...
Thanks and regards
_________________
Regards,
Naveen Srinivasan
Computer Sciences Corporation

--To err is human, to err again is more human--

vani · Beginner Joined: 28 May 2003 Posts: 51 Topics: 30

Thanks, using stored procedure was a good suggestion.

Will get back if I face any probelms.