IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Database for the REXX Applications?


IBM Mainframe Forums -> CLIST & REXX
Post new topic   Reply to topic
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
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

Global Moderator


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

PostPosted: Fri Nov 23, 2007 8:24 pm
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
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: 2358
Location: Israel

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

Why can't you use ISPF tables?

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

Moderator Emeritus


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

PostPosted: Sat Nov 24, 2007 11:51 pm
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
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: 2358
Location: Israel

PostPosted: Mon Nov 26, 2007 11:51 am
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

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Mon Nov 26, 2007 12:54 pm
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
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: 2358
Location: Israel

PostPosted: Mon Nov 26, 2007 3:54 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> CLIST & REXX

 


Similar Topics
Topic Forum Replies
No new posts Compile Several JCL JOB Through one r... CLIST & REXX 4
No new posts Running REXX through JOB CLIST & REXX 13
No new posts Error to read log with rexx CLIST & REXX 11
No new posts isfline didnt work in rexx at z/OS ve... CLIST & REXX 7
No new posts run rexx code with jcl CLIST & REXX 15
Search our Forums:

Back to Top