Once you create a view, where would information about the
view be stored?
in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records
Can you search give an array in the WHERE clause of a db2 query?
What is concurrency?
in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?
What are the various data types available in db2?
Define check constraint.
what is the use of commit ? and what is the syntax?
How to select the duplicate rows from a table?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...
What is an inner join, and an outer join ?
what is main use of table space and index object? please its urgent
5 Answers CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,