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

REXX program to modify ISPF table


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

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Sat Apr 28, 2007 8:27 pm
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

Global Moderator


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

PostPosted: Sat Apr 28, 2007 11:04 pm
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

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Sun Apr 29, 2007 12:20 am
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: 2358
Location: Israel

PostPosted: Sun Apr 29, 2007 9:55 am
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 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 Using API Gateway from CICS program CICS 0
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 Load new table with Old unload - DB2 DB2 6
Search our Forums:

Back to Top