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
 

 

What is an ISPF table and why is it used for

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> TSO/ISPF
View previous topic :: :: View next topic  
Author Message
Amb

New User


Joined: 12 Mar 2010
Posts: 64
Location: India

PostPosted: Tue Mar 23, 2010 4:41 pm    Post subject: What is an ISPF table and why is it used for
Reply with quote

Hi,

Can any one tell me
-what is an ISPF table and why is it used for?
-what is the difference between ISPF table and a DB2 table?
-How to view an ISPF table on mainframes?

Please let me know the answers for the above questions.
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Tue Mar 23, 2010 4:56 pm    Post subject:
Reply with quote

-what is an ISPF table and why is it used for?
It is a table created using ISPF. It can be used for whatever the application designer wants to use it for

-what is the difference between ISPF table and a DB2 table?
Theorectically nothing, they are both tables. Just with different access methods.

-How to view an ISPF table on mainframes?
With the ISPF TBDISP command
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10211
Location: italy

PostPosted: Tue Mar 23, 2010 5:10 pm    Post subject: Reply to: ISPF table
Reply with quote

see
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/Shelves/ISPZPM61
Back to top
View user's profile Send private message
Pedro

Senior Member


Joined: 01 Sep 2006
Posts: 2025
Location: Silicon Valley

PostPosted: Tue Mar 23, 2010 7:40 pm    Post subject: Reply to: ISPF table
Reply with quote

-what is an ISPF table and why is it used for?
The main reason you would want to use an ISPF table is to be able to display it easily.

-what is the difference between ISPF table and a DB2 table?
As Expat said, they use different access methods. The old rule of thumb for ISPF tables was that you would get reasonable performance up to around 10,000 rows, but might get poor performance beyond that. I think DB2 tables can get significantly bigger.

-How to view an ISPF table on mainframes?
use the TBDISPL service. See ISPF Services Reference manual
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1746
Location: Bloomington, IL

PostPosted: Tue Mar 23, 2010 8:08 pm    Post subject:
Reply with quote

Note that DB2 is a data base management system; there is no equivalent in ISPF, so if, say, two users are trying to update the same table simultaneously, handling the conflicts is entirely up to the code (and the coder).
Back to top
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 646
Location: Pennsylvania

PostPosted: Tue Mar 23, 2010 8:18 pm    Post subject:
Reply with quote

Working with ISPF tables can produce very nice results, since they work well with ISPF Panels.

They can also be fustrating and difficult at times as well.

I do no reccomend that novices in TSO/ISPF/REXX programing take on the challenge, unless you are good at reading manuals, and good with rejection.

Coming here for ongoing help will prove to be difficult to get the desired results. It is all about trial and error and error and error.
Back to top
View user's profile Send private message
Amb

New User


Joined: 12 Mar 2010
Posts: 64
Location: India

PostPosted: Tue Mar 23, 2010 10:33 pm    Post subject: Reply to: What is an ISPF table and why is it used for
Reply with quote

Thanks a lot guys for the quick response icon_smile.gif
Back to top
View user's profile Send private message
MBabu

Active User


Joined: 03 Aug 2008
Posts: 401
Location: Mumbai

PostPosted: Wed Mar 24, 2010 2:05 am    Post subject:
Reply with quote

Let me add one more thing... a general rule is that an ISPF table should not be used as a database. They are difficult to share, though it is possible) , there is no COMMIT/BACKOUT mechanism and they are only written to disk when they are closed, so an ISPF crash will lose changes. Performance is good because they are in storage, but don't use REXX and TBDISPL together for large tables (for reasons that are beyond the scope of the basic questions).

DB2 = Database
ISPF table = NOT database
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 -> TSO/ISPF 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 SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
No new posts ISPF program to set SCRNAME prino TSO/ISPF 5 Fri Sep 30, 2016 2:18 pm
No new posts Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm
No new posts I am unable to use SWAPBAR ON command... mrsidhu12 TSO/ISPF 3 Thu Sep 01, 2016 1:10 pm


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