|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions Group by controls the presentation of the rows, order by controls the presentation of the columns for the results of the SELECT statement. Latest Answer : Group By forms Groups (of course), but this means it also SORTS; but it will also retrieve a DISTINCT RECORD SETORDER BY Sorts by the columns included in the Statement, and does not retrieve DISTINCT Records.Neither determines the order of the columns ... The database descriptor, DBD is the DB2 component that limits access to the database whenever objects are created, altered or dropped. To maintain the integrity of DB2 objects the DBD permits access to only on object at a time. Lock contention happens if several objects are required by contending application processes simultaneously. SPUFI stands for SQL processing using file input. It is the DB2 interactive menu-driven tool used by developers to create database objects. Latest Answer : SPUFI : SQL Processing Using File Input, it supports the on-line execution of SQL statements from a TSO terminal ... Primary key and foreign key columns; columns that have unique values; columns that have aggregates computed frequently and columns used to test the existence of a value. A multiple index is not one index but two indexes for two different columns of a table. A composite index is one index made up of combined values from two columns in a table. If two columns in a table Latest Answer : if an index is created on more than one column ,which r frequently used in where clause of select statement. it will show the effect in increace in performance . ... For a clustered index DB2 maintains rows in the same sequence as the columns in the index for as long as there is free space. DB2 can then process that table in that order efficiently. Latest Answer : Clustered index is unique for any given table and we can have only one clustered index on a table. The leaf level of a clustered index is the actual data and the data is resorted in case of clustered index ... Latest Answer : To answer the original question, for many releases only one column could appear in the result table of a subquery. As of Version 7 of DB2 the result of a subquery is equivalent to a fullselect which means that 750 columns can appear. ... Read Answers (4) | Asked by : jnana How to retrieve n-th row ie n-th record of any table irrespective of the columns and the values present in the table without using ROWID(As it is not supported in DB@)? Read Answers (9) | Asked by : Thenmozhi Rajendran How do I see the table definitions (columns, data types of columns, constraints or default values set etc) of a table in QMF? I tried 'DESCRIBE TABLE' but didn't work (not able to execute in QMF). I can see the DCLGEN but looking for a way to see the actual table definition?
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
