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
 

 

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: 10274
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: 4649
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: 10274
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 REXX to get the all datasets name parasmalik20 CLIST & REXX 5 Tue Jul 18, 2017 9:10 pm
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 18 Thu Jul 13, 2017 2:11 pm
No new posts How system know which REXX to excute? jackzhang75 CLIST & REXX 14 Thu Jul 06, 2017 1:09 am
No new posts Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm
No new posts REXX - Dynamic file Creation d_sarlie CLIST & REXX 7 Tue Jun 27, 2017 7:30 pm


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