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

Creation of Index
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
madhand

New User


Joined: 04 May 2005
Posts: 10
PostPosted: Fri Mar 03, 2006 2:54 pm
 Reply with quote
Hi Friends,

pls let me know whether we can create an Index on a DB2 view?

Thanks
Madhan.
Back to top
View user's profile Send private message
DavidatK

Active Member


Joined: 22 Nov 2005
Posts: 700
Location: Troy, Michigan USA
PostPosted: Sat Mar 04, 2006 12:31 am
 Reply with quote
No,

Quote:

table-name
Identifies the base table or declared temporary table on which the index is created. The name must identify a table that exists at the current server. (The name of a declared temporary table must be qualified with SESSION.) The name must not identify a created temporary table.



This should have been posted in the DB2 forum,

Dave
Back to top
View user's profile Send private message
ragshere

New User


Joined: 20 Dec 2004
Posts: 70
PostPosted: Sat Mar 04, 2006 12:20 pm
 Reply with quote
Hi,
You can not create a index on the views. We can create index only on tables.


Thanks
Rags
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 -> DB2

 

Similar Topics
Topic Forum Replies
No new posts Cobol file using index COBOL Programming 2
No new posts DL/I status code AK for GU call using... IMS DB/DC 1
No new posts JCL sort card for file creation condi... DFSORT/ICETOOL 4
No new posts VSAM KSDS CREATION AND LOAD WITH RAND... JCL & VSAM 1
No new posts DataSet member creation failed with B... Java & MQSeries 15
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us