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
 

 

alias and view

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
kumar_ngl
Warnings : 1

New User


Joined: 05 Aug 2005
Posts: 50
Location: chennai

PostPosted: Fri Aug 05, 2005 12:00 pm    Post subject: alias and view
Reply with quote

hay all,

plz clear me the differents between alias and view. will alias require physical storage?? and how abt view???

thanx,
kumar.p.v
Back to top
View user's profile Send private message

priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1452
Location: Chicago, IL

PostPosted: Fri Aug 05, 2005 12:16 pm    Post subject: Re: alias and view
Reply with quote

Hi Kumar,

VIEW : is a set of some columns from one or more table, to fetch data from a database. Also termed as vertual table.

ALIAS: is used to refer a table or a VIEW by alternative name.

Quote:
will alias require physical storage?? and how abt view???

VIEW doesnt.

Corrections welcome.

Regards,

Priyesh.
Back to top
View user's profile Send private message
kumar_ngl
Warnings : 1

New User


Joined: 05 Aug 2005
Posts: 50
Location: chennai

PostPosted: Fri Aug 05, 2005 12:30 pm    Post subject:
Reply with quote

hi priyesh,

thanx for ur answer


kumar.p.v
Back to top
View user's profile Send private message
gowtham_srgp

New User


Joined: 09 Jun 2005
Posts: 38

PostPosted: Tue Aug 16, 2005 7:01 pm    Post subject: Re: alias and view
Reply with quote

kumar_ngl wrote:
hay all,

plz clear me the differents between alias and view. will alias require physical storage?? and how abt view???

thanx,
kumar.p.v




hai.... alias is an alternate name given to a base table. it helps us to refer the base tabel without the full qualifiers. view is going to be a window of the base tabel. it does reside separate whereas, my alias has a separate storage.


corrections welcomed.....


gowtham
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 -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to see VIEW definition from BMC c... rohanthengal DB2 1 Thu May 04, 2017 1:50 pm
No new posts Copy load modules and alias vasanthz IBM Tools 5 Thu Apr 20, 2017 6:31 am
No new posts Help Needed with View Direct shailesh_do CA Products 2 Wed Jul 13, 2016 10:39 am
No new posts how to find clist's or view library Andrew Hsia CLIST & REXX 4 Tue Jun 28, 2016 6:07 pm
No new posts Report view in Mobile devices Robert Sample All Other Mainframe Topics 0 Thu Jun 23, 2016 7:05 pm


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