View previous topic :: View next topic
|
Author |
Message |
Amb
New User
Joined: 12 Mar 2010 Posts: 64 Location: India
|
|
|
|
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 |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
-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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
Back to top |
|
|
Pedro
Global Moderator
Joined: 01 Sep 2006 Posts: 2546 Location: Silicon Valley
|
|
|
|
-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 |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1788 Location: Bloomington, IL
|
|
|
|
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 |
|
|
daveporcelan
Active Member
Joined: 01 Dec 2006 Posts: 792 Location: Pennsylvania
|
|
|
|
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 |
|
|
Amb
New User
Joined: 12 Mar 2010 Posts: 64 Location: India
|
|
|
|
Thanks a lot guys for the quick response |
|
Back to top |
|
|
MBabu
Active User
Joined: 03 Aug 2008 Posts: 400 Location: Mumbai
|
|
|
|
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 |
|
|
|