|
View previous topic :: View next topic
|
| Author |
Message |
aneeshco
New User
Joined: 29 Apr 2008
Posts: 6
Location: tvm
|
|
|
|
Can anyone please tell me what's the difference between tableBASE data table and views?
I have just started working with tableBASE and we create both data tables and views with the same name. |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
Tables store data.
Views are a way to "look at" a table.
Usually a view with the same name as a table contains all of the columns of that table. |
|
| Back to top |
|
|
aneeshco
New User
Joined: 29 Apr 2008
Posts: 6
Location: tvm
|
|
|
|
Thanks.
I have inserted some rows into the tableBASE table, but I cannot see those rows when I browse through the view option in tablesONLINE.
Do we need to insert separately in both tables and views?
Please clarify |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| I have inserted some rows into the tableBASE table, |
How were the inserts verified?
| Quote: |
| cannot see those rows when I browse through the view option |
On every system i've used, there is a big difference between a "view" (which is part of the database structure) and the view option (which allows things to bee seen but not updated). . . |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
| Back to top |
|
|
aneeshco
New User
Joined: 29 Apr 2008
Posts: 6
Location: tvm
|
|
|
|
[quote="dick scherrer"]Hello,
| Quote: |
| How were the inserts verified? |
I was able to see the data that I had inserted using the browse table option(option1) in tablesONLINE. Where as when I select the browse rows(option2), it says the view is empty.
Does this mean we have to insert the data both in table and view?
I have created the view using the TBEXEC utility(JCL) and giving TTYPE=V |
|
| Back to top |
|
|
aneeshco
New User
Joined: 29 Apr 2008
Posts: 6
Location: tvm
|
|
|
|
| Quote: |
are You referring perchance to tableBase as in this link ??
it is not an IBM tool ! |
Yes, I am.
Sorry, I guess, I posted it in the wrong section. |
|
| Back to top |
|
|
|
|
