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
 
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: 10326
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: 2086
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: 1777
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: 683
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
No new posts Update table without cursor Ron Klop DB2 3 Wed Oct 11, 2017 1:06 pm
No new posts Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts MQ command in option 6 of ISPF! Vignesh Sid All Other Mainframe Topics 3 Tue Sep 26, 2017 6:01 pm
No new posts Conditional highlighting of rows in I... packerm CLIST & REXX 2 Thu Sep 21, 2017 6:50 pm
No new posts Insert a Row_number into table useit DB2 2 Tue Sep 19, 2017 1:07 pm

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