IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Can we alter a VIEW?


IBM Mainframe Forums -> Mainframe Interview Questions
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
srini_gunja
Currently Banned

New User


Joined: 24 Aug 2005
Posts: 7

PostPosted: Fri Nov 03, 2006 3:12 pm
Reply with quote

Please let me know if views can be altered and syntax if at all they r altered

Thanks & Regards,
Srini
Back to top
View user's profile Send private message
UmeySan

Active Member


Joined: 22 Aug 2006
Posts: 771
Location: Germany

PostPosted: Fri Nov 03, 2006 3:25 pm
Reply with quote

Hi !

As i know, actually, there is no way to alter a view, alias, synonym,
distinct type or trigger.


Plse correct me if I'm wrong
Regards, UmeySan
Back to top
View user's profile Send private message
sbpati

New User


Joined: 11 Oct 2006
Posts: 11

PostPosted: Fri Nov 03, 2006 3:32 pm
Reply with quote

Hi Srini,

What san wrote is correct to my knowledge.There is no way to alter Views.
But they can be regenerated with the ALTER VIEW statement.

Correct me if I am wrong.

sbpati
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Mainframe Interview Questions

 


Similar Topics
Topic Forum Replies
No new posts DROP & ALTER PARTITION-PBR DB2 0
No new posts SET PATH in View DDL DB2 2
No new posts REXX code to expand copybook in a cob... CLIST & REXX 2
No new posts Issues with VIEW DATASET Command CLIST & REXX 2
No new posts Difference when accessing dataset in ... JCL & VSAM 7
Search our Forums:

Back to Top