Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
REXX program to modify ISPF table

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

New User


Joined: 02 Feb 2007
Posts: 10
Location: chennai

PostPosted: Sat Apr 28, 2007 1:31 pm    Post subject: REXX program to modify ISPF table
Reply with quote

I want to include one more field in the ISPF table
Can anybody tell me how can we modify the strucutre of the ISPF table using a REXX program.

Mustafa
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10374
Location: italy

PostPosted: Sat Apr 28, 2007 8:27 pm    Post subject: Re: REXX program to modify ISPF table
Reply with quote

Quote:
I want to include one more field in the ISPF table


ISPF table is a very generic term,
which table You want to update?
I do not see any use in adding fields,
ISPF will never use them,
furthermore ISPF might change it' s internal tables layout

be a little more specific on what You want to do

regards

e.s
Back to top
View user's profile Send private message
superk

Moderator Team Head


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

PostPosted: Sat Apr 28, 2007 11:04 pm    Post subject: Re: REXX program to modify ISPF table
Reply with quote

I presume that Mustafa is asking about a specific user-defined table.

Off the top of my head, I would imagine the process to be

- TBOPEN the existing table.
- use TBQUERY to determine the existing index and field names.
- use a loop with TBGET to retrieve each table row, storing the data as either REXX stem variables or into a temporary dataset.
- TBCLOSE the existing table.
- TBCREATE the new table, with the old table's name, indexes and fields, with the new field added.
- TBADD the rows to the new table.
- TBCLOSE the new table.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10374
Location: italy

PostPosted: Sun Apr 29, 2007 12:20 am    Post subject: Re: REXX program to modify ISPF table
Reply with quote

Hi superk!

what bothers me in this kind of question is that the poster does not give anybody the slightest idea that he tried to help himself before asking...

I know I was being picky, in my remark, but given your assumption, reading the application which manages the user table should have given him a little hint on how to proceed and ask a question more apt to get help

If I were a founding father I would require that all the posters should declare, before posting, to have read and understood the following howto

http://www.catb.org/~esr/faqs/smart-questions.html

quote form Eric S. Raymond
Quote:
I get a lot of letters from people asking if they can link to pages on my site, mirror them, do translations, etc. Here is my policy:

* You may link to any portion of this site that you wish.
*


A perfectly correct, logically, answer to the first post would have been a simple
YES

regards

e.s
Back to top
View user's profile Send private message
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2360
Location: Israel

PostPosted: Sun Apr 29, 2007 9:55 am    Post subject:
Reply with quote

Most of the ISPF table-services which allow a table update (like TBADD, TBMOD, TBPUT) allow the use of extension variables. Please refer to the fine manual for more information.

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
No new posts Looping REXX - unable to interrupt RAVISANKAR07 CLIST & REXX 3 Wed Dec 06, 2017 1:08 pm
No new posts The same REXX program doesnt work for... jackzhang75 CLIST & REXX 5 Wed Dec 06, 2017 2:51 am
No new posts Rexx - File tailoring samzee71 CLIST & REXX 10 Thu Nov 30, 2017 10:47 pm
This topic is locked: you cannot edit posts or make replies. Rexx to Grab ISMF Information. upendrasri All Other Mainframe Topics 16 Sun Nov 26, 2017 12:35 am
No new posts Rexx to send an email without SMTP Se... upendrasri All Other Mainframe Topics 12 Sun Nov 19, 2017 7:59 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us