Name some fields from SQLCA
What is clone table?
if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records
Usually, which is more important for DB2 system performance - CPU processing or I/O access?
wt is view ? wht r the restrictions for view ?
How would you print the output of an SQL statement from SPUFI?
How will you delete duplicate records from a table?
List out the buffer pools in db2
Normalization in DB2 – first normal form, second normal form
What is IMAGECOPY ?
why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2
Where are plans stored?
when does the SQL statement gets executed when you use cursor in the application programming ?