Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Database for the REXX Applications?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CLIST & REXX
View previous topic :: :: View next topic  
Author Message
Prabhushankar

New User


Joined: 20 Nov 2007
Posts: 7
Location: Chennai

PostPosted: Fri Nov 23, 2007 8:05 pm    Post subject: Database for the REXX Applications?
Reply with quote

I am developing a Testing tool using REXX. I am in need of storing data for this application. Can any one suggest me what kind of file handling to be used for this application? My requirement is i shouldn't use DB2 tables.
Suggest to me an alternative (no sequential) way of file handling?
Back to top
View user's profile Send private message

superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4648
Location: Raleigh, NC, USA

PostPosted: Fri Nov 23, 2007 8:24 pm    Post subject: Reply to: Database for the REXX Applications?
Reply with quote

Let's see.

You've ruled out using DB2. I suppose then that using other RDBMS's might still be feasible, as long as they provide a workable interface to REXX.

You're right that REXX doesn't have any native access to VSAM file processing. And you want to rule out its only native file access method, which is QSAM.

I don't know what to tell you. Maybe you should reconsider the language you want to use and try something else that better meets your requirements. Maybe you can use a third-party VSAM interface to REXX (like RXVSAM or REXX Tools).
Back to top
View user's profile Send private message
Prabhushankar

New User


Joined: 20 Nov 2007
Posts: 7
Location: Chennai

PostPosted: Sat Nov 24, 2007 8:38 am    Post subject: Reply to: Database for the REXX Applications?
Reply with quote

Superk,
Thanks for the info. Can you tell me about using RDBMS concept ?
Also you have mentioned about using the third party VSAM interface (RXVSAM) to REXX. For using that, should i need to purchase that software or its available for free.
I also had an idea of using the ISPF tables for handling my REXX application data. Is it feasible to use that (or) do you think any limitation is there?
Suggestions are most welcome .....................
Back to top
View user's profile Send private message
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2360
Location: Israel

PostPosted: Sat Nov 24, 2007 2:51 pm    Post subject:
Reply with quote

Why can't you use ISPF tables?

O.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Nov 24, 2007 11:51 pm    Post subject:
Reply with quote

Hello,

If this application is to support the business, why is db2 not permitted? Specifying separate tables to support infrastructure tools is quite common.

One advantage of using the standard database is that no additional level of technology is needed.
Back to top
View user's profile Send private message
Prabhushankar

New User


Joined: 20 Nov 2007
Posts: 7
Location: Chennai

PostPosted: Mon Nov 26, 2007 11:03 am    Post subject: Reply to: Database for the REXX Applications?
Reply with quote

Thanks for the info. I have explained my current situation below,
I am planning to use ISPF table for my application. But it seems IPSF table exists only for the session currently open, also its user specific.
I found an alternative to store my ISPF tables permanently (using ISPF Table service - TBSAVE ). Other issue is, this table access exists only for my user id. I found these tables are stored in the user specific datasets which is concatenated to the DDNAME's ISPTLIB & ISPTABL.
I want to make these tables to be used across all users, so i need to store these tables in a common Dataset that will be accessed by every users. Please suggest me how to do that ?
Back to top
View user's profile Send private message
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2360
Location: Israel

PostPosted: Mon Nov 26, 2007 11:51 am    Post subject:
Reply with quote

Supply the ISPTLIB & ISPTABL in the logon procedure that is in use by all the users needing the application.

O.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10211
Location: italy

PostPosted: Mon Nov 26, 2007 12:54 pm    Post subject: Reply to: Database for the REXX Applications?
Reply with quote

Sharing ISPF tables among users provides only for READ integrity ,
if You need shared WRITE Access it would be better to explore a different path.

if You will post more details we might be of more help
Back to top
View user's profile Send private message
Prabhushankar

New User


Joined: 20 Nov 2007
Posts: 7
Location: Chennai

PostPosted: Mon Nov 26, 2007 3:26 pm    Post subject: Reply to: Database for the REXX Applications?
Reply with quote

ofer71,
Can you tell me the procedure how to add ISPTABL & ISPTLIB in LOGON procedure?
Back to top
View user's profile Send private message
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2360
Location: Israel

PostPosted: Mon Nov 26, 2007 3:54 pm    Post subject:
Reply with quote

Just ask your system programmers...

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
This topic is locked: you cannot edit posts or make replies. Calling REXX code from ISPF panel sanchita dey TSO/ISPF 4 Mon Jan 02, 2017 5:13 pm
No new posts REXX DB2: Dynamic allocation of DB2.D... BHAS CLIST & REXX 3 Mon Dec 19, 2016 8:26 pm
No new posts find particular member name in PDS us... ravi243 CLIST & REXX 10 Mon Dec 19, 2016 6:44 pm
No new posts What is the command to check MODE of ... rohanthengal CLIST & REXX 7 Fri Nov 18, 2016 1:48 pm
No new posts IMS Database backup info ashek15 IMS DB/DC 14 Wed Nov 16, 2016 5:29 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us